Hello,
I have tried to solve this by myself but I need some help.
I have a table with numbers from 1 to 9, exactly the same like in this document: In which row is a number.xlsx
I need to know in which row every number appears. For example, it is easy to find a ROW of a number that appears only once, but there are
some numbers that can appear twice or more and for that numbers I need only lower row to be shown.
To clarify, number 6 appears in first and fourth row, but I need only first row as a result.
There is also number 7 that doesn't appears at all, as a result I would like to show 0 (zero).
P.S. The dashes in the first table should not be corrected or deleted, they must stay there as they are.
Bookmarks