Find a character in a substring based on mutiple criteria

[jonastiger]

Works perfect

I'm fairly sure this has already been addressed and demonstrated in cell O5 of the Folha4 (4) sheet of the file I attached to msg#5

This too

but if you want 12345 to be equivalent 54321, or even 51243 I can do it if you want?

That would be great and very kind of you
Thank you very much

 

[p45cal]

All three functions should be included for this to work:
ColmHdrs
numbersAscend
TheseAreTheSame

 

[p45cal]

Please note, that while the formula will update its results instantly when you alter the arrangement of crosses on the FINDER sheet, with a formula such as:
=ColmHdrs(J5:K30,DATABASE!B4)
it will NOT update instantly if you alter a cell in the DATABASE table. This is because Excel's calculation engine looks at the cells referred to in he formula and only recalculates if any of those have changed. In this case cell B4 doesn't change if other cells in the table change. What you have to do is to make sure the formula is recalculated, usually by just going as if to edit it, not changing it, and pressing Enter
The good news is that if you use the shorter:
=ColmHdrs(J5:K30,DATABASE)
where the reference is to the whole table, any change in the database table will cause the formula to update itself immediately.