Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I need the BOSS in excel :D If anyone can help...
#1
Any excel pros in the DIY forum? Smile 

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 (A2Big Grin2000 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?

Reply
#2
Plenty easy.

1. Select all of your data.

2. Go into the Data page.

3. Sort by ascending.

You're done Smile
The power of lithium ion is in our hands!
We'll show them what we're made of!
Reply
#3
=(LARGE(cells,ROW(INDIRECT("1:4800"))))

Where "cells" is a huge named range containing all your values.
WuggyBuggy likes this post
Reply
#4
(12-18-2018, 11:19 PM)w0067814 Wrote: =(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
Reply
#5
(12-18-2018, 10:31 PM)BlueSwordM Wrote: Plenty easy.

1. Select all of your data.

2. Go into the Data page.

3. Sort by ascending.

You're done Smile
Allready did that :Smile But to boring Big Grin
Reply
#6
(12-19-2018, 03:35 PM)WuggyBuggy Wrote:
(12-18-2018, 11:19 PM)w0067814 Wrote: =(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.
WuggyBuggy likes this post


Attached Files
.xlsx   Excel_Cell_Sizes_Example.xlsx (Size: 44.38 KB / Downloads: 20)
Reply
#7
Wow this is great woo! Thanks a bunch. I'll sit and take a good look at it!

Thanks again!
Reply
#8
It works great mate! Thanks a lot!

w0067814 likes this post
Reply


Who read this thread?
35 User(s) read this thread:
daromer, Sean, mike, Majorphill, Korishan, PAF, jdeadman, wim, watts-on, jesusangel, Stefaan De Ridder, BlueSwordM, Geek, Jon, djuro, BaronVonChickenPants, gpn, mbrunton, Crimp Daddy, MYPEARL, w0067814, WuggyBuggy, emuland-metroman, Beholder, singlecell, Wolf, Bastler_Ro, camthecam, Generic, Speicher, ajw22, kevinjaye, Phoenix-Blue, Church1182, JBonesaw

Forum Jump:


Users browsing this thread: 1 Guest(s)