ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Number list (https://www.excelbanter.com/excel-worksheet-functions/166278-number-list.html)

Jeff Klein

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?



Don Guillett

Number list
 
More info and layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Klein" <jklein@nospam wrote in message
...
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 Dibben

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

On Thu, 15 Nov 2007 14:21:23 -0600, "Jeff Klein" <jklein@nospam wrote:

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 Klein

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.



"Don Guillett" wrote in message
...
More info and layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Klein" <jklein@nospam wrote in message
...
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 Guillett

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Klein" <jklein@nospam wrote in message
...
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.



"Don Guillett" wrote in message
...
More info and layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Klein" <jklein@nospam wrote in message
...
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?







All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com