5 Responses to “Sort a range from A to Z [Array formula]”

1. Macro to insert array formula says:

   February 7, 2014 at 10:50 am

   […] = window.adsbygoogle || []).push({}); Hi, I'm working on a simple macro that would insert a simple sorting formula depending on the user selection. I took few lines of code to call a form enabling the range […]

2. HR says:

   November 10, 2015 at 2:53 am

   Hi, What if I want to sort alphabetically from B2 to E5 and keep the words within the range B2:E5? Thanks

3. fasal says:

   February 28, 2016 at 9:35 am

   how i sort a column through an excel formula

   and can u explain about tbl in your formula because i did not get that

   if u now about autofilter through a formula please give the formula

4. Markus says:

   November 8, 2017 at 4:42 pm

   Hi
   Thank you for all the info your providing

   How do I create a formula to consider a range of numbers, sort them in descending order then add up only the 6 highest numbers?

   yours truely
   Markus

5. ardiancharsy says:

   October 26, 2018 at 4:35 am

   in this case "Sort a range from A to Z [Array formula]"
   how about remove blank cell ?
   thanks

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes &lt; and > becomes &gt;

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form