nader assaleh
Member
Hi,
i attached a file in which M4:M21 (purple colored) are cells that can only accept numbers that are available in B4:B51 (yellow colored).
cell M4 can accept any number or text B4:B51 let us say 11L
M5 can accept any number or text in B4:B51 except 11L and any number or text C4:H4 (yellow colored cells)
and same logic should be applied until all choices are finished.
many thanks
i attached a file in which M4:M21 (purple colored) are cells that can only accept numbers that are available in B4:B51 (yellow colored).
cell M4 can accept any number or text B4:B51 let us say 11L
M5 can accept any number or text in B4:B51 except 11L and any number or text C4:H4 (yellow colored cells)
and same logic should be applied until all choices are finished.
many thanks