Forum Discussion

NoviceGuy's avatar
NoviceGuy
Copper Contributor
Nov 06, 2023

How to delete FALSE response in Excel IFS formula

I want to display entries from Column B in all instances where a condition is met in Column G. For instance, for all rows where Column G is "Wed" I want to list each of the corresponding Column B ent...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
MVP
Nov 06, 2023

NoviceGuy 

As variants

=TEXTJOIN(", ",,IF($G$3:$G$8="Wed", $B$3:$B$8, "") )

or

=IF( $G$3 = "Wed", $B$3, "" ) &
 IF( $G$4 = "Wed", ", " & $B$4, "" ) &
 IF( $G$5 = "Wed", ", " & $B$5, "" ) &
 IF( $G$6 = "Wed", ", " & $B$6, "" ) &
 IF( $G$7 = "Wed", ", " & $B$7, "" ) &
 IF( $G$8 = "Wed", ", " & $B$8, "")

depends on Excel version

Resources