How to find unique data from a larger set of data?

[jebckr]

Hello,

I think if I play with this long enough I'll figure it out, but if someone could help me that would save me some time.

I've attached the spreadsheet. I'm looking at the first part of page 3.

[Matt_]

I'm not quite sure what you want for the 3rd column?

1st Column: =VLOOKUP(E4,A:C,2,TRUE)
2nd Column: =VLOOKUP(E4,A:C,3,TRUE)
3rd Column: =COUNTIFS(B:B,"<1.5",C:C,">5%",A:A,E4)
or: =IF(AND(F4<1.5,G4>5%),"Yes","No")

Put in first blank then fill down.


Is this what you needed?

[jebckr]

Yes, that helped me out. Thank you. And it was the second formula I needed for the 3rd column.

[jebckr]

While I am at it, can you look at the 4th box there? I am trying formula =MEDIAN(IF(B4>1, C4,no)), but I know it is wrong. I do not know what to put for the "if false" value or if this is even the way to go about this.

[Matt_]

=MEDIAN(IF(B:B>1,C:C))

put it in the formula bar and hit Ctrl + Shift + Enter