Hello,
what functions I have to use to solve this problem.
I have a table, with 3 columns (1,2,3). Below that are a lot of numbers (0 and 1).
I want to know the ROW of the latest number 1 in each column. Number 1 can be a duplicate in each column and I only want
to get the row of the latest number one ...
For better understanding I upload this excel document: one.xlsx
P.S. There is an example in the document how the results should be like.
Bookmarks