This is my first post. Hello everyone.
I do not know excel functions. I am learning excel. I would like to do following function. Someone kindly help me do this function.
My spread sheet contain A1 to G1 following text data
A1 = John
B1 = Mark
C1 = Mike
D1 = Dan
E1 = Alton
F1 = Joe
G1 = Peter
I would like to search cells A1 to G1 for text “Alton”. If text “Alton” is occupied any of the cells from A1 to G1 than H1 cell should display “X” ; If text “Alton” is NOT occupied any of the cells from A1 to G1 than H1 cell should display “Y”.
Thanks.
Bookmarks