View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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?