I want to select a range of lines, which I have done manually so far. However, as the data increases, I have tried to select the row based on the relative spreadsheet, but I don't know how. Here is an example.
Purchased apples spreadsheet Buyer | Day 1 | Day 2 | Day 3 John | 3 | 1 | 1 Adam | 2 | 3 | 3 Anna | 1 | 3 | 2 Price Spreadsheet Item | Price Apple | 10
Now I have to build a third sheet containing the monetary totals, so I have something like this:
Totals Buyer | Credit | Debit | Total John | Formula|Formula| Formula Anna | Formula|Formula| Formula Adam | Formula|Formula| Formula
So the manual method would be to copy the formulas and manually replace the ranges for each user, so that they all match the other tables. What I would like to do is select the rows where the first cell in the row has the same value as the
Totals. In other words:
- Search A: A
- Find John in
Purchased apples spreadsheet
- Found John at rank 7
- Select the range 7: 7.
Is it possible to do it?