Forum Discussion

calof1's avatar
calof1
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 is in cell E2 on tab "Summary". However i keep getting an error message.

 

Does anyone have any ideas on what i need to change for this formula?

 

Many thanks,

BI & Data Analysis
Charting
excel
Excel for web
Excel on Mac
Excel on mobile
Formulas and Functions
Macros and VBA
office 365
power bi

4 Replies

  • mathetes's avatar
    mathetes
    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's avatar
      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,

  • JMB17's avatar
    JMB17
    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's avatar
      calof1
      Iron Contributor
      Sep 08, 2020

      hiJMB17 

       

      thanks for the below. I will update my spreadsheet.

       

      Many thanks,

Resources