Automate List based on a criteria.

**leo73pk** · 07-01-2010, 05:19 AM

I have prepared a sample file which is attached with this thread. In the attached file i have a list of 10 participants (max). I want to updated the list in new column F, based on the number of participants mentioned in cell D1. so if the number of participants in cell D1 change list in column F updates automatically.

**pike** · 07-01-2010, 05:52 AM

Hi leo73pk
in f3 fill down =IF((ROW()-2)<=D$1,B3,"")
in e3 fill down =IF(F3<>"",ROW()-2,"")

**leo73pk** · 07-01-2010, 06:11 AM

Pike,
Thanks very much for your help. it works fine ill appreciate if you could further help to achieve the goal that based on the earler sheet after incorporating your formula, i would like to automatically have their pairs in colum H & I as if after determination of participants their pairs appreas in Colum H & I as

for Three (3) participants pairs are A1 A2, A1 A3, A2 A3.. & they appear in Column H & I

Column H Column I
A1 A2
A1 A3
A2 A3 .