Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling Column with Numbers
Put a 1 Next to Jack (assume A1)
Put a 1 Next of Adam (assume A2) in A3 put in the formula =IF(B3="","",IF(B2="",A1+1,A2)) Then drag fill down your column -- Regards, Tom Ogilvy Tom wrote in message ... I have the following scenario One column in excel contains more than 3000 names i.e. Jack Adam Tom James DJ Wendy Haris keen Anthony The names belong to different departments I will called Dept 1, 2, 3 ,.......25 I want to fill the adjacents cells with Department Number i.e. 1 Jack 1 Adam 1 Tom 2 James 2 DJ 2 Wendy 2 Hars 2 keen 3 Anthony 3 David Fortunately all the names belonging to same department are coming together followed by an EMPTY CELL Then the second Department names start followed by an EMPTY CELL then third Department names being and so on "all these under one column" I need to tell Excel to start filling the adjacent cell of Dept1 names with Number 1 and continue down stream Till it found the adjacent cell is EMPTY (in our example the cell between Tom and James) Stop filling and Jump to next cell and start filling with number 2 till it found the second Empty cell (between Keen and Anthony)stop filling and Jump to Anthony's adjacent cell and start filling with number 3 and so on.... This will be a great help and will save me a great deal of time thank in Advance even if you read till here |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling Column with Numbers
Thanks You very much
May God Bless you and ease your way -----Original Message----- Put a 1 Next to Jack (assume A1) Put a 1 Next of Adam (assume A2) in A3 put in the formula =IF(B3="","",IF(B2="",A1+1,A2)) Then drag fill down your column -- Regards, Tom Ogilvy Tom wrote in message ... I have the following scenario One column in excel contains more than 3000 names i.e. Jack Adam Tom James DJ Wendy Haris keen Anthony The names belong to different departments I will called Dept 1, 2, 3 ,.......25 I want to fill the adjacents cells with Department Number i.e. 1 Jack 1 Adam 1 Tom 2 James 2 DJ 2 Wendy 2 Hars 2 keen 3 Anthony 3 David Fortunately all the names belonging to same department are coming together followed by an EMPTY CELL Then the second Department names start followed by an EMPTY CELL then third Department names being and so on "all these under one column" I need to tell Excel to start filling the adjacent cell of Dept1 names with Number 1 and continue down stream Till it found the adjacent cell is EMPTY (in our example the cell between Tom and James) Stop filling and Jump to next cell and start filling with number 2 till it found the second Empty cell (between Keen and Anthony)stop filling and Jump to Anthony's adjacent cell and start filling with number 3 and so on.... This will be a great help and will save me a great deal of time thank in Advance even if you read till here . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling Column with Numbers
Now you have a lot of formulas unless you change to values.
Thought you wanted a "programming" solution instead of a "worksheet.function" solution. "Tom" wrote in message ... Thanks You very much May God Bless you and ease your way -----Original Message----- Put a 1 Next to Jack (assume A1) Put a 1 Next of Adam (assume A2) in A3 put in the formula =IF(B3="","",IF(B2="",A1+1,A2)) Then drag fill down your column -- Regards, Tom Ogilvy Tom wrote in message ... I have the following scenario One column in excel contains more than 3000 names i.e. Jack Adam Tom James DJ Wendy Haris keen Anthony The names belong to different departments I will called Dept 1, 2, 3 ,.......25 I want to fill the adjacents cells with Department Number i.e. 1 Jack 1 Adam 1 Tom 2 James 2 DJ 2 Wendy 2 Hars 2 keen 3 Anthony 3 David Fortunately all the names belonging to same department are coming together followed by an EMPTY CELL Then the second Department names start followed by an EMPTY CELL then third Department names being and so on "all these under one column" I need to tell Excel to start filling the adjacent cell of Dept1 names with Number 1 and continue down stream Till it found the adjacent cell is EMPTY (in our example the cell between Tom and James) Stop filling and Jump to next cell and start filling with number 2 till it found the second Empty cell (between Keen and Anthony)stop filling and Jump to Anthony's adjacent cell and start filling with number 3 and so on.... This will be a great help and will save me a great deal of time thank in Advance even if you read till here . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofiltering then filling down numbers. | Excel Discussion (Misc queries) | |||
Auto filling a table of numbers | Excel Worksheet Functions | |||
Filling Sheet numbers in a column | Excel Worksheet Functions | |||
filling cells acording to the first 3 numbers | Excel Discussion (Misc queries) | |||
Filling Column with Numbers | Excel Programming |