Bright01

asked on

# Formula to drop text to a common Row.

EE Pros,

I have two results in two columns that are the results of formulas. I want the results to appear on the same row at the bottom. What formula can I use that looks for the text in the column and then produces it on the same row line?

Thank you in advance!

B.

Formula-to-drop-Text.jpg

I have two results in two columns that are the results of formulas. I want the results to appear on the same row at the bottom. What formula can I use that looks for the text in the column and then produces it on the same row line?

Thank you in advance!

B.

Formula-to-drop-Text.jpg

Can there ever be more than one row of text in the columns? What formulas do you have in columns E & F? It would be easier if you post a sample workbook for us to work from.

ASKER

No.... the current formula only returns one row of text in the designated column. I simply want the results in the column, where there appears a Text result, drop to a common row from two columns.

B.

B.

OK, understood. It just might have been simpler if we had those formulas as we could potentially bypass that to populate row 64.

Otherwise, try these in column E and F...

=INDEX(E54:E63, SUMPRODUCT((E54:E63<>"")*ROW(E54:E63))-ROW(E53))

=INDEX(F54:F63, SUMPRODUCT((F54:F63<>"")*ROW(F54:F63))-ROW(F53))

Wayne

Otherwise, try these in column E and F...

=INDEX(E54:E63, SUMPRODUCT((E54:E63<>"")*R

=INDEX(F54:F63, SUMPRODUCT((F54:F63<>"")*R

Wayne

ASKER

Here is what I get when I apply the formulas to the bottom row. I shifted the rows in the formula to reflect the right columns. I see I didn't give you the right columns when I sent you the first screen shot.

B.

Indexing-a-row-to-drop-Text.jpg

B.

Indexing-a-row-to-drop-Text.jpg

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Wayne,

Thank you! Works great. Appreciate the effort.

B.

Thank you! Works great. Appreciate the effort.

B.