Forum Discussion
Solved
Removing Duplicates from an Array based on Multiple Criteria
I have several spreadsheets which represent the output from a lighting audit done at several local high schools. Each space and fixture type within the school has its own row, so there are close to 1...
I have since found a solution, described here: https://www.exceldemy.com/excel-filter-multiple-criteria/
The correct syntax for the formula I showed earlier would be:
=FILTER(EnergyAudit_Sorted[[Usage Type]:[EX Code]], ('Energy Audit - Sorted'!EXCode=$D2) * (EnergyAudit_Sorted[Usage Type]=$E2))
The '*' operator performs the AND function in this case.
I have since found a solution, described here: https://www.exceldemy.com/excel-filter-multiple-criteria/
The correct syntax for the formula I showed earlier would be:
=FILTER(EnergyAudit_Sorted[[Usage Type]:[EX Code]], ('Energy Audit - Sorted'!EXCode=$D2) * (EnergyAudit_Sorted[Usage Type]=$E2))
The '*' operator performs the AND function in this case.