Reply to thread

Message: [QUOTE="exceluser, post: 3868688"] Minyeh, Thank you for responding with your idea. Actually, when I first started attempting this solution, an array entered formula was used. And it worked as needed - no zero's for the FALSE values. But unfortunately, using an array entered formula like this in over 15,000+ cells on the Order worksheet causes the CPU to hit near %100 utilization for 90 minutes every time new data is imported each day. This makes working with the spreadsheet an exasperating experience. It would be useful to know what an array entered formula is doing behind the scenes to exclude the 0's in an INDEX array. Alternatively, I could buy an 8 core processor machine (sarcasm). Exceluser [/QUOTE]