Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add consecutive numbers but start over at break in the.
Recently, the following question was posed by another party:
"How do I add consecutive numbers but start over at a break in them. I'm trying to calculate consecutive days of attendance. One might have had 20 days in a row missed one and then I need to start over." The rsvp was: You received an answer... In B1 enter: =--(A10) In B2 enter: =(A20)*(1+B1) and drag down to copy as needed My question is: What does =--(A10) mean? i.e. what is the meaning of...=-- ?? Regards, FL KULCHAR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How do I add consecutive numbers but start over at a break in the. | Excel Discussion (Misc queries) | |||
How do I add consecutive numbers but start over at a break in the. | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Inventory numbers - Consecutive, but out of sequence | Excel Discussion (Misc queries) |