• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find a character in a substring based on mutiple criteria

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

Attachments

  • Chandoo44155Test_02.xlsm
    280.1 KB · Views: 1
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.
 
Back
Top