untill

Hi All, I hope i am able to correctly explain my issue. Sheet1 contains data in range B6:C6 for a few rows down. i need the first row to be copied to Sheet2, then i add a few rows and go back to Sheet1 to copy the next row. This need to be repeated untill there is no data left in Column B. It...

Hi all, I need help with a formula. I have reg date in column A, I would like to find out the next service date of the vehicle. I need a formula that will add 18 months to the reg date then keep adding 18 months untill a certain date. But only if its less than my end date. Thins is driving me...

Hi MrExcel, I have a table like this : <tbody> Group Increment 1 1 1 1 1 1 1 1 2 1 2 2 2 1 2 2 2 1 2 2 3 1 3 2 3 3 4 1 4 2 4 3 4 4 4 1 4 2 4 3 4 4 5 1 5 2 5 3 5 4 5 5 </tbody> Basically a group is in the first column. Group one means...

Hi, I cannot figure the formula logic for the following operation: <tbody> A B C CRT STATUS Desired Result 1 P1 P1 1 P1 1 P1 2 P2 P2 2 P2 2 P2 3 P3 P3 3 P3 3 P3 3 P3 </tbody> I have a count in column A, that is the same untill a value changes in B, like...