RE: Can Excel return multiple correct answers?

Tech-Archive recommends: Speed Up your PC by fixing your registry

That's pretty much the way it works. Start simple. Copy a column heading
from your data to a cell off to the right of the data. Enter your criteria
in the cell below the heading. These two cells are your criteria range.
Then do Data>Filter>advanced and enter your data range and criteria range.
Excel will return all the records in the data that match your criteria.
After you get that down, you can add additional field headings and expand
your criteria.

It's a very strong feature.

HTH
Jim

"sam" wrote:

Hey Jim –

Wanted to get back and acknowledge your advice; been sitting here reading.
This is really interesting.

If I’m reading the 2000 manual correct, it looks like I can have multiple
unique 2-criteria data sets instead of just one, static 2-criteria data set.

And that’s by putting the criteria on the SAME row? And then I can have a
bunch of those unique data sets going down the two columns?

Really appreciate your help so far.

sam


"Jim" wrote:

Check out data>filter>advanced.

HTH

"sam" wrote:

Good morning.

In all my years, I’ve not come across this. Searched the Board; there’s a
post suggesting drop-down lists, but that would require too much ongoing
manual input (I think).

1) I have 2 criteria that must be met
2) I have a table of data that includes many rows of data that will meet the
criteria, many that will not.

How do I get Excel to extract all correct answers? The problem, as I see it,
is that I input my request for this in one cell, thus limiting myself to one
answer. I’m not so sure the answer is to copy that static criteria down a
bunch in one column, and then do a V-Lookup, because there are multiple
unique 2-criteria data sets with corresponding multiple possible returns.
That means I’d have to copy a bunch of different 2-criteria data sets and
V-Lookups (hundreds).

Do I finally have a reason to learn Access? I have Excel 00, 03, and 07.

I sense I’m gonna learn something new today. Thanks!

.

Relevant Pages

  • RE: Lookup Data in two seperate Spreadsheets
    ... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... Just as VLOOKUP will give you the FIRST value it finds that meets it's ... 'Returns a reference to a range that is a specified number of rows and columns ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Wild Card Vlookups
    ... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... 'Returns a reference to a range that is a specified number of rows and columns ...
    (microsoft.public.excel.misc)
  • Re: Sorting into different worksheets from a unique value
    ... rewrote the code and posted it at the bottom. ... don't get a headache from watching the screens bounce back and forth. ... criteria. ... this IF function determines if there is something in cell A2. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Finding first occurence of a number
    ... My first impression on reading this thread in its entirety yesterday ... Microsoft Excel MVP ... cell 32, depending on some other criteria. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: splitting text strings into new fields
    ... This is NOT criteria. ... Note that I quoted "Cell". ... In one of the empty boxes in that row enter the following ... I am hoping to extract out only the sales office, ...
    (microsoft.public.access.queries)