Finding a row/column header in Pivottable
 

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell me the
transaction date for particular amount, account, and location?

Finding a row/column header in Pivottable
 

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)


"Steven Cheng" wrote:

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell me the
transaction date for particular amount, account, and location?

Finding a row/column header in Pivottable
 

what do the "--" mean?

"Teethless mama" wrote:

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)


"Steven Cheng" wrote:

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell me the
transaction date for particular amount, account, and location?

Finding a row/column header in Pivottable
 

Sorry, can you elaborate in what this "--" means for the sumproduct
function...I don't use it too often...

"Steven Cheng" wrote:

what do the "--" mean?

"Teethless mama" wrote:

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)


"Steven Cheng" wrote:

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell me the
transaction date for particular amount, account, and location?

Finding a row/column header in Pivottable
 

If you Google for "double unary minus" in conjunction with Excel and
SUMPRODUCT, you'll find explanations in places such as
http://www.mcgimpsey.com/excel/variablerate1.html
--
David Biddulph

"Steven Cheng" wrote in message
...
Sorry, can you elaborate in what this "--" means for the sumproduct
function...I don't use it too often...

"Steven Cheng" wrote:

what do the "--" mean?

"Teethless mama" wrote:

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)


"Steven Cheng" wrote:

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel
such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell
me the
transaction date for particular amount, account, and location?

Finding a row/column header in Pivottable
 

thanks. I had tried but tooo much information came down.

"David Biddulph" wrote:

If you Google for "double unary minus" in conjunction with Excel and
SUMPRODUCT, you'll find explanations in places such as
http://www.mcgimpsey.com/excel/variablerate1.html
--
David Biddulph

"Steven Cheng" wrote in message
...
Sorry, can you elaborate in what this "--" means for the sumproduct
function...I don't use it too often...

"Steven Cheng" wrote:

what do the "--" mean?

"Teethless mama" wrote:

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)


"Steven Cheng" wrote:

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel
such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell
me the
transaction date for particular amount, account, and location?