| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reset Counter
Hello,
In Column A, I have this list of 1's and empty cells*, i would like to have in column B a function that gives me the next result: *A1=1 B=1 *A2=1 B=2 *A3=1 B=3 *A4="" B="" *A5=1 B=1 *A6=1 B=2 *A7="" B="" *A8=1 B=1 *A9=1 B=2 *A10=1 B=3 It would be like a counter that tells me the number of times 1 has appeared so far, but when it reaches: "" it restarts and goes on again. ,thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counter | Excel Discussion (Misc queries) | |||
| Establish Default Titles For Drop Windows And Reset Button | New Users to Excel | |||
| Autofilter reset button | Excel Discussion (Misc queries) | |||
| Reset Button in Excel? | Excel Worksheet Functions | |||
| Creating a counter that does not include hidden rows | Excel Discussion (Misc queries) | |||
Threaded Mode
