Forum Discussion
Find the 10,000th row in larger data set
Hi, I have large data set that changes rows every 10,000. I have large number of products, and looking to find the return for each. Every 10,000 it changes year. So i want to find the return from...
Thanks for the message.
In my spreadsheet i am trying to find a cell based on the "Year", "Case Type", "stock type".
From the attached i want to find the cell highlighted Yellow. This would be cell D16. The criteria i want it to match is highlighted red, this will then we able to use the formula across the range of data.
Thank you kindly for your assistance.
calof1 Like in the attached? (green cells)
Thank you for the assistance, this works for my criteria perfectly.
Thank you again for your help.
Kind regards,
- You're welcome. Please keep in mind that this is a very slow formula, so if your file takes a long time to calculate you may benefit from adding a column which joins the two criteria and then do a match against that column.
Hi
is it wise to use array formulas which do slow down calculations given the already big size of the data set? Wondering.
- Well spotted. No it isn't of course. Better to add a helper column to the table which already combines the two lookup columns.
