Pivot Table Import Link to Numerical Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the import values from a pivot table function and I can't seem to
reference cells that have numerical years listed.

I want to use the reference to cell A48 but it doesn't work. It does work
when cell A48 contains text. (i'm working on a spanish version but i figure
the answer is universal)

What I want:
=+IMPORTARDATOSDINAMICOS("Suma de tot_oferta_inicial";'Dinamicas
entrega'!$B$8;"municipio";C48;A48;I48)-IMPORTARDATOSDINAMICOS("Suma de
tot_vendidas";'Dinamicas entrega'!$B$8;"municipio";C48;A48;I48)

What I have to do:
=+IMPORTARDATOSDINAMICOS("Suma de tot_oferta_inicial";'Dinamicas
entrega'!$B$8;"municipio";C48;"2006";I48)-IMPORTARDATOSDINAMICOS("Suma de
tot_vendidas";'Dinamicas entrega'!$B$8;"municipio";C48;"2006";I48)
 
Try using A48&""
I am using the import values from a pivot table function and I can't seem to
reference cells that have numerical years listed.

I want to use the reference to cell A48 but it doesn't work. It does work
when cell A48 contains text. (i'm working on a spanish version but i figure
the answer is universal)

What I want:
=+IMPORTARDATOSDINAMICOS("Suma de tot_oferta_inicial";'Dinamicas
entrega'!$B$8;"municipio";C48;A48;I48)-IMPORTARDATOSDINAMICOS("Suma de
tot_vendidas";'Dinamicas entrega'!$B$8;"municipio";C48;A48;I48)

What I have to do:
=+IMPORTARDATOSDINAMICOS("Suma de tot_oferta_inicial";'Dinamicas
entrega'!$B$8;"municipio";C48;"2006";I48)-IMPORTARDATOSDINAMICOS("Suma de
tot_vendidas";'Dinamicas entrega'!$B$8;"municipio";C48;"2006";I48)
Click to expand...
 

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

importing excel spreadsheets 2
Macro to copy paste values based on cell input ... 4
Marco to copy and paste values based on cell value (cont) 6
IF statement to check for numerical value 3
Return Numeric Labels that have different Numeric Values 8
Pivot Table result appends the numeral 2 to values excel2002 4
Pivot table from CSV data, problem with percentage of total. 1
Excel Pivot Table - Counting Unique Values within one column of da 1

Back
Top