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
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