Forum Discussion
How to extract multiple lines of data
Hey all,
I am trying to extract data based on an if statement across several rows. I know how to do most functions in excel, i just cant seem to combine them in a way that will do what im trying to do.
Example:
I want to form a list of names based on the value assigned, where if the value is greater than 0, then the name is displayed. If possible I'd also like it to return the value as well in the column adjacent.
Name | value |
A | 0 |
B | 1 |
C | 2 |
D | 3 |
In this case, the formula would return 3 results, B, C, D. so the result would look like this:
B | 1 |
C | 2 |
D | 3 |
If its not possible to return the value column that fine. This is obviously just a sample, the actual data includes 46 different names with different values attached daily.
Not sure it matters but we use Excel 2016
Thanks for any help!
The formulas in the attached file return the intended result if i correctly understand what is required.
2 Replies
- OliverScheurichGold Contributor
The formulas in the attached file return the intended result if i correctly understand what is required.
- cbolsterCopper ContributorOliverScheurich thanks! this is exactly what I was looking for.