I'm copying an excel spreadsheet I got from somebody off of editgrid.com
In their spreadsheet, they have this formula in H4:
Then in the following cells in column H, they use this formula:=array(frequency(D2:D6395,G4:G205))
The issue I'm having is these appear to work fine on editgrid.com, but when I download the spreadsheet and open it in Excel, all I get is #NAME? for these values.=continue($H$4,2,1)
What's the problem here and how can I fix it??
Bookmarks