Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number columns based on adjacent cells?
Hello,
Subj: Filling-in data based on adjacent cells. I am using Microsoft Excel 2000. Here's my (autofill?) question... I have data in some rows, others are vacant; e.g., Col 1 Col 2 Col 3 1 line two line two line two 2 line three line three line three empty 3 line five line five line five empty My first question I suppose should be just how to number the lines within a range. Anyhoo, as you see, my question is not to number every line within a range* but rather to number only those lines that have data in the next column. Thank you, -John *I am aware "Edit, Fill, Series" will number every line. This is not what I am looking for. Can you help please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number columns based on adjacent cells?
Assume your data starts in B2.
Enter this formula in A2 and copy down as needed: =IF(B2="","",COUNTA(B$2:B2)) Biff "johnjesmer" wrote in message ... Hello, Subj: Filling-in data based on adjacent cells. I am using Microsoft Excel 2000. Here's my (autofill?) question... I have data in some rows, others are vacant; e.g., Col 1 Col 2 Col 3 1 line two line two line two 2 line three line three line three empty 3 line five line five line five empty My first question I suppose should be just how to number the lines within a range. Anyhoo, as you see, my question is not to number every line within a range* but rather to number only those lines that have data in the next column. Thank you, -John *I am aware "Edit, Fill, Series" will number every line. This is not what I am looking for. Can you help please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns | Excel Worksheet Functions | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions |