Return Single Row of Values That Meet Two Criteria

[SMB]

Hello,

I have been working at this issue for around a day now, and I cannot figure out a way to return a single column of data, if 2 criteria are met.

I have created an example sheet, with data in columns W, X, and Y, as the actual sheet I'm working with has the data contained in these columns. This example is not very extensive, but the list that I'm searching through sometimes goes up to around 9000 lines.

W = Date that I need to match
X = Count of returns
Y = Number I need to return

For example, on the Raw Data sheet, row 2, if the criteria was that the request was completed on 3/5/2011, but was returned 1 time(or greater), then the number in Y would be returned.

The part I cannot figure out is that I need to make a list of all the numbers in column Y that meet this criteria. (Error Rate 4 8 has an example)

Any guidance is appreciated in advance!

-SMB

[NBVC]

I don't understand the results... where do these:

Number 1
Number 2
Number 3
Number 4
Number 5

come from as results for 03/05/2011?

[SMB]

Yes, that was just a filler for the numbers in column Y to simulate what I am hoping to come out with. The numbers that would be in column B to replace those would be 100,103,108,111,and 120.

[NBVC]

Not sure about how much actual data you have and how many times the formula is used, but we can try this for now:

In B3 enter formula:

Please Login or Register  to view this content.

Adjust the ranges to suit your data

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down as far as you think you need to get all data and across as far as needed.


If this proves to be too slow... we can try other method with helper columns....

[SMB]

Hi there, that seems to do the trick. It doesn't seem slow, although I've still got to try it out w/ around 9000 lines. Thanks for all of your help!

[NBVC]

... although I've still got to try it out w/ around 9000 lines

That is the challenge!

[NBVC]

If it proves to be inefficient then try the following....

In Raw Data!Z2 enter:

Please Login or Register  to view this content.

copied down all the rows.

in the Error sheet, B3 enter:

Please Login or Register  to view this content.

copied down as far as you need and across the columns...


This should be much more efficient.