Monday, January 9, 2012

Excel Monster

I have created an Excel file that has 175,635 rows of data. It contains all the clock in/out data for work orders for the past six months. Now I'll need to do a VLOOKUP to assign a project code to each transaction. Maybe it's time to take it into Access or something.


VLOOKUP takes about 2 minutes to refresh. Definitely need to do something different.

No comments: