I need aformula at F2 and draga down ,which work like:if A2 is a number and in K1:K18 there are numbers(in case I put manually) and A2 matches in the range of K1:K18 write 1 if not exist write 0. the most important is when there no numbers at K:1K18 should show embty/blank.!! so the formula works only in case there are numbers at K1:k18.
thanks so much for your help at this forum!!!
Bookmarks