I need a formula that will flag a cell if it is in the top 80% of the range total value. Column A = Salesman Column B = Material Column C = Revenue Column D = Top 80% flag?. Need it to see if the material is in the top 80% for each Salesman's total sales.
Flag if data is in top 80% of range
-
-
Re: Flag if data is in top 80% of range
Hi goin4boge, you could try something like:
=IF(C1>=MAXIFS(C:C,A:A,A1,B:B,B1)*0.8,"Top 80% of "&B1&" for "&A1,"")
-
Re: Flag if data is in top 80% of range
Quotelooks like maxif(s) was added for 2016
My bad - I always assume eveyone else uses the same version
you know what they say... to assume makes an "ass" of "u" and "me"!I'll keep playing...
-
Re: Flag if data is in top 80% of range
Ah okay, yes that makes sense. It's bed time for me here in the UK though I'm afraid so will have to take a look tomorrow if no-one has answered by then. Best of luck
-
Re: Flag if data is in top 80% of range
aha, of course - helper columns. I mean, obviously I just wanted you to get there by yourself.
Just testing....
...honest
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!