Add headers to row 1 (if you don't have them)
create a new column (column D???)
In D2:
=a2&"-"&b2
Drag down your list as far as you need.
Then use the technique at Debra Dalgleish's site to extract the unique entries
for that column:
http://contextures.com/xladvfilter01.html#FilterUR
If you're going to sort that data, you may want to use a formula like:
=text(a2,"000")&"-"&text(b2,"000")
so that they sort nicely.
"C." wrote:
Hi all,
I have the data set below in three separate columns in one worksheet
A3 B3 C3
10 71 120171
10 71 43311
10 71 43312
10 72 101321
10 72 10372
1 421 42101
1 421 42102
I want the data to just match and return the first two rows and
combine it into one cell in another worksheet so it would look like
this (with the dash):
A3
10-71
10-72
1-421
Thanks!
Cheers,
Chris
--
Dave Peterson