Values in a piviot table.

[S.Daniels]

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.

 

[JazzEars]

number out of order

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