Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 20, 06:57 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Get biggest value, then the smaller one

Hi

I d need a formula to find the biggest value,
then the smoller one , and so until about
15 values , from a range like this : AS11:AS42000 .


  #2   Report Post  
Old December 29th 20, 07:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default Get biggest value, then the smaller one

Hi,

Am Tue, 29 Dec 2020 09:57:12 -0800 (PST) schrieb Xxer Xxes:

I d need a formula to find the biggest value,
then the smoller one , and so until about
15 values , from a range like this : AS11:AS42000 .


try:
=LARGE(AS11:AS42000,ROW(1:15))


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old December 29th 20, 08:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Get biggest value, then the smaller one

Windows10
Office 2016


It work perfectly for me .
Thank you so much , Sir !


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Biggest Loser Formula JSR929 Excel Discussion (Misc queries) 8 January 22nd 08 08:40 PM
second biggest in array Arne Hegefors Excel Programming 1 April 17th 07 12:26 PM
Finding a name with biggest number Handyy Excel Worksheet Functions 11 February 6th 06 01:06 PM
Biggest commercial .xla file? RB Smissaert Excel Programming 6 December 18th 05 05:41 PM
Determining biggest variable Tommi[_2_] Excel Programming 2 February 3rd 04 03:36 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017