hello , please I have been trying with formulas and didn't work
Please I have 24 item in E9:E32 I can only select 5 item and they must be placed in either P7,P16,P25,P34,P42
if I unselect on of the 5 item them the corresponding cell in either (P7,P16,P25,P34,P42 ) must be empty
for example if I select for instance one item in E10 if shall be in one of (P7,P16,P25,P34,P42 ) let say P16 then the
number in R24 must the shown in M10
please any help see attachment,
Bookmarks