Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

help with Index / match

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Startup slowing since going wireless?  
Author Message
Opal

External


Since: May 28, 2009
Posts: 3



(Msg. 1) Posted: Thu May 28, 2009 9:03 am
Post subject: help with Index / match
Archived from groups: microsoft>public>excel (more info?)
I am using Excel 2003 and I'm trying to create a formula to
look up a value in a Pivot table. The pivot table results would
be:

Date DB CVT ACD PKT
5/21 0.1 2.1 1.2
5/22 .01 1
5/23 1.1 .02
5/24 2.1 .02
5/25 1.2 1.2

I want to show in the formula result the values in column DB
I thought I could use a combination of Index and match but I can't
quite get it right.

Basically the pivot table updates weekly and the values I want
may not always be in the DB column, they may in another
column. Can I achieve this with these functions?

 >> Stay informed about: help with Index / match 
Back to top
Login to vote
David Heaton

External


Since: May 28, 2009
Posts: 2



(Msg. 2) Posted: Thu May 28, 2009 3:49 pm
Post subject: Re: help with Index / match
Archived from groups: per prev. post (more info?)
On May 29, 2:03 am, Opal wrote:
> I am using Excel 2003 and I'm trying to create a formula to
> look up a value in a Pivot table.  The pivot table results would
> be:
>
> Date     DB   CVT   ACD  PKT
> 5/21      0.1              2.1   1.2
> 5/22                .01     1
> 5/23      1.1                      .02
> 5/24      2.1     .02
> 5/25      1.2                1.2
>
> I want to show in the formula result the values in column DB
> I thought I could use a combination of Index and match but I can't
> quite get it right.
>
> Basically the pivot table updates weekly and the values I want
> may not always be in the DB column, they may in another
> column.  Can I achieve this with these functions?

It would be helpful to see what formula you are trying to use and
which column you are trying to match

 >> Stay informed about: help with Index / match 
Back to top
Login to vote
Opal

External


Since: May 28, 2009
Posts: 3



(Msg. 3) Posted: Thu May 28, 2009 6:05 pm
Post subject: Re: help with Index / match
Archived from groups: per prev. post (more info?)
That's just it, I'm not sure how to achieve what I
want. I don't have a formula right now....

Its difficult to explain but the pivot table would
look something like what I copied in my original post.
I need to make a chart out of the most frequent data
and in this case it would be all the data under
"DB" Howvever the next time I refresh the pivot
the data may be under "PKT" and so I need
to be able to show that data in a separate
range of cells for the chart source.
 >> Stay informed about: help with Index / match 
Back to top
Login to vote
Roger Govier

External


Since: Dec 8, 2008
Posts: 11



(Msg. 4) Posted: Fri May 29, 2009 6:25 am
Post subject: Re: help with Index / match
Archived from groups: per prev. post (more info?)
Hi

If I understand you correctly, then you want the column of data that has the
most values in it.
If so, outside the PT, in row 1 (insert a row if your page field comes in
row 1) set up a count
In cell B1
=COUNT(B5:B1000)
Copy across through columns C:E

To the right of the PT (I used cell I5) enter
=INDEX(B5:E1000,,MATCH(MAX($B$1:$E$1),$B$1:$E$1,0))
Copy down as far as required.

Base your chart on column I data.
 >> Stay informed about: help with Index / match 
Back to top
Login to vote
Opal

External


Since: May 28, 2009
Posts: 3



(Msg. 5) Posted: Sat May 30, 2009 11:15 am
Post subject: Re: help with Index / match
Archived from groups: per prev. post (more info?)
Thank you Roger, I will give this a try.
 >> Stay informed about: help with Index / match 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
INDEX MATCH HELL ooops.. I mean HELP! - I know (or at least I think I do) that I can do this with INDEX MATCH. Here is what I want to do. I want to place this formula in cell C4 of Sheet 1. What I want this formula to do is to match the value of B2 of Sheet 1 with a list that is in Sheet 2...

Visible row index after applying a filter in Excel - Does anyone know an excel function that will give the index of the visible row after filtering or sorting a table? Say, I have a table like this: type time place c 12:20 1 f 12:40 2 c 13:30 3 f 14:20 4 Table is....

Notation Bugs - Did anybody notice that Excel handles math notations (symbols) in an incorrect way? Try this: write -2 in cell A1. Write =1-A1^2 in a different cell. Write =-A1^2+1 in another cell. The two expressions are equivalent, shouldn't they? Well, the former..

How to create a single line separated by commas from a mat.. - Hello, I've the following problem. I've a table made of several columns. Each colum represents a characteristic regarding to a subject (e.g. Name, Surname, Home Street, etc...). In the rows I put the different people. I need to export these info to a....

Excel password Recovery - Hi All, i forgot my excel password, can any tell me how to recover the password there is any free tool is avail in web, Regards, Deen
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]