Formula - line item of unique item matching criteria.xlsx
The attached file has 2 sheets: Formula and Data.
The formula sheet is the one where I need the formula. The yellow cells show the result the formula should return.
The data sheet has 2 columns. The first shows the row number of each item. The second column shows the cost type.
The formula needs to return the row number of the first "Accrual" in the data tab. The next result of the formula needs to show the row number of the second "Accrual". The next result of the formula needs to show the row number of the third "Accrual". etc.
Thanks.
Bookmarks