hello I am new to the forum and i want some help for this problem
Date Name Fruit Remarks July 10 bbng apple good July 12 bbng orange bad July 13 bbng apple so-so July 14 bbng grape very good
notice how that July 10 and July 13 have the same name of fruit?
I want to check first if Name is "Bbng" then check if fruit is "apple" if both are true I would like to output the date and remarks on a new worksheet
i got July 10 using ISERR(SEARCH("apple") and INDEX(A:A,(Match())) forumla.. but i couldn't get the one on July 13th...
thank you for your help in Advance.. and hope my explanation is clear...
bbng
Bookmarks