Hi Experts,
Need your advice on small thing. I have a Sheet & column A consist of Serial Number which I input in Cell A2 by using formula =A1+1, now I have a tricky situation. I want this series of numbers based on certain condition in column B
For eg. column B some cells in column B term "FIRST" and some cells contails "PART"
I want the Cell in Column A to be blank if corresponding Cell in Column B contains "PART" and I want to put series of number in continuation if Cell in Column A Contains term "FIRST"
I tried using formula - but it throws error if above cell is blank.
Any kind of help is highly appreciated. Thanks.
Bookmarks