I don't know that Excel functions could do this. I would use VBA or maybe PowerQuery.
Could you post the Excel file? Follow instructions at bottom of my post.
I don't know that Excel functions could do this. I would use VBA or maybe PowerQuery.
Could you post the Excel file? Follow instructions at bottom of my post.
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
