| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
assign occurence number
Hi,
How do you assign an occurrence number in a cell? Lets say Column B (B1:B20). Restriction: 1 is the only valid data to be entered in Column B. Usage possibilities: If the user enters 1 at B3, an occurrence number of 1 appears at C3. If the user enters 1 at B12, an occurrence number of 2 appears at C12. If the user enters 1 at B1, an occurrence number of 3 appears at C1. If the user enters 1 at B20, an occurrence number of 4 appears at C20. And so on¦ Objective: Chronological cell usage indicator. The occurrence number will be used by another sheet. Im still new to excel so please indicate extra details needed for beginners like me. Thank you, Omega |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the row number of name occurence | Excel Worksheet Functions | |||
| Find first occurence of a number in an array 7 cols wide | Excel Worksheet Functions | |||
| Finding first occurence of a number | Excel Worksheet Functions | |||
| Extract single occurence of order number from list | Excel Worksheet Functions | |||
| Assign a number each letter on list compounding occurence @ each e | Excel Worksheet Functions | |||
Threaded Mode
