AutoFill in Formula (R1C1 Style) till data found in adjacent column, multiple IF(AND

[analyst]

Thank you Sir, the correct formula is given in this thread - http://www.excelfox.com/forum/f2/vba...1616/#post7554.

Sincerely, I apologize, as I did not want to break the rules of the Forum. So, please Merge the thread, and regret the inconvenience to the forum resources, if i have caused.

I would be greatful, if u can consider the other thread with correct formula given in there attached workbook, or I'll try to take clue from here.

Thanks.

P.S.: I've understood the concept, but there is mistake in formula for Column R, which just have forumla '=1+1', instead of what is being mentioned in Part 1. But, concept is clear, though i could not fix the issue.