extracting unique #'s from multiple columns

M

matmich

I have some data in two columns and i want to extract the uniqu
records, I would use a combination of the if and countif if I wer
only dealing with 1 column but with two columns I am stumped.

EX

order# box#
123 1
123 1
123 2
123 3
125 65
125 65

i NEED TO BE ABLE TO SEPERATE AND COUNT THE UNIQUE RECORDS

123 1
123 2
123 3
125 6
 
F

Frank Kabel

Hi
one way:
- create a helper column C
- in C1 enter the formula:
=A1 & "^" & B1
- copy this down and use your approah on this column
 
D

Dave Peterson

Another way:

Say your data is in C1:d7
select C1:D7
data|filter|advanced filter
check the unique records only

Copy those visible cells (you can include more columns in your copied range)
to a new location.
 
Top