Hello there,
I have an excel date with different products and some of them are repeated.
(Please see attached file to look at the table)products.xlsx
On the first column, I created the formula: =IF(COUNTIF($B$1:B1,B2)>0,"",MAX($A$1:A1)+1) to give it an index number. Next to it is the product name and then start date and finish date
On another sheet I'm tracking ONLY unique products: on the first column with unique products, I wrote the formula to only look up unique product names:
=IFERROR(VLOOKUP(ROWS(G$2:$H2),$A:$A:$B:$B,2,FALSE),"") and that is how I came up with the table below:
UNIQUE PRODUCTS Start Date Finish date
product 1
product 2
Product 3
Product 4
Product 5
Now my question is, what formula should I use to grab the start date (earliest date) and the finish date (latest date) of a unique product that was in the previous table?
so for example Product 1, I want the start date to show 2/16/2016 and I want the end date to show 4/1/2016 on the 2nd table with unique products.
Thanks for your help!
Bookmarks