Reverse Unique Values

K

Ken

Excel2003 ...

Col H contains up to 100 unique values
Col D contains Values L1, L2, L3 out to L50 (100 repeats of this set)

In Col C ... I wish a formula to return:

1st set L1-L50 ... 1st unique value from Col H
2nd set L1-L50 ... 2nd unique value from Col H
3rd set L1-L50 ... 3rd unique value from Col H
etc etc until all unqiue values are populated in Col C (up to 100 sets)

Thanks for the guidance ... Kha
 
E

eksh

Hi,

I'm not sure the reason that you emphasize on unique value.
I hope I understood your question.
I would suggest this formula on C1 and pls drag down for other cells:
=INDEX($H$1:$H$100,COUNTIF($D$1:D1,D1))
The outcome will be something like this (it doesn't care col H value is
unique or not, just choose n-th value based on n-th set L1-L50)
Col C Col D Col H
2 L1 (1st set) 2
2 L2 1
2 L3 3
2 L4 4
2 L5 5
..
..
..
..
..
2 L48
2 L49
2 L50 (1st set end)
1 L1 (2nd set)
1 L2
1 L3
1 L4
1 L5
1 L6
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top