livinlavidaloca
New Member
- Joined
- Aug 9, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
- Web
I am stuck, trying to work out the formula for this spreadsheet summary and would really appreciate some help!
Thank you in advance!!
- I want to create a formula which will leave a SINGLE tick in H3 if there are any non-empty cells in 'HMN.MBY' (the name of the tab I am extracting data from), G3:G34 (the cells within the sheet where I am extracting data from).
- Unfortunately, the only valid formula I have found so far replicates the column positioning of the non-empty cells from 'HMB.MBY, G3:G34'. It displays the ticks in order of which cells are non-empty in 'HMN.MBY'.
- What I actually want to do is have a single tick in H3 if there are any non empty cells in G3:G34 from 'HMN.MBY'.
Thank you in advance!!