Forum Discussion
Help! Complex formula for large excel spreadsheet
I am an excel novice. I have a complex formula to try and write. Here's the concept: I have a large table that contains just two columns. The first column has a number ID which represents a voluntee...
=IFNA(IF(MATCH(1,($A$2:$A$15=$A2)*($B$2:$B$15=$G$2),0),A2,""),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell C2 and filled across range C2:D15.
Thanks so much! That works beautifully! I will have to study it to understand how it works. Thanks again!
