you have already shown us that pic, and copied the same to here. what i said was that you need to copy the formula to an empty cell, next to you're data. so, if you're data is in column A, starting from A1, then in B2 (if that is in use, pick any empty cell/column) copy my formula there, and then copy it down as far as you need.
if you still have a problem, upload a sample WORKBOOK please
Bookmarks