Hi all,
I have the following array formula that return the first 10 records (where Variables!$F$3 = 10)
Formula:Please Login or Register to view this content.
Then I want to return in another column the next 10 i.e. between Variables!$F$3 and Variables!$F$3*2
I have tried this following formula:
Formula:Please Login or Register to view this content.
But putting in the AND formula, the formula fails completely. I can't figure out how to return the next 10.
Can anyone help?
Many thanks in advance,
Alex
Bookmarks