Find all function/formula

[N.Vek]

Dear all,

I would be extremely grateful for your help....

I am working with a large excel dataset - 64807 rows, 82 columns - with combination of text and numbers.

I would like to use excel FIND ALL function/formula to identify within the entire dataset:
- a freetext word e.g. 'restraint' and ALL the cell rows this word is mentioned

I have tried the FIND ALL function on the excel toolbar, this gives me a result e.g. 256 cells found, details - cell $BG$3288, $AI$3431, $AI$4623, $BD4623,$BE$4623 - as you can see excel has identified same cell row 4623, three times and identified the different columns the freextext word I am searching for.
• Is there a way that all rows containing freetext word can be identified, without cols?

• Can I view (without expanding) extract this information easily, to save me keep clicking NEXT to identify the cells the freetext word has been identified?

• Is there any other method function/formula I could use to obtain this information easily? I tried in the formula bar =FIND(“restraint”, sheet ref, data range e.g. A1:CD64807) but this did not work

Many thanks in advance for your help.

[cyiangou]

Try this:

restraint_cy.xlsm

Please Login or Register  to view this content.

[N.Vek]

thank you for your reply, I am not familiar with excel language and do not know where to start with trying to follow your instructions that work!