Forum Discussion
Need help writing a complex formula
Hello gurus! I need help in trying to figure out which formulas to use and how to write them to solve this Excel problem. Sheet 1 = Candidate Info This table has 3 columns: Candidate ID, Zip Co...
Hi Ronna,
If return the string when it could be array formula with TEXTJOIN
=TEXTJOIN(", ",TRUE,IF(($B$9:$B$28=$B2)*($D$9:$D$28=$D2),$A$9:$A$28,""))
and for counting
=COUNTIFS($B$9:$B$28,INDEX($B$2:$B$6,MATCH($F19,$A$2:$A$6,0)),$D$9:$D$28,INDEX($D$2:$D$6,MATCH($F19,$A$2:$A$6,0)))
Please see third table under your samples in first sheet
Sergei, this is wonderful! I so appreciate your quick response and work in helping me find an answer! I was so confused before, and now you've given me a great starting point.
Thank you again!
Ronna :0)
Ronna, you are welcome