LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 47
Default serial numbers

Please follow following steps
1.Enter values 1 in first cell (say C1) and 2 to the second cell (say C2)
2.Now select cell C3 and enter following formula
=MAX($C$1:C2)+1
3.Now drag the cell C3 below to apply it to other cells as well

Hope you get it

Have a nice time€¦.


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

 
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
Model & Serial Numbers ExcelMS Excel Worksheet Functions 3 May 24th 08 10:15 PM
attaching serial numbers deepika :excel help[_2_] Excel Discussion (Misc queries) 0 February 19th 08 04:36 AM
i want serial numbers should be changed automatically naughtyboy Excel Discussion (Misc queries) 4 August 8th 06 07:31 PM
serial numbers excel JpBar Excel Worksheet Functions 1 January 29th 06 09:55 PM
to find missing serial numbers in randomly generated numbers B.H. Hadi Excel Worksheet Functions 2 December 1st 05 10:56 PM


All times are GMT +1. The time now is 05:24 AM.

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"