Values in a piviot table.

S.Daniels

New Member
Joined
Nov 1, 2005
Messages
37
I have a piviot table that returns a list of values.
( 311022,311024,311032,408505,410009,735022.....) in numeric order with some values skipped.
When I copy and paste these values on to another sheet then do a lookup_value I am able to find the value. But now there is a new value in the table that is not in numeric order. The value is 311029. When I lookup this value I get 311024. Other than resorting the list what can be done to find the correct value.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

JazzEars

New Member
Joined
May 5, 2005
Messages
10
number out of order

I would try using -Data-TextToColumns-FixedWidth-Finish
on your values then resorting the column.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,229
Messages
5,571,019
Members
412,354
Latest member
Stj99
Top