finding address of nth occurrence of text within sheet including selected variations.

Hello
Maybe something like this CSE formula would work for you:

Formula:

Please Login or Register  to view this content.

Here the nth occurrence is placed in cell C2. The FIND function looks for any occurrence of upper case "AD" within each cell.

Hope this helps.
DBY

Hi DBY,

thank you for your help! I had actually managed to solve this but by the time I had I was just too frustrated to even look at Excel again let alone update my progress yesterday.

I ended up using exact for "AD" and nested if's and serches for the the other variations "*/AD" and "AD/*", I also needed to build in dynamic referencing so there's a few indirect's as well but here's the entire formula:

Please Login or Register  to view this content.

where:
U$1 dictates the value of the Nth term.
$C5 the row reference
$F$2 the search reference (in this example "AD")

I believe the find function would find the AD in the word BAD as well as standalone AD references, which is not what I needed