QUARTILE Row Limit

JustinGM

New Member
Joined
Oct 30, 2005
Messages
13
I am wanting to use the QUARTILE function on a dataset that may contain 200,000 records. I understand that the QUARTILE function can only cope with up to 8900 odd rows of data.

Do any of you clever folk out there know of a way to get around this problem? If there is a way then I could split my data and have a named range that spans numerous worksheets.

Thanks in anticipation.

Justin
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,764
Members
412,291
Latest member
marypolitan
Top