Newbie Help! Please (correct version)

  • Thread starter Thread starter Tom Burton
  • Start date Start date
T

Tom Burton

Hi I have a spreadsheet which has a record of places in which certain
occurences have taken place looking somthing like this...


¦-----A-----¦-----B-----¦-----C-----¦-----D-----
Place 1 data data data
Place 2 data data data
Place 3 data data data
Place 1 data data data
Place 4 data data data
Place 2 data data data
Place 1 data data data
Place 1 data data data
Place 6 data data data
Place 1 data data data
Place 2 data data data
Place 1 data data data

one sheet is 6000 records long and one 40'000 records long
There are approx 600 difference places recorded

and without going through them by hand i need to find a way of ( if
possible) getting excel to output me a list the different places, preferable
each place in a seperate cell.

the only way i can seem to do this is by sorting the sheet by place and then
working back through by hand deleting the multiples,

any ideas how i can make it happen?

TIA

HNR

Tom
 
Tom,

For the example i'll assume your data is in A1:D100
Sort your data (ascending).
In E1 put = A1
In E2 put =INDEX(A2:A$100,MATCH(E1,A2:A$100) + 1)
Drag that formula down until it starts producing 0's

Dan E
 
Back
Top