Dear Team Members,
Hope you are all doing well.
I need some help with regards to my excel file. (Sample file attached)
I have an array containing data into rows and columns.
I want to search for a string in one of the columns (Lets say the first column)
For eg : In the attached file, I have shown the search text as "red"
I want the formula to search in the entire column for the string "red" and return the entire row as outputs.
So If "red" appears 5 times .. it should return all those 5 rows where the text "red" appears.
I have shown the desired output as well in my excel file.
Please help !!
Hope you are all doing well.
I need some help with regards to my excel file. (Sample file attached)
I have an array containing data into rows and columns.
I want to search for a string in one of the columns (Lets say the first column)
For eg : In the attached file, I have shown the search text as "red"
I want the formula to search in the entire column for the string "red" and return the entire row as outputs.
So If "red" appears 5 times .. it should return all those 5 rows where the text "red" appears.
I have shown the desired output as well in my excel file.
Please help !!