In a table i have 4 columns and 9 rows.My input is in form of yes and no.
If any of the cell has "yes" i want it to extract date in first column.If single row has multiple "yes" i want if to extract date the number of time "yes" appears in row.
I have explained it in form of input and output in excel attached.
Thanks for help in advance!
Regards
Bookmarks