N
NN
I need to create a macro that chooses the top 80% of the cells in a column,
the macro.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
I had 50 numbers in A1:A50 and attached this conditional format
(Format|Conditional Format)
=(A1>=LARGE($A$1:$A$100,20) ) then red background
to pick out the top 80% of the numbers.
Any help?
(Format|Conditional Format)
=(A1>=LARGE($A$1:$A$100,20) ) then red background
to pick out the top 80% of the numbers.
Any help?
J
JE McGimpsey
Assuming by "top 80%" you mean the largest 80% of numeric values, do you
need to use a macro?
One could use conditional formatting:
CF1: Formula is =A1>=PERCENTILE(A:A,0.2)
Format1: <patterns>/<desired color>
OTOH, if you *have* to use a macro, the Application.Percentile method
should be helpful.
need to use a macro?
One could use conditional formatting:
CF1: Formula is =A1>=PERCENTILE(A:A,0.2)
Format1: <patterns>/<desired color>
OTOH, if you *have* to use a macro, the Application.Percentile method
should be helpful.
B
Bob Phillips
80% of value or 80% of number. For instance if the top value is 100 and
there are 50 items, do you want anything over 20 in value, or the top 40
items.
If the latter, use conditional formatting with a formula of
=A1>=MAX(A:A)*20%
there are 50 items, do you want anything over 20 in value, or the top 40
items.
If the latter, use conditional formatting with a formula of
=A1>=MAX(A:A)*20%