Solved

Formula to drop text to a common Row.

Posted on 2016-08-01
6
33 Views
Last Modified: 2016-08-07
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
0
Comment
Question by:Bright01
  • 3
  • 3
6 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41738113
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.
0
 

Author Comment

by:Bright01
ID: 41738125
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.
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41738140
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
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Bright01
ID: 41738911
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
0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points
ID: 41739931
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
0
 

Author Closing Comment

by:Bright01
ID: 41746271
Wayne,
 
Thank you!  Works great.  Appreciate the effort.

B.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now