Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Import Link to Numerical Values
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Import Link to Numerical Values
Try using A48&""
Wynn wrote: 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) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Import Link to Numerical Values
brilliant! thanks.
"Debra Dalgleish" wrote: Try using A48&"" Wynn wrote: 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) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Import Link to Numerical Values
You're welcome!
Wynn wrote: brilliant! thanks. "Debra Dalgleish" wrote: Try using A48&"" Wynn wrote: 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) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table hanging on to deleted values | Excel Discussion (Misc queries) | |||
Selecting a range of values on pivot table attribute with a macro | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
Why won't pasted values from a formula appear in a pivot table | Excel Discussion (Misc queries) |