coolhandphil
New member
- Local time
- Today, 07:35
- Joined
- Sep 5, 2014
- Messages
- 6
Hello,
I'm using Excel 2010...
I have a large worksheet (about 12k rows) with three columns of products/prices. I need some formula which will find the price of a barcode at a given date. e.g. what is the price of 10009 on 3/1/15? (It would be at the last provided price, i.e. £1.10). Any ideas?
Here is my data:
Barcode......Date......Price
10009......1/1/15......£1
10009......2/1/15......£1.10
10009......4/1/15......£1.11
10009......5/1/15......£1.09
10010......1/1/15......£0.99
10010......3/1/15......£1.05
10010......4/1/15......£1.09
10010......5/1/15......£1.05
Thanks,
Phil
I'm using Excel 2010...
I have a large worksheet (about 12k rows) with three columns of products/prices. I need some formula which will find the price of a barcode at a given date. e.g. what is the price of 10009 on 3/1/15? (It would be at the last provided price, i.e. £1.10). Any ideas?
Here is my data:
Barcode......Date......Price
10009......1/1/15......£1
10009......2/1/15......£1.10
10009......4/1/15......£1.11
10009......5/1/15......£1.09
10010......1/1/15......£0.99
10010......3/1/15......£1.05
10010......4/1/15......£1.09
10010......5/1/15......£1.05
Thanks,
Phil
Last edited: