I need the BOSS in excel :D If anyone can help...

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 (A2:D2000 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?

image_maczyy.jpg
 

BlueSwordM

Active member
Joined
Jul 5, 2017
Messages
430
Plenty easy.

1. Select all of your data.

2. Go into the Data page.

3. Sort by ascending.

You're done :)
 

WuggyBuggy

Member
Joined
Aug 10, 2018
Messages
78
w0067814 said:
=(LARGE(cells,ROW(INDIRECT("1:4800"))))

Where "cells" is a huge named range containing all your values.

=(LARGE(2:200;A: D(INDIRECT("1:4800"))))

is this correct? I get a REF! Had to make a space after A: or it will make a smiley. Seems like the 1:4800 is not enough. Hmm
 

WuggyBuggy

Member
Joined
Aug 10, 2018
Messages
78
BlueSwordM said:
Plenty easy.

1. Select all of your data.

2. Go into the Data page.

3. Sort by ascending.

You're done :)
Allready did that ::) But to boring :D
 

w0067814

Member
Joined
Jun 24, 2018
Messages
42
WuggyBuggy said:
w0067814 said:
=(LARGE(cells,ROW(INDIRECT("1:4800"))))

Where "cells" is a huge named range containing all your values.

=(LARGE(2:200;A: D(INDIRECT("1:4800"))))

is this correct? I get a REF! Had to make a space after A: or it will make a smiley. Seems like the 1:4800 is not enough. Hmm

Yes, my original formula is correct, which is amazing as I did it on my phone. Too many brackets though.

It returns an array of values from a named range of cells called "cells". Attached is an example of how you can use it.

Hope this helps.
 

Attachments

  • Excel_Cell_Sizes_Example.xlsx
    44.4 KB · Views: 202

WuggyBuggy

Member
Joined
Aug 10, 2018
Messages
78
Wow this is great woo! Thanks a bunch. I'll sit and take a good look at it!

Thanks again!
 
Top