| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
increment a column based on information in another column
Hi,
I have several spreadsheets that I need to increment a column each time information in another column changes. Using example below, each time program changes I need the count column to be incremented. I don't want to use autofill as I have to do this every month and several sheets with lots of rows. Thanks for the help Program Count 1100 1 1100 2 1100 3 1200 1 1200 2 1200 1200 1400 1400 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
| LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE) | Excel Worksheet Functions | |||
| COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
| Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
| Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
Threaded Mode
