Cell Address in a pivot table

  • Thread starter Thread starter Reddy
  • Start date Start date
R

Reddy

I have a pivot table which gets updated every day.

Last row in the pivot table is 'Grand Total' and the number of rows in
the pivot table varies every day.

I have another function which needs the count of number of rows in the
pivot table. Since the starting cell remains the same, I am counting
the number of rows in the pivot table = Row Number of 'Grand Total' -
Starting Cell value.

Now my question is .. how do I get the Row Number of cell 'Grand
Total'?

Thank you for your time.

Regards,
Reddy
 
Thanks Debra for the reply, I have tried MATCH function earlier, but its
giving the wrong row number, I have looked into the pivot table data to
see if there is another cell with value 'Grand Total' but I see only
one.

Other than the MATCH funtion, is there anything else that I can use?

Thanks again for your help.
 
Did you have the 0 (zero) at the end of the MATCH formula? That should
return an exact match.
 
Yes I guess that must be the problem :)

Once again thank you for your help.

Have a great day!
 
Back
Top