Hi Everyone, Sorry for such a basic question... Have a simple attendance worksheet where entries can be P, Ab, s, or blank. Want to add a formula so that if person has 5 consecutive absences - identified by value of Ab in the cell - change the Ab value in just those 5 cells SW. It is possible that there would be a blank cell in the middle, which should be ignored. I've looked for array formulas but nothing looked promising. Not new to Excel but as you see, use the basics. Thanks so much!! Terry (ps Would be glad to take a class but not sure which class would over this...?)
Find and change consecutive, repeating, specific text in a row.
- Thread starter tdw
- Start date
NARAYANK991
Excel Ninja
Hi Terry ,
What you want done cannot be achieved using formulae ; if my reading of your requirement is correct , you want that the absent values in the ranges G2:L2 , and in H4:L4 should be replaced by SW ; is this correct ?
Since these ranges already have data in them , where will you enter any formula which needs to change them ?
What you want done can be achieved using VBA ; is this acceptable ?
Narayan
What you want done cannot be achieved using formulae ; if my reading of your requirement is correct , you want that the absent values in the ranges G2:L2 , and in H4:L4 should be replaced by SW ; is this correct ?
Since these ranges already have data in them , where will you enter any formula which needs to change them ?
What you want done can be achieved using VBA ; is this acceptable ?
Narayan
Hi Narayan,
Thanks!! Think we are saying the same thing - I'm uploading an updated file that shows the changes I am trying to get as highlighted. Can't say I was sure where the formula would be unless it was in a hidden cell that the instructors couldn't see. VBA would be fine... THANKS!! Terry
Thanks!! Think we are saying the same thing - I'm uploading an updated file that shows the changes I am trying to get as highlighted. Can't say I was sure where the formula would be unless it was in a hidden cell that the instructors couldn't see. VBA would be fine... THANKS!! Terry
Hi:
Thanks for the feedback, no you cannot donate anything to me through this forum and I am not looking for any
, I am doing this out of my interest in excel and I work during my free time. I am attaching a copy of the same macro with an error handler , this code is not different from the one I already provided, I just added one more line to the code.
Thanks
Thanks for the feedback, no you cannot donate anything to me through this forum and I am not looking for any
, I am doing this out of my interest in excel and I work during my free time. I am attaching a copy of the same macro with an error handler , this code is not different from the one I already provided, I just added one more line to the code.Thanks