Multiple results of Unique Values

  • Thread starter Thread starter VickiMc
  • Start date Start date
V

VickiMc

Hi Guys!
My Formula looks like this for identifying unique records
=IF(K2>0,0,IF(COUNTIF(L$1:L2,L2)=1,MAX(J$1:J1)+1,"")).
What I wanted to know is if there is an addendum to this formula, or should
I be using another, to extract multiple occurances of each record (lets say
3) from a list rather than just the one? (Sort of makes no sense when you
think about it, but...)
Fond Regards,
Vicki
 
Thanks Eduardo. I do have a shortcut to Mr Pearsons website and scrutinsed
the pages you recommended prior to posting my query. It seems to apply mostly
to Conditional Formatting to identify the cells, where as I wanted the
facility to Filter the (calculated) column rather than visually identify them.
Regards
Vicki
 
Back
Top