Forum Discussion

Iron Contributor

Jul 05, 2019

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

Every 10000th row help.xlsx418 KB

Formulas and Functions

Silver Contributor

Jul 10, 2019

I had a look at your file, but it is unclear to me what you are trying to achieve precisely. Can you please include (where possible) cell addresses in your request so we can see what information needs to be looked up where?

calof1
Iron Contributor
Jul 11, 2019
HiJKPieterse

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.

Every 10000th row help.xlsx588 KB
- JKPieterse
  Silver Contributor
  Jul 11, 2019
  calof1 Like in the attached? (green cells)
  Copy of Every 10000th row help.xlsx589 KB
  - calof1
    Iron Contributor
    Jul 12, 2019
    HiJKPieterse
    
    Thank you for the assistance, this works for my criteria perfectly.
    
    Thank you again for your help.
    
    Kind regards,
  - Theo_Bear
    Copper Contributor
    Jul 11, 2019
    JKPieterse
    
    Hi
    is it wise to use array formulas which do slow down calculations given the already big size of the data set? Wondering.
- Theo_Bear
  Copper Contributor
  Jul 11, 2019
  calof1
  Hi
  I see you have Macros in the workbook? Also noticed that the first 10000th rows are a year . Why don't you break your workbook into sheets named year 1, 2 and 3 each sheet will only have 10000 rows? Might make it easier for you?

Resources