It is simply amazing to see, how Excel has made things so easy for all of us. Fantastic video Alan !!!
@Computergaga4 жыл бұрын
Thank you very much, Sachin. Long may it continue.
@arnaudmanir Жыл бұрын
One of the most valuable Excel tutorial videos I've ever came across with. Much obliged sir!
@Computergaga Жыл бұрын
You're very welcome! Thank you so much.
@markhuang368 Жыл бұрын
Thanks. This is a great video for a person like me who almost use sort function every day. The essence lies in using {3,2,1} to sort by columns sequently.
@Computergaga Жыл бұрын
Thanks Mark. Much appreciated.
@yusun45924 жыл бұрын
The dynamic array is just simply AMAZING!
@Computergaga4 жыл бұрын
You're right there Yu Sun. I love them 😍
@paulsingleton60714 жыл бұрын
Thank you for this video. I especially liked the advanced sorting using the arrays. Much appreciated.
@Computergaga4 жыл бұрын
You are welcome, Paul. Thank you.
@vignesh10653 жыл бұрын
This was the exact video I was looking for! For days! Finally found it! Thanks a ton! :)
@Computergaga3 жыл бұрын
Excellent! You're very welcome.
@vignesh10653 жыл бұрын
@@Computergaga Subbed! :)
@makingstuff4042 Жыл бұрын
kzbin.infoGWNhDXi7Am4?sub_confirmation=1 Short vid on how to use sort function
@jairolgraterol88536 ай бұрын
Thank you , for that GRANDDD class !!!!..
@Computergaga6 ай бұрын
You're very welcome. Thank you.
@meniporat35273 жыл бұрын
An excellent explanation. Thank you, Alan
@Computergaga3 жыл бұрын
Thank you, Meni.
@makingstuff4042 Жыл бұрын
kzbin.infoGWNhDXi7Am4?sub_confirmation=1 Short vid on how to use sort function
@darrylmorgan4 жыл бұрын
Great Tutorial..These New Functions Certainly Make Life Easier!Thank You Alan :-)
@Computergaga4 жыл бұрын
Yes, they are awesome. Thank you Darryl.
@m.raedallulu41662 жыл бұрын
Sorting an array.. with Alan Murray! Yay! Yay!
@Computergaga2 жыл бұрын
😊 👍
@wayneedmondson10654 жыл бұрын
Hi Alan.. great video. SORT and SORTBY sure make things easier than trying to do the same with array formulas in legacy EXCEL. Thanks for the great examples and insights. Thumbs up!!
@Computergaga4 жыл бұрын
Thank you Wayne. They sure do.
@makingstuff4042 Жыл бұрын
kzbin.infoGWNhDXi7Am4?sub_confirmation=1 Short vid on how to use sort function
@Luciano_mp4 жыл бұрын
Thank you Alan!
@Computergaga4 жыл бұрын
You're welcome. Thank you, Luciano.
@ihabbeghdaoui65882 жыл бұрын
Thank you
@Computergaga2 жыл бұрын
You're welcome
@mmob123 Жыл бұрын
brilliant! Just what I need today with my report :D
@Computergaga Жыл бұрын
Great! Thank you Marc.
@RamKumar-vb4et Жыл бұрын
Great video, do you have a video that explain the use of curly brackets in general? Thanks,
@Computergaga Жыл бұрын
Thank you, Ram. I don't have a specific video for that, but the curly brackets are for arrays. In this video, they are used to create an array of constant values i.e., {2,1}. You will see curly brackets used whenever Excel returns an array.
@maiggydicosta4 жыл бұрын
Excellent sir
@Computergaga4 жыл бұрын
Thank you.
@DDX012 жыл бұрын
Great sir amazing
@Computergaga2 жыл бұрын
Thank you 😊
@raymondgandi34403 жыл бұрын
I can't call "issues" function on my worksheet, how did you do that?
@rahulshewale92064 жыл бұрын
Thank you sir
@Computergaga4 жыл бұрын
You're welcome, Rahul.
@samkab677 Жыл бұрын
Is there an old school method for sortby function for previous excel version
@brandanbaker56043 жыл бұрын
This is the video I was looking for! Wow! Quick question if you don't mind, anyone.... How can I just return "The Top 5" in a sorted list of values? (doing Baseball stats, and want to return the Top 5 in Hits, and their names). Thanks in advance.
@Computergaga3 жыл бұрын
Great! Thank you, Brandan. I have a video on doing that here - kzbin.info/www/bejne/qZyWq2ubZ9KppMk
@ktkkoko43313 жыл бұрын
Thanks sir
@Computergaga3 жыл бұрын
You're welcome.
@hazemali3824 жыл бұрын
I am crazy about this channel
@Computergaga4 жыл бұрын
😜
@nguyenducviet34362 жыл бұрын
nice video. btw, how it can be realized as a table when you click the column?
@luapnagle3 жыл бұрын
Love your videos………………………. I would like SORT to be selectable so that I can change the COLUMN that is sorted from a DROP-DOWN selection. I have got the following working where you select a NUMBER from a DROPDOWN, and it then works in the formula if you use INDIRECT - The problem is this formula is not DYNAMIC. Any suggestions to make a DYNAMIC selectable sort on COLUMN drop down =SORT(B11:D23,INDIRECT("G8")) this works but is not dynamic G8 is a dropdown 1,2,3 for columns B,C,D
@AcceptableBread3 жыл бұрын
Excellent tutorial! Do you have a video for sorting alphanumeric data? For example AA-1, AB-1, AC-1, AA-12, AB-13, AC-14...etc. Thanks.
@Computergaga2 жыл бұрын
Thank you. No, not on alphanumeric. Excel uses Custom Lists for text data outside of the typical A-Z, but that sounds awkward if you have many items.
@davidsyes59704 жыл бұрын
Hi. Nice vid. Inspirational as always. Is the "row" argument intended to assist the new SORT/SORTBY functions in the case two SUMIFS'D products have the same total/count? I wondered that as soon as I saw you paste in the little bit to find the array and sort the product names base on the SUMIFS piece.
@Computergaga4 жыл бұрын
Thank you, David. The row argument is asking if you want to sort by columns or rows. We are sorting the rows, but you could set that to true to sort the columns, which is very rare.
@davidsyes59704 жыл бұрын
@@Computergaga Thanks for replying, :). Ah, I see. Makes me wonder. Perhaps some people would in those rare cases sort by columns with the intent to impact the data story of charts. Say, a header might be names or places, but a "header-header", if you will, might be a date or a manual number to force presentation. Cheers!
@st.thomasabecketparish3 жыл бұрын
I am using Excel 2010 and I have a question regarding sorting with multiple values in a cell... I have a database where participants checked off boxes to a questionnaire. So now I have a cell with multiple values like 1 or 2,10 or 1,2 or 1,2,10 or 1,5 the numbers represent a person's choice or choices.... how would I sort let's say I wanted everyone who chose choice #1?
@luapnagle3 жыл бұрын
Why did you not just use SUMIFS in column I - With SPILL# - =SUMIFS(x:x,x:x,H1#) to get the totals for each unique value or was this just to demonstrate SORTBY getting the data ?
@neharajput47334 жыл бұрын
Amazing video..sir.. kindly share the link for the excel practice sheet...!
@Computergaga4 жыл бұрын
Thank you very much, Neha. You can download the file here - www.computergaga.com/_excel/files/365-functions/sort-and-sortby.xlsx
@70pjsmith4 жыл бұрын
@@Computergaga Unfortunately, this link also does not provide the practice file.
@akizza473 жыл бұрын
Thank you for the video! I’ve been trying to sort referenced cells for ages whilst (keeping the references intact) and it’s been ordering them by the function not the value of the referenced data! Do you know how I can use this function to sort discontiguous arrays? Or how in functions I can make it apply to a discontiguous range? E.g: the array would be cells a2:a17 and also cells d:2:17 but I must neglect columns b and c. I’ve tried using a2:a17&d2:d17 as the array, using names ranges, and using indirect () functions and it doesn’t work!
@Computergaga2 жыл бұрын
Hi, yes you can do this with CHOOSE. The following formula extracts only ranges D2:A17 and D2:D17. It sorts the array by column 2 (D2:D17) in a descending order. =SORT(CHOOSE({1,2},A2:A17,D2:D17),2,-1)
@LayneNguyen2 жыл бұрын
What is i want to order by Total demand Confirmed PO Cumulative Delta In that order each time for each part number I have for materials? When I sort it puts it out on the order I have it in. Can anyone help?
@Computergaga2 жыл бұрын
This question is beyond the scope of this comment box. The responder would need the data and more detail.
@LayneNguyen2 жыл бұрын
@@Computergaga I figured it out. Thanks for the response.
@prajwel41292 жыл бұрын
❤
@Computergaga2 жыл бұрын
😊
@redhaakhund12713 жыл бұрын
👍👍👍👍👍am trying to download the file and it say Not found, error 404?!