BrendanDixon
Board Regular
- Joined
- Mar 7, 2010
- Messages
- 174
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All,
I am a but stuck trying to work out this formula. I want to a formula to return the row numbers in a list that are not blank. so for example. from B2 to B102 is the list rows 3, 10 and 20 have values in them. I want to have a string something like 3, 10, 20
Can anyone advise how I can do this?
I am a but stuck trying to work out this formula. I want to a formula to return the row numbers in a list that are not blank. so for example. from B2 to B102 is the list rows 3, 10 and 20 have values in them. I want to have a string something like 3, 10, 20
Can anyone advise how I can do this?