Forum Discussion

Iron Contributor

Sep 07, 2020

Help finding Start date in sets of data

Hi, I have sets of data which contains about 20 products. Some with different start dates. I have tried using SMALL formula in excel to find the date range with matches the product. This formula ...

Excpetion Data Help.xlsm1.7 MB

Formulas and Functions

Gold Contributor

Sep 07, 2020

calof1

I can't figure out your formula. I do know that I'd use MIN instead of SMALL to find the lowest date, given other criteria.

calof1

Iron Contributor

Sep 08, 2020

himathetes

thanks for the below. I will try using min & remove the quotation marks from the comment above. Will see how this goes.

Many thanks,