Hi All,
This is my 1st post and its a very simple request. I did try and search other posts but so many of them it's killing my eyes.
This is what I want:-
I have a heading in the form of a row of numbers from 1 to 10 in each cell. Under each of these numbers it will show another numbers. I call this set, Found numbers.
Example:
Heading 1 2 3 4 5 6 7 8 9 10
Found numbers 5 2 0 2 6 4 0 2 1 5
I then need a function that looks at Found numbers 0 and just show me the related heading number. So in this case, Found numbers 0 is under the heading 3 and also 7. So it will just show 3 7 in my designated cells. Likewise, Found 2 will show 2 4 8
I hope you understand that, I know its sounds like a total novice explaining it, I am.
Thanks.
Bookmarks