G
Guest
I need a formula that would concatenate only the blank cells between two
rows that have data. If the line below 10001 is blank (A3), concatenate all
the rows in B whose A value is blank.
I am using this formula =IF(A3="",B2&""&B3&""&B4&"",B2)
The problem is that sometimes, I might have two or more blank cells below
10001.
Could someone help!
Thanks!
rows that have data. If the line below 10001 is blank (A3), concatenate all
the rows in B whose A value is blank.
I am using this formula =IF(A3="",B2&""&B3&""&B4&"",B2)
The problem is that sometimes, I might have two or more blank cells below
10001.
Could someone help!
Thanks!