tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Evenone,
I thought this would be easy but i dont know the words to do it? please help.
I have a sheet nameed data with about 10,000 lines of data
i've split the view at row 10 so i can scroll dowbn and still see whats going on above (I've used the freeze panes button)
as i scroll down i'd like a formula to do the folllowing
in column B show me the number 1 in the first visible row after row 10 (the last fixed row) so as i scroll down 11 = 1, but that gets hidden so it changes to 12, 13 etc.
can this be done?
please help if you can
Thanks
Tony
I thought this would be easy but i dont know the words to do it? please help.
I have a sheet nameed data with about 10,000 lines of data
i've split the view at row 10 so i can scroll dowbn and still see whats going on above (I've used the freeze panes button)
as i scroll down i'd like a formula to do the folllowing
in column B show me the number 1 in the first visible row after row 10 (the last fixed row) so as i scroll down 11 = 1, but that gets hidden so it changes to 12, 13 etc.
can this be done?
please help if you can
Thanks
Tony