| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
GROUP NUMBERING
Hi Roger,
thanks for the solution - elegant Bill "Roger Govier" wrote: Hi Format column B, FormatCellsNumberCustom 0000 in cell B2 =IF(LEFT(A2,12)=LEFT(A1,12),B1,N(B1)+1) copy down as required -- Regards Roger Govier "Polarbilly" wrote in message ... I need to create a number sequence file for data listed as shown.The groups would be created from the first 12 digits. Example: UPI SEQUENTIAL NUMBER 8DEB90020849A059 0001 8DEB90020849B059 0001 8DEB90022591A059 0002 8DEB90022591B059 0002 8DEB90022796A059 0003 8DEB90022796B059 0003 8DEB90022796C059 0003 8DEB90022796D059 0003 thanks in anticipation Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
| Group a range - closing the group does not hide the controls.... | Excel Programming | |||
| How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
| Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Threaded Mode
