smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In columns A and B (A2:B600) I have a lists of customer names and their buying prices in columns D and E (D2:E600).
When customer name is in column A his buying price is in column D (same row of course) and when customer is in column B his bying price is in column E.
I'm trying to analyze the future buying prices for each customer, more precisely the 3rd future buying price (from referent/current one) for each customer and to place those results into columns F and G.
When name is in column A result (3rd future buying price) should be in column F and when name is in column B result should be in column G.
example (for customer Name1).
<tbody>
</tbody>
results explanation: for cell A2 (Name1 first occurrence) 3rd future occurence (Name1) is in cell A7 and buying price for that 3rd future occurence is in cell D7 = 2, so result in cell F2 is equal to 2
note: just as an option (if possible) I would like also to have reverse formula (3rd past buying price for each customer)
In columns A and B (A2:B600) I have a lists of customer names and their buying prices in columns D and E (D2:E600).
When customer name is in column A his buying price is in column D (same row of course) and when customer is in column B his bying price is in column E.
I'm trying to analyze the future buying prices for each customer, more precisely the 3rd future buying price (from referent/current one) for each customer and to place those results into columns F and G.
When name is in column A result (3rd future buying price) should be in column F and when name is in column B result should be in column G.
example (for customer Name1).
A | B | C | D | E | F | G | H | |
1 | results | results | ||||||
2 | Name1 | 3 | 2 | |||||
3 | ||||||||
4 | Name1 | 8 | 25 | |||||
5 | Name1 | 12 | 17 | |||||
6 | ||||||||
7 | Name1 | 2 | ||||||
8 | Name1 | 25 | ||||||
9 | Name1 | 17 | ||||||
10 | .... | .... |
<tbody>
</tbody>
results explanation: for cell A2 (Name1 first occurrence) 3rd future occurence (Name1) is in cell A7 and buying price for that 3rd future occurence is in cell D7 = 2, so result in cell F2 is equal to 2
note: just as an option (if possible) I would like also to have reverse formula (3rd past buying price for each customer)
Last edited: