Take me to the number
Try this...
Highlight Column A
Go to Format-- Conditional Formatting
Then select Formula is instead of Cell Value is and enter this formula
=COUNTIF($A$1:$A$36533,A1)=6
Copy it exactly as it is.
" wrote:
I've used this formula to count the number of order numbers that
appear X number of times in one column:
=SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=X,1))
There is one order number that appears 6 times in column A and I need
to find it. Is there a way to copy that order number or at least use
conditional formatting to highlight it? Suggestions?
|