Forum Discussion

cbolster's avatar
cbolster
Copper Contributor
Dec 13, 2023
Solved

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. 

 

 

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! 

Resources