Hello Guys,
Just worked on the formula for returning the dynamic unique value from the large list, but I managed to workaround with single criterion based formula:
for example:
=INDEX('Act. Report'!$O$2:$O$1172, MATCH(0, IF($B$1='Act. Report'!$G$2:$G$1172, COUNTIF($A$3:$A3, 'Act. Report'!$O$2:$O$1172), ""), 0))
Can you please support to include there second criterion in order to extract list based on two criteria?
Thanks in advance.
Bookmarks