help returning the same values from two different cells

N

Natahn

I am trying to return a set of data from an Access database, into Excel using
MS Query. I have two different cells in the database that can contain the
same value. I need to know how to return every record that has the same value
in EITHER cell. All I have achieved so far is returning those records that
have the same value in BOTH cells. If I try to exclude values that I do not
want in one cell, it also excludes records that contain the desired value in
the second cell.
 
B

Bernie Deitrick

Natahn,

An Access news group might be a better place to ask a question like this.

I don't use MS Query at all - but in the meantime, you could use a helper column of formulas like

=OR(A2="Value",D2="Value")

and pull in records where that formula returns TRUE.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
VBA Coding Help for Beginner 0
Excel Countif Function - Calculating Between Two Sets of Values 3
Round Down 2
Hide columns based on row values 2
Vlookup and return sheet name also 2
Select minimum with duplicate values to return column headings 3
Can UDF return a customized hyperlink? 3

Top