I have it stored in say A3, it is just a countif statement because in L1:L2000, i have numbers that repeat so like 20-1's, 20-2'2, so i am counting the number of 1's to give me the number that my array needs to go down to. Hope this helps. Thanks!