#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Second last number in list TeddyTash Excel Worksheet Functions 2 September 25th 06 10:01 AM
How do i set up a list that sorts as Number/letter/number in orde xorex Excel Discussion (Misc queries) 3 September 8th 06 12:59 AM
Lookup number above value in a list Sloth Excel Discussion (Misc queries) 2 August 25th 06 03:16 PM
again: number a list Mike Sound New Users to Excel 5 June 19th 06 09:54 PM
number a list Joe Fisher New Users to Excel 4 June 2nd 06 12:59 PM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"