79691321

Date: 2025-07-05 20:24:36
Score: 1
Natty:
Report link

Assuming the SubID number you want to find the day value for is in a cell such as D1 then the formula could be: =IFERROR(AGGREGATE(15,6,B2:B5/(A2:A5=D1)/(C2:C5="Charge"),1),AGGREGATE(14,6,B2:B5/(A2:A5=D1)/(C2:C5<>"Charge"),1))

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: Clif