selected item from column to line

I have a list of 20 cities in K1:20 and they can be selected from a drop down menu in column A2:A22. I want then to randomly pick 6 out of 20 and these 6 cities must to appear in a line A1, B1, C1, D1, F1, and G1
On cell A1 I have used the
IF ( A2=K1,K1, IF(A3=K1,K1……………………….A22=K1,K1,IF(A2=K2,K2………A22=K3,K3)


it seem to be an endless formula is there another way to make it easy ???


Thanks

Originally Posted by RobertMika

Attachment 287712
Please see attached

Thank you for the information , but still just one little think I have applied it to a fleet of airplanes and for each selected plane there are men power assigned to it
therefore when I select the OK box I want the cell to be empty and the other cell should not shift to another one so that I can have a control of the men power
please I.e If I check to ok Box on D2-EVW , then the D2-FFJ should not move to the cell where D2-EVW . is there away to do so
Thanks

Originally Posted by kuzna26

Thank you for the information , but still just one little think I have applied it to a fleet of airplanes and for each selected plane there are men power assigned to it
therefore when I select the OK box I want the cell to be empty and the other cell should not shift to another one so that I can have a control of the men power
please I.e If I check to ok Box on D2-EVW , then the D2-FFJ should not move to the cell where D2-EVW . is there away to do so
Thanks

Hello
My desired outcome is when for example you uncheck the box for 6 airplanes
they will appear in these lines according to the selection
AC8 = D2-EVW, AD8 =D2-EVL , AE8= D2-EVY , AF8= ERQ , AG8=EVB , AH8=FVO:
if you check the first airplane entered in AC8 which IS D2-EVW this cell must be empty and the
others cells should not move to AC8 . Unfortunately the way it is now if I check the first entered plane the rest of cells will shift to the left
I don't want the cell to shift.

thank you .

Originally Posted by RobertMika

So where D2-EVW should be placed when you untickted the box?
What if 7 plains will be unticked?

The desired outcome here is to prevent the cells to shift /move when one box is checked: Check the Box of D2-EVW and It shall look like this example

AC8 = Empty, AD8 =D2-EVL, AE8= D2-EVY, AF8= ERQ, AG8=EVB, AH8=FVO

You can only check 6 planes at the time, therefore if you select another airplane it must placed in the place where D2-EVW was.

But from the attached sheet ,please just try to check the Box of D2-EVW you will see that the cell shift and it will look like this

AC8 =D2-EVL, AD8 =D2-EVY, AE8= ERQ, AF8=EVB, AG8= FVO, AH8= Empty

I hope you notice the difference


thank you,

Originally Posted by RobertMika

What's prevents to choose more that 6 plains?
I have ticked aroudn 12 boxes and all entries are in column AB.

no matter how many you ticked , there will be only 6 cells visible therefore the first 6 picked get placed in those visible cells , and the 7th ticked will placed provided that I select one of the of those 6 and so one : But the main ideal here is to keep the cell not to shift
I hope you understand my final outcome

Originally Posted by RobertMika

Which of the are visible?
How can you pick up 7th from 6?

actually u can only pick six :