3 ms·
What I was getting it at exactly. What prevent a user to split data in thousand of spreadsheet? Given how the corporate world run on excel... someone has done
by dopidopHN 6y ago
What I was getting it at exactly. What prevent a user to split data in thousand of spreadsheet?
Given how the corporate world run on excel... someone has done it, somewhere.
- chrismarlow9 6y agoI'm sure it happens all the time from a logical perspective without the user even knowing what a shard is. Example: Too many rows? Okay let's just break it up into monthly sheets and then change this formula to look up the value based on the month. Maybe just use a drop-down for the sheet selection. I think most people could arrive at this answer intuitively who have enough excel experience.