If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple results of Unique Values
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 |
#2
|
|||
|
|||
Multiple results of Unique Values
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 |
#3
|
|||
|
|||
Multiple results of Unique Values
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 |
#4
|
|||
|
|||
Multiple results of Unique Values
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 |
Thread Tools | |
Display Modes | |
|
|