Feb 02 2022 09:40 AM
Hi all,
Any chance to use a formula to get unique result from several columns (G2:H4) based on multiple criteria (B:C)? In the "F" column are only unique records.
Thanks in advance!
Feb 02 2022 10:07 AM
=SUMPRODUCT((B2=$F$2:$F$4)*(C2=$G$1:$H$1)*$G$2:$H$4)
=INDEX($G$2:$H$4,MATCH(B2,$F$2:$F$4,0),MATCH(C2,$G$1:$H$1,0))
Maybe with these formulas as shown in the attached file.
Feb 02 2022 10:48 AM
@OliverScheurich Thank you for your quick reaction!
Unfortunately I've got a problem with the formulas, maybe due to local language settings (but I checked twice). Could you please check on the linked xls file?
I updated the file structure. I will work with 10k rows. Big thanks!
Feb 02 2022 12:28 PM
SolutionSee the attached version. The formula uses structured table references.
Feb 02 2022 12:39 PM
Feb 02 2022 12:28 PM
SolutionSee the attached version. The formula uses structured table references.