Take me to the number

  • Thread starter Thread starter calibansfolly
  • Start date Start date
C

calibansfolly

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?
 
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.
 
Back
Top