SOLVED

How to extract multiple lines of data

Copper Contributor

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. 

 

 

Namevalue
A0
B1
C2
D3

 

In this case, the formula would return 3 results, B, C, D. so the result would look like this:

 

B1
C2
D3

 

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! 

2 Replies
best response confirmed by cbolster (Copper Contributor)
Solution

@cbolster 

The formulas in the attached file return the intended result if i correctly understand what is required.

@OliverScheurich thanks! this is exactly what I was looking for.
1 best response

Accepted Solutions
best response confirmed by cbolster (Copper Contributor)
Solution

@cbolster 

The formulas in the attached file return the intended result if i correctly understand what is required.

View solution in original post