Good Day,
I'm trying to figure out how to pull data from my raw data page (Screenshot 1) and transfer certain data to the second spreadsheet (Screenshot 2). I'm having troubles with getting my formula to populate the correct run number.
I'm trying to use Index match function. If I select company 1 then it should populate all of company 1's transactions. But when company one has more than 1 transaction on the same day, the formula doesn't seem to pick up the next #.
I've been playing around with the formula but I can't seem to get it to work.
Any help would be greatly appreciated.
Excel 2010
<tbody>
</tbody>
Excel 2010
<tbody>
</tbody>
<tbody>
</tbody>
I'm trying to figure out how to pull data from my raw data page (Screenshot 1) and transfer certain data to the second spreadsheet (Screenshot 2). I'm having troubles with getting my formula to populate the correct run number.
I'm trying to use Index match function. If I select company 1 then it should populate all of company 1's transactions. But when company one has more than 1 transaction on the same day, the formula doesn't seem to pick up the next #.
I've been playing around with the formula but I can't seem to get it to work.
Any help would be greatly appreciated.
Excel 2010
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Transferor | Transferee | Date | Transfer | Deemed Assets | Deemed Liabilities |
2 | 1 | 2 | 28-Apr-17 | 1234567 | $0.00 | ($72,526.00) |
3 | 2 | 1 | 28-Apr-17 | 1234568 | $0.00 | $72,526.00 |
4 | 3 | 6 | 25-Apr-17 | 1234569 | $0.00 | $0.00 |
5 | 4 | 15 | 25-Apr-17 | 1234570 | $0.00 | $0.00 |
6 | 4 | 5 | 25-May-17 | 1234571 | ($500.00) | ($1,000.00) |
7 | 5 | 4 | 5-Apr-17 | 1234572 | $0.00 | $0.00 |
8 | 1 | 2 | 29-Apr-17 | 1234573 | $500.00 | ($500.00) |
9 | 1 | 8 | 29-Apr-17 | 1234574 | $500.00 | ($500.00) |
<tbody>
</tbody>
Sheet1
Excel 2010
A | B | |
---|---|---|
3 | 1 | |
4 | Date | Run # |
10 | 28-Apr-17 | 1234567 |
11 | 29-Apr-17 | 1234573 |
12 | 29-Apr-17 | 1234573 |
<tbody>
</tbody>
Sheet3
Array Formulas
<tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>