Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It sounds like there is a trailing space after some of the entries, or
perhaps a double space in the middle. Try using the LEN function see if both versions have the same number of characters. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) "GautamSonthalia" wrote in message ... 1. I have a field named "City" in my base data, that is captured on Rows of a dependant Pivot Table. 2. In some rows of the base data (say about 500 rows of data out of 1000 rows), one data value in City field was wrongly entered. 3. The correct entry should have been "New Delhi" - but it was entered erroneously as "Delhi" in some cells and "New Delhi" in others. 4. So when the Pivot Table was first created, it gave data categorized as under City "New Delhi" as well as "Delhi", whereas it should have been "New Delhi" only. 5. Later, I corrected the wrong entries of "Delhi" to "New Delhi". I also refreshed Pivot Table. 6. Even after refreshing, the Pivot Table still does not show all data under one data value of City "New Delhi". It now shows 2 separate entries for the same City "New Delhi". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In a pivot table, can the avg of a column include rows w/o data? | Excel Discussion (Misc queries) | |||
Using a data field twice in the 'Rows' section of a pivot table. | Excel Discussion (Misc queries) | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
How do I sort a pivot table with 2 data rows desending? | Excel Discussion (Misc queries) | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |