Hello,
I want to find the value "96" but this formula is giving me the value of "307". How do I find the most relevant number needed if I have the same values in the "Machine Number" column?
This is a ledger type situation where we record data for machine numbers daily. So one machine number will have multiple QC tests done on them. I need to know the date of the last QC performed.
Any help would be appreciated
Thank you,
Ryan
try this formula in service log I2;
=MIN(IF('Service Log'!C1:C9999='WCS Machines'!C2,'Service Log'!G1:G9999))
This is an array formula so you enter it in by holding down Ctrl +Shift and then enter. (Ctrl+Shift+Enter). Then you can drag down as required.
If you actually want a date then;
= Today()-MIN(IF('Service Log'!C1:C9999='WCS Machines'!C2,'Service Log'!G1:G9999))
Again you will need to enter with CSE.
Or just take the test date from the service log, instead of the number of days.
=MAX(IF('Service Log'!C1:C9999='WCS Machines'!C2,'Service Log'!D1:D9999))
Last edited by Croweater; 06-21-2021 at 08:50 PM.
Hi Croweater,
Cheers! Thank you for your help and providing extra formulas!
This all worked perfectly.
-Ryan
No problems. Happy to help.
To avoid an array formula ( so you don't have to bother with CSE), this will also return the requiredFormula:
Please Login or Register to view this content.
(or use the MINIF function for XL versions starting with 2019)
Thank you, Pepe!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks