Re: Can Excel return multiple correct answers?

Debra Dalgleish has some notes on Advanced Filters here:

http://www.contextures.com/xladvfilter01.html

Easier to follow than in XL Help.

Hope this helps.

Pete

On Mar 5, 5:09 pm, sam <s...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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!- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • RE: Can Excel return multiple correct answers?
    ... It occurs to me that that one of my criteria is not as static as I ... from your data to a cell off to the right of the data. ... If I’m reading the 2000 manual correct, it looks like I can have multiple ... bunch in one column, and then do a V-Lookup, because there are multiple ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Word field Skip IF problem
    ... You can certainly make a field that SKIPs with multiple criteria, ... These are also the mergefields in my word docs. ... It basically says Skip record if "mergefield to" does not equal that ...
    (microsoft.public.word.mailmerge.fields)
  • MATCH using multiple criteria?
    ... Is there a way to find the first row in a data set that meets multiple ... criteria in multiple columns. ...
    (microsoft.public.excel.programming)
  • Re: New arrivals (II)
    ... multiple rows, not as one row of multiple columns, if you don't know at ... do only the selectfor the criteria I want to match, ... and however I bodge reading the values is at least a smaller, ... to use a list of ids (so long as it has a reasonable limit) you can ...
    (uk.rec.sheds)
  • RE: Extract & compare data on different worksheets
    ... The Advanced Filter command on the Data menu lets you use complex criteria ... Type Salesperson Sales ... Multiple criteria in multiple columns where all criteria must be true ...
    (microsoft.public.excel.misc)