Multiple results of Unique Values

[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

 

[Eduardo]

Hi Vicki,
take a look at CPearson web

http://www.cpearson.com/excel/Duplicates.aspx

 

[VickiMc]

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

 

[Ashish Mathur]

Hi,

Please lookup my article here

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com