trying to implement vfind to a counta code.

is it possbile to use vfind if statement to do nothing. Im trying to get rid of on error resume. Sometime does the formula twice so i have the two last rows with the same number.

Im trying to put the two bottom codes together. I want to try and keep everything with vfind.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Post a Sample WORKBOOK.
Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.