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
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