In excel, I have row A labled 1 to 10 ending at A10. Further down in my spreedsheet I have 5 rows (J - N) of numbers consisting of 5 varible numbers from 1 - 10, never repeating in each row. I want to write a fromula in rows B - F to take the data from rows J - N, and place it in the proper colums labled 1 - 10. i.e If row J has the numbers 1,3,4,8,9 these numbers should appear in B1, B3, B4, B8, & B9. If row K is numbered 2,5,6,8,9 they should appear in C2, C5, C6, C8, C9. I thought I had it with the IF function, I was close, but not close enough.
Tags: