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

Bronze Contributor

Sep 07, 2020

Remove the quotes that are around $E$4.

=SMALL(IF('Exceptions - Data Input'!$AB:$AB=$E$4,'Exceptions - Data Input'!$D:$D),1)

calof1

Iron Contributor

Sep 08, 2020

hiJMB17

thanks for the below. I will update my spreadsheet.

Many thanks,