Hi,
I wrote a formula on the attached sheet to extract every 3rd row from the list, however, when I enter the formula with Enter, it gives me value error, however, when I enter the formula with Ctrl+Shift+Enter; data spills correctly.
I thought there was no need for Ctrl Shift Enter on office 365. Anyone can explain the reason why still I need CSE?
Thanks,
Bookmarks