MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Looking for a better way to generate unique lists

Posted by Eric on October 05, 2001 8:46 AM

A user has the following:

and wants to turn it into:
{"target","A","B","C";"a",1,0," ";"a",1,0," ";"b"," ",1,1;"c",3," ",0;"d",0,3," ";"e",1," ",1;"f"," ",2," ";"g",3,2,2;"h",2,1,1;"i"," ",3," ";"j"," ",0," "}

My strategy so far is cumbersome. I copy and paste each of the "target" columns into a single column, run an advanced filter for unique records, paste that to a new location, then use the new list to perform vlookups on the original table.

NE help would be much appreciated! Especially with regard to the generation of the unique list- is there a way to automate this?

Posted by Juan Pablo on October 05, 2001 11:34 AM

Check out #13 (NT)

Posted by Eric on October 05, 2001 8:11 PM

Thanks Juan, that's exactly what I was looking for but...

I know nothing about vb code except how to paste and run it :/
Could you suggest a modification so that the code would combine 3 columns into 1 unique, rather than combining 2 columns?
Thanks again for your time