12-18-2018, 10:23 PM

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?