Hi Everyone,
This is probably a simple question for most, but I'm absolutely stuck.
I have a qualitative data set where I need to quickly see all the cells (not rows) highlighted that contain certain terms.
I can create a searchbox with exact matches with "=A4=$B$1", but I can't seem to make it do a partial match.
Does anyone have any ideas?
Thanks
This is probably a simple question for most, but I'm absolutely stuck.
I have a qualitative data set where I need to quickly see all the cells (not rows) highlighted that contain certain terms.
I can create a searchbox with exact matches with "=A4=$B$1", but I can't seem to make it do a partial match.
Does anyone have any ideas?
Thanks