Hi Guys!
My Formula looks like this for identifying unique records
=IF(K20,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

Hi Vicki,
take a look at CPearson web

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

"VickiMc" wrote:

Hi Guys!
My Formula looks like this for identifying unique records
=IF(K20,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

"Eduardo" wrote:

Hi Vicki,
take a look at CPearson web

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

"VickiMc" wrote:

Hi Guys!
My Formula looks like this for identifying unique records
=IF(K20,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

Hi,

Please lookup my article here

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"VickiMc" wrote in message
...
Hi Guys!
My Formula looks like this for identifying unique records
=IF(K20,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