Hi all,

I am trying to create a scatter plot from a data set. I want to find a formula such that I can get the exact data I need.

I have a column of names, and a column of data. I want to create three data series. I want a formula so that excel will look through a column of data and find values greater than 0, THEN look at another column and if the name = the value in the cell, then it will plot that value as the x-axis value. I then want to do the same for the y-axis (using different columns).

I was tinkering with IF and AND functions, but couldn't quite get it. The name column actually contains an identifier, so ideally, the scatterplot would plot all non-zero values of each identifier (three different ones) when I put in the three data series.

This isn't what the formula will look like, but this is the idea.... =IF([data column]>0 AND [name column="Name"], then return the data in the data column)

Is this possible? I want it to find all non-zero values, and if it has a certain name, then I want it to plot each data value on the scatterplot.

Thanks for the help. I may need to post this in macros but figured I'd try here first.