I have a formula that pulls in data based on the date the event went to a status of 33.(10/01/2017-10/31/2017). However if someone makes a mistake and changes the status twice during the date range I entered it is being picked up twice and doubles the $ amount. Is there a way to only pull the data based on the MINIMUM date from the range?
Current data returned:
Date went to 33     status     name     amount     unique id
10/1/2017     to 33     mmt     $1,000      123
10/15/2017     to 33     mmt     $1,000      123
                       $2,000      
                    
Results wanted:
10/1/2017     to 33     mmt     $1,000      123
                       $1,000      
Thank you