Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
sure the way is so easy, but i'm a beginner who do not enough time to try and
solve. problem is.. coloumn B contains names. coloumn A numbering the recorded names. i would like to insert a formula for auto numbering. for example if there is nothing in B7, A7 empty. and if B8 is contains data A8 should be A6+1. thanks in advance for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
Hi Taco,
formula in col A1 : =IF(B1<"",ROW(B1),"") and Fill Down Regards, Jean-Yves "taco" wrote in message ... sure the way is so easy, but i'm a beginner who do not enough time to try and solve. problem is.. coloumn B contains names. coloumn A numbering the recorded names. i would like to insert a formula for auto numbering. for example if there is nothing in B7, A7 empty. and if B8 is contains data A8 should be A6+1. thanks in advance for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
Taco,
I'm afraid I'll have to disagree with Jean-Yves. His solution won't produce consecutive numbers, it will skip numbers of rows with blank cells in column B. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
Hi Nikos,
It is not necessary to produce consecutive number IMHO, but to get an ID number. Your solution provides a variable ID if any entry is cleared. Note that my solution does not works as well if a row is deleted. Should think of a macro to write a unique value at run time. Regards, Jean-Yves "Nikos Yannacopoulos" wrote in message ... Taco, I'm afraid I'll have to disagree with Jean-Yves. His solution won't produce consecutive numbers, it will skip numbers of rows with blank cells in column B. Assuming your list of names starts in row 2, try this formula in A2, then copy down: =IF(NOT(ISBLANK(B2)),COUNTA(B$2:B2),"") If your list starts in a different row just paste the formula in column A in that row, and change the 2's to the row number. HTH, Nikos "taco" wrote in message ... sure the way is so easy, but i'm a beginner who do not enough time to try and solve. problem is.. coloumn B contains names. coloumn A numbering the recorded names. i would like to insert a formula for auto numbering. for example if there is nothing in B7, A7 empty. and if B8 is contains data A8 should be A6+1. thanks in advance for your help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
The OP did show consecutive numbers as part of the requirement:
if B8 is contains data A8 should be A6+1. -- Regards, Tom Ogilvy "Jean-Yves" wrote in message ... Hi Nikos, It is not necessary to produce consecutive number IMHO, but to get an ID number. Your solution provides a variable ID if any entry is cleared. Note that my solution does not works as well if a row is deleted. Should think of a macro to write a unique value at run time. Regards, Jean-Yves "Nikos Yannacopoulos" wrote in message ... Taco, I'm afraid I'll have to disagree with Jean-Yves. His solution won't produce consecutive numbers, it will skip numbers of rows with blank cells in column B. Assuming your list of names starts in row 2, try this formula in A2, then copy down: =IF(NOT(ISBLANK(B2)),COUNTA(B$2:B2),"") If your list starts in a different row just paste the formula in column A in that row, and change the 2's to the row number. HTH, Nikos "taco" wrote in message ... sure the way is so easy, but i'm a beginner who do not enough time to try and solve. problem is.. coloumn B contains names. coloumn A numbering the recorded names. i would like to insert a formula for auto numbering. for example if there is nothing in B7, A7 empty. and if B8 is contains data A8 should be A6+1. thanks in advance for your help. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
Hello,
I should not try to put my own perception on this. Correct. But what is the meaning of OP, please ? Regards Jean-Yves "Tom Ogilvy" wrote in message ... The OP did show consecutive numbers as part of the requirement: if B8 is contains data A8 should be A6+1. -- Regards, Tom Ogilvy "Jean-Yves" wrote in message ... Hi Nikos, It is not necessary to produce consecutive number IMHO, but to get an ID number. Your solution provides a variable ID if any entry is cleared. Note that my solution does not works as well if a row is deleted. Should think of a macro to write a unique value at run time. Regards, Jean-Yves "Nikos Yannacopoulos" wrote in message ... Taco, I'm afraid I'll have to disagree with Jean-Yves. His solution won't produce consecutive numbers, it will skip numbers of rows with blank cells in column B. Assuming your list of names starts in row 2, try this formula in A2, then copy down: =IF(NOT(ISBLANK(B2)),COUNTA(B$2:B2),"") If your list starts in a different row just paste the formula in column A in that row, and change the 2's to the row number. HTH, Nikos "taco" wrote in message ... sure the way is so easy, but i'm a beginner who do not enough time to try and solve. problem is.. coloumn B contains names. coloumn A numbering the recorded names. i would like to insert a formula for auto numbering. for example if there is nothing in B7, A7 empty. and if B8 is contains data A8 should be A6+1. thanks in advance for your help. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
thank you very much Jean Yves and Nikos
Nikos, your formula is great.. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for automatic numbering the records
Jean-Yves,
OP stands for Original Posting. I still haven't been able to decypher some of the other acronyms frequently used in the NGs yet, though! Regards, Nikos "Jean-Yves" wrote in message ... Hello, I should not try to put my own perception on this. Correct. But what is the meaning of OP, please ? Regards Jean-Yves "Tom Ogilvy" wrote in message ... The OP did show consecutive numbers as part of the requirement: if B8 is contains data A8 should be A6+1. -- Regards, Tom Ogilvy "Jean-Yves" wrote in message ... Hi Nikos, It is not necessary to produce consecutive number IMHO, but to get an ID number. Your solution provides a variable ID if any entry is cleared. Note that my solution does not works as well if a row is deleted. Should think of a macro to write a unique value at run time. Regards, Jean-Yves "Nikos Yannacopoulos" wrote in message ... Taco, I'm afraid I'll have to disagree with Jean-Yves. His solution won't produce consecutive numbers, it will skip numbers of rows with blank cells in column B. Assuming your list of names starts in row 2, try this formula in A2, then copy down: =IF(NOT(ISBLANK(B2)),COUNTA(B$2:B2),"") If your list starts in a different row just paste the formula in column A in that row, and change the 2's to the row number. HTH, Nikos "taco" wrote in message ... sure the way is so easy, but i'm a beginner who do not enough time to try and solve. problem is.. coloumn B contains names. coloumn A numbering the recorded names. i would like to insert a formula for auto numbering. for example if there is nothing in B7, A7 empty. and if B8 is contains data A8 should be A6+1. thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sequential numbering when X column repeats records | Excel Discussion (Misc queries) | |||
Automatic Numbering | Excel Worksheet Functions | |||
Automatic Numbering | Excel Worksheet Functions | |||
Automatic Numbering. | Excel Discussion (Misc queries) | |||
Automatic numbering | Excel Programming |