Excel Database and Formulae Efficiency Help
Hi, I have an Excel sheet with more than 3200 records, of up to ~135 items (about 85 of which items approach crucial) collected on each record spanning differences in each year over the last 16 years or so. Quite a few have simple to complex formulae, lookups, and a need to look at algorithms in other sheets to arrive at my final analysis for each record.
I am seeking to simplify the way I array, analyze, and make decisions on each record (each of which has a significant date attached) We can start with just trying to solve single problems one at a time, or we can discuss the overall picture and how to make this so much better. Let me know your interest level, and let's see if we can work on this.
If you are interested in this kind of work, let me know, and we can discuss the approach.