Large Data set alternatives!

himanshuagarwal

New Member
Joined
Sep 23, 2020
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I am trying to create a sample file for our users where they can input the data and create bulk upload files to be uploaded in our system.
I created a sheet as data base which has a list of about 100,000+ entries in 5 columns.
Another calculation sheet was created to check if the users input is there in database or not and then return the match as per our database.
We want to give users about 2000 rows for input
The issue is that the calculation sheet now created as 2,000 X 100,000+ formulas and the file size just humongous, it crashes my PC everytime.
Is there an alternative which can used in this case or any solution within excel?
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,118,140
Messages
5,570,402
Members
412,321
Latest member
Yusuf_A
Top