Unique Records

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I often have the need for "Unique Records" ... to achieve
this I use "Advanced Filter & check Unique Records" ...
However, this method doesn't appear very User Friendly ...

Above said ... is there a formula that can be entered to a
cell something like ... =unique(range,col1,col2,col3) or a
way to cut/copy/paste special "unique records" only???

Basicaly, is there a simpler way to obtain "unique
records" than using "Advanced Filter"??? ... Thanks ... K
 
Andy ... Ok I visited this site & have some useful
info ... However, how do I write formula in Col E that
will extract "unique records" from "range" (A1:D8) & place
in "range" (E1:H6) when I need to compare data in a range
of rows that cover multiple columns??? "Advance Filter"
will do this perfectly, but I was looking for an easier
way ... Please see sample data below ... Left = Data ...
Right = "unique records" ... Thanks ... K

Col A Col B Col C Col D | Col E Col F Col G Col H
AAAA Ken A 10 | AAAA Ken A 10
BBBB John B 15 | AAAA Ken C 10
AAAA Ken C 10 | AAAA Fred A 10
BBBB John B 15 | BBBB John B 15
CCCC Sue D 15 | CCCC Sue D 10
CCCC Sue D 10 | CCCC Sue D 15
AAAA Fred A 10 |
AAAA Ken C 10 |
 
Ken

Tough one!! If I was doing it, I would sort the first list on multiple
columns and add a helper column. There will be an easier way with a macro. I
suggest you repost your question, with the extra detail you gave me below,
and I'm sure the ng will come up trumps!!

Andy
 
What is hard about advanced filter? This is one of the easiest things you
can do. Unfortunately it does require that you copy the data to cells in the
same worksheet, so you cannot filter the unique items from sheet1 over to
sheet2. You would first have to filter them to a spot in sheet1 and then
copy them to another sheet. Also, you can write code to operate the advanced
filter for you, therefore you would only have the pain while you were
writing the code. Of course, you would probably avoid the pain by getting
one of us to write the code for you. No problem.
Richard Choate

Andy ... Ok I visited this site & have some useful
info ... However, how do I write formula in Col E that
will extract "unique records" from "range" (A1:D8) & place
in "range" (E1:H6) when I need to compare data in a range
of rows that cover multiple columns??? "Advance Filter"
will do this perfectly, but I was looking for an easier
way ... Please see sample data below ... Left = Data ...
Right = "unique records" ... Thanks ... K

Col A Col B Col C Col D | Col E Col F Col G Col H
AAAA Ken A 10 | AAAA Ken A 10
BBBB John B 15 | AAAA Ken C 10
AAAA Ken C 10 | AAAA Fred A 10
BBBB John B 15 | BBBB John B 15
CCCC Sue D 15 | CCCC Sue D 10
CCCC Sue D 10 | CCCC Sue D 15
AAAA Fred A 10 |
AAAA Ken C 10 |
 
Back
Top