Hello
I want to count only the rows that contain at least one cell of data (text and/or numbers), within a varying range of columns. I don't want to specify the range of columns using their fixed column letter names, but using the text in row 1 as the column header. This Row 1 text is set up to be variable, so it will be different for every individual usage of the workbook that I am creating, so I can't just plug in the fixed column names, and I can't add in a 'helper' column as I don't know how many columns the data will occupy.
Here is a demonstration of what I'm trying to do (where '1' could be any text or number value).
1 | 1 | 1 | 1 | 1 | 1 | ||||
1 | 1 | 1 | 1 | ||||||
1 | 1 | 1 | 1 | 1 | 1 | ||||
1 | 1 | 1 | |||||||
1 | 1 | 1 | 1 | ||||||
1 | 1 | 1 | 1 | ||||||
1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
Ideally I want a formula (rather than a Macro/VBA code) to put into a cell on another sheet that returns this answer. If I use a Macro/VBA then it will decrease the user-friendliness of the workbook I'm creating (it's a tool for my non-technical team to automate quantitative survey data analysis, with variable, but predictable, data inputs).
Hope it all makes sense - let me know if not and I can clarify. Any help very much appreciated!
Many thanks
Matt