Number list  
Author Message
Terrycymru





PostPosted: Thu Nov 15 14:24:23 PST 2007 Top

worksheet functions >> Number list

I have a spread sheet with many rows and columns that have various part
numbers. Is there a way to create a column that can list all the part
numbers?

Excel141  
 
 
Don





PostPosted: Thu Nov 15 14:24:23 PST 2007 Top

worksheet functions >> Number list More info and layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software



>I have a spread sheet with many rows and columns that have various part
>numbers. Is there a way to create a column that can list all the part
>numbers?
>

 
 
Jeff





PostPosted: Thu Nov 15 14:33:32 PST 2007 Top

worksheet functions >> Number list This large spread sheet has many part numbers all over and I need a way to
list the part numbers in numerical order so I can see any gaps in the order.





> More info and layout
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software



>>I have a spread sheet with many rows and columns that have various part
>>numbers. Is there a way to create a column that can list all the part
>>numbers?
>>
>


 
 
Gord





PostPosted: Thu Nov 15 14:33:31 PST 2007 Top

worksheet functions >> Number list Show a sample of the data layout so's we can get an idea or two.

Where are the various part numbers located and how would Excel recognize them as
such?


Gord Dibben MS Excel MVP



>I have a spread sheet with many rows and columns that have various part
>numbers. Is there a way to create a column that can list all the part
>numbers?
>

 
 
Don





PostPosted: Thu Nov 15 14:43:03 PST 2007 Top

worksheet functions >> Number list You have to help us. No mind readers here.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software



> This large spread sheet has many part numbers all over and I need a way to
> list the part numbers in numerical order so I can see any gaps in the
> order.
>
>
>


>> More info and layout
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software



>>>I have a spread sheet with many rows and columns that have various part
>>>numbers. Is there a way to create a column that can list all the part
>>>numbers?
>>>
>>
>
>