Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
assign next serial number based on contents of another cell
column A titled "serial number", column B titled "line item", column C titled
"cargo". If column B contains 5 line items for the same cargo in column C, how do I get column A to input the next serial number only after contents in Column C has changed. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
assign next serial number based on contents of another cell
Hi
Enter first serial number in A2, then insert this formula in A3 and copy down. If cargo cell is empty, serial number cell will also be empty. =IF(C3<"",IF(C3<C2,A2+1,A2),"") Hopes this helps. .... Per "clint" skrev i meddelelsen ... column A titled "serial number", column B titled "line item", column C titled "cargo". If column B contains 5 line items for the same cargo in column C, how do I get column A to input the next serial number only after contents in Column C has changed. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
assign next serial number based on contents of another cell
Hi Clint,
To increment one number in the serial number column when: 1. Cargo text field changes OR 2. Above the current row there are 5 lines with the same cargo text as the current row, AND those rows have the same serial number as the preceding row. In cell A2 enter first serial number - i.e. 1001. In cell A3 enter: =IF(C2<C3,A2+1,IF(COUNTIF(INDIRECT("C"&MATCH(A2,A :A,0)):C3,C3)5,A2+1,A2)) Hope this helps. Peggy "clint" wrote: column A titled "serial number", column B titled "line item", column C titled "cargo". If column B contains 5 line items for the same cargo in column C, how do I get column A to input the next serial number only after contents in Column C has changed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
Finding the Row number based on contents of a cell | Excel Worksheet Functions | |||
Set number format based on cell contents | Excel Discussion (Misc queries) | |||
serial number cell | Excel Worksheet Functions | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) |