Forum Discussion
dsj7419
Jul 15, 2022Copper Contributor
Need help sorting data with additional variable of comparing date ranges
Hi all, This might be asking too much, but here's what i'm looking for. I have attached my excel grid. Basically, my goal here is to find out how many of an item I need to order. Everything ...
dsj7419
Jul 16, 2022Copper Contributor
I tried to edit text a bit for clarity, if anyone has questions please let me know! If someone can assist that would be amazing! there are times I need to add a LOT of columns, and sorting through it all can be a hassle. I'm trying to keep it in a way where I can track by column, but it still tracks the gear dynamically by day.
At one point, I'd love for that grid to account for day use, and spit out another grid on a separate tab that accounts the for the gear by date and gear (date on top, gear like it is) and updates dynamically with what I have in this tab. For now just being able to track what I have in original post would be so helpful! If anyone has ideas / help / better way they think I should do it, please let me know!