I'm trying to use a specific value in Column A (Table: 01-DD102 for example) to find the related values in column C using the unique Trans ID. I need to return the values in the column in the same descending order then stop when I hit a blank cell so I can find the next value in column A using the same type of value from column C to return the next set of values from that column and stop at the next blank cell, and so on.
I'll then use those values to index match the Voucher Amount, Fee Amount and Total Amount columns for each Trans ID.
Sample data
I'll then use those values to index match the Voucher Amount, Fee Amount and Total Amount columns for each Trans ID.
Sample data