Could someone tell me how I can return the column number of a cell that contains a specific string of text, please?
I have a spreadsheet that contains certain headings, but when it is used any or all of the headings might be included (according to choices made before using it) so they can be in different columns each time. I need to be able to refer to cells under that heading, so I need to be able to determine which column the heading is in this time ... does that make sense?! I hope so!
Once I have the column number it will be assigned to a variable so I can use it in calculations.
Many thanks for any help, which is much appreciated!