WuggyBuggy
Member
- Joined
- Aug 10, 2018
- Messages
- 78
Any excel pros in the DIY forum?
I have an idea for my excel sheet (Counting cells). But I cant find the right formula on google.
I have 4 rows of cells (A22000 ish).
I max want to count 4800 which I need for my packs (2x 14s200p). I want excel to sort out all the lowest cells first. So my max is always 4800, but when i add more high cells. The lowest cells will be deducted.
Is this possible (I'm sure if it, but not for a noob like me). But how?
I have an idea for my excel sheet (Counting cells). But I cant find the right formula on google.
I have 4 rows of cells (A22000 ish).
I max want to count 4800 which I need for my packs (2x 14s200p). I want excel to sort out all the lowest cells first. So my max is always 4800, but when i add more high cells. The lowest cells will be deducted.
Is this possible (I'm sure if it, but not for a noob like me). But how?