Formula to drop text to a common Row.

Bright01
Bright01 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
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.
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
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Author

Commented:
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
In future, please post your workbook. It doesn't have to be the workbook - it can just be an example with any sensitive information scrubbed. This way we know exactly what ranges and formulas we are working with and we'll have your solution quicker.

I've recreated your workbook based on your picture to show how the formulas return the desired results. I've started from row 1 in this example as your new picture doesn't show row headers.

See attached.
example.xlsx

Author

Commented:
Wayne,
 
Thank you!  Works great.  Appreciate the effort.

B.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial