braindiesel
Well-known Member
- Joined
- Mar 16, 2009
- Messages
- 571
- Office Version
- 365
- 2019
- 2010
- Platform
- Windows
I am trying to build a part of a dashboard, and I want to pull the first 8 rows... but I really want UP TO 8 rows
Currently I am using a variation of
=CHOOSEROWS(myarray,1,2,3,4,5,6,7,8)
but My array has filters in it so the array may only be 5 items long, producing an error...
I really want it to be
=CHOOSEROWS(myarray,1,2,3,4,5,6,7,8) if 8 rows but =CHOOSEROWS(myarray,1,2,3,4) if only 4 rows
Any help with how to make my ROW NUMBERS variable is greatly appreciated
Currently I am using a variation of
=CHOOSEROWS(myarray,1,2,3,4,5,6,7,8)
but My array has filters in it so the array may only be 5 items long, producing an error...
I really want it to be
=CHOOSEROWS(myarray,1,2,3,4,5,6,7,8) if 8 rows but =CHOOSEROWS(myarray,1,2,3,4) if only 4 rows
Any help with how to make my ROW NUMBERS variable is greatly appreciated