Hi,
I have a column of data in Excel that is shown as below lets say from cells A2:A10, I have tried a simple 'IF' formula but failed as I wanted to have 14 columns to the right of A1 starting at B2 that had the 14 headers ( 1 -14) and then if A2 had 1,2,3,6,7,11 I wanted B2, C2, D2, G2, H2, L2 to show 'True' or 'x' if no match.
1,2,3,6,7,11
3,13
1,2,3,5,6,7,11,12
1,2,3,8
1,8
1,2,3,7
1
11
14
Many thanks in advance
Garry
Bookmarks