hi i have an energy readings spreadhseet populated by ms forms responses. i need to get the meters as rows and then the monthly readings as columns to...
rantanwang Yesterday, 04:25 PMJust for completeness, this would be an AND lookup:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")*($D$1:$D$13="Forward")),ROWS($1:1))),"")...
Yep, that did it! Thank you so much, it works amazing!...
Joecam 2021-04-11, 03:21 PMMaybe this?
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")+($C$1:$C$13="Something Else")),ROWS($1:1))),"")...
can a pivot table show my data in the way i need it?
I'm just down the road from you!!!
AliGW Yesterday, 05:02 PMCan you please mock up a few rows of data showing how you want it to look?...