Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table #VALUE! Error !
hello,
in my PT #VALUE! error showing under Sold Amount, but not all, there are about 30~35% this erroe are showing rest are okey, any solutaion ? thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table #VALUE! Error !
Try a helper col in the source table to trap/convert all data to numbers
Assuming "Sold Amount" data is in E2 down In F2, copied down: =IF(ISNUMBER(E2+0),E2+0,0) Put a label in F1, eg: Sold1 Extend your pivot's range to cover col F, then replace "Sold Amount" field with "Sold1" Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Tufail" wrote: in my PT #VALUE! error showing under Sold Amount, but not all, there are about 30~35% this erroe are showing rest are okey, any solutaion ? thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table #VALUE! Error !
You could try a helper col in your source table to trap/convert all of "Sold
Amount" source data to real numbers. Assume "Sold Amount" is col E, data in E2 down In F2, copied down: =IF(ISNUMBER(E2+0),E2+0,0) Label in F1, say: SoldAmt_1 Then just extend the pivot to cover col F, and replace "Sold Amount" with SoldAmt_1. Any good? Hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Tufail" wrote: in my PT #VALUE! error showing under Sold Amount, but not all, there are about 30~35% this erroe are showing rest are okey, any solutaion ? thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML error in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Error | Charts and Charting in Excel | |||
Pivot Table #DIV/0! Error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Worksheet Functions |