Hello,
Am trying to find the maxifs and minifs. I need the formula to reference another sheet and two criteria. Currently I am trying to manipulate my formula =MAXIFS(data1!C:C,data1!A:A,Sheet1!F9,data1!E:E,Sheet1!E11),,,,,, F9 is a device name (criteria) E11 is the date with timestamp (criteria) i am trying to reference.
data1 is sheet where data is coming from. Issue at the moment. how to write formula for E11 to work correctly with timestamp with time.
Note,,,, this particular application the date will be the same, its the timestamp differences that i need to figure with.
I have the criterias for the array because the data on data1 sheet has about 9000 dates and timestamps for different devices.
Am trying to find the maxifs and minifs. I need the formula to reference another sheet and two criteria. Currently I am trying to manipulate my formula =MAXIFS(data1!C:C,data1!A:A,Sheet1!F9,data1!E:E,Sheet1!E11),,,,,, F9 is a device name (criteria) E11 is the date with timestamp (criteria) i am trying to reference.
data1 is sheet where data is coming from. Issue at the moment. how to write formula for E11 to work correctly with timestamp with time.
Note,,,, this particular application the date will be the same, its the timestamp differences that i need to figure with.
I have the criterias for the array because the data on data1 sheet has about 9000 dates and timestamps for different devices.