Return to Answer

updated first formula as was incorrect.

Source Link

edited Jun 15, 2017 at 13:41

To combine the second and third column into only 1 helper column I deviced the following formula's:

In the first cell of the second column I keptput the originalfollowing formula: =--ISNUMBER=IF(IFERRORISNUMBER(SEARCH($B$3,E3,1))=FALSE,"",--ISNUMBER(SEARCH($B$3,E3,1))

In the second cell and down I wrote the following formula: =IF(--ISNUMBER(IFERROR(SEARCH($B$3,E4,1),""))=0,"",COUNT($E$3:$E3)+1)

To combine the second and third column into only 1 helper column I deviced the following formula's:

In the first cell of the second column I kept the original formula: =--ISNUMBER(IFERROR(SEARCH($B$3,E3,1),""))

In the second cell and down I wrote the following formula: =IF(--ISNUMBER(IFERROR(SEARCH($B$3,E4,1),""))=0,"",COUNT($E$3:$E3)+1)

To combine the second and third column into only 1 helper column I deviced the following formula's:

In the first cell of the second column I put the following formula: =IF(ISNUMBER(SEARCH($B$3,E3,1))=FALSE,"",--ISNUMBER(SEARCH($B$3,E3,1))

In the second cell and down I wrote the following formula: =IF(--ISNUMBER(IFERROR(SEARCH($B$3,E4,1),""))=0,"",COUNT($E$3:$E3)+1)

Source Link

answered Jun 15, 2017 at 13:32

Luuklag

To combine the second and third column into only 1 helper column I deviced the following formula's:

In the first cell of the second column I kept the original formula: =--ISNUMBER(IFERROR(SEARCH($B$3,E3,1),""))

In the second cell and down I wrote the following formula: =IF(--ISNUMBER(IFERROR(SEARCH($B$3,E4,1),""))=0,"",COUNT($E$3:$E3)+1)