Using = Named range

N

nathan_savidge

Hi,

I have a pivot table, that i am running code on to name the column totals
based on the criteria in the Pivot table. We have a Name, and what it
relates to, i.e. cars purchased would be JohnSmithCarsPurchased. I have a
front end for this with the individual headers and the names, i.e.
A B C
Cars Sold Cars Bought
John Smith HERE

In the front end i want to put a formula concatenated by the name and the
section, ie.

= (A2 & B1) for JohnSmithCarsSold

Hope this is clear.

Thanks

Nathan.
 

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

Excel - Wich Function should I use? 1
Can't ungroup in Pivot Table Results - or how do I get what i want 3
DCOUNT or nested functions? 2
Add another value to a named range 0
Constructing Range Name calls with Concatenate 4
A find formul looking at two named ranges for two strings 8
Trouble with Pivot Tables & Named Ranges 0
finding the largest value for a name in a column and then returningthe result from a different colum 1

Top