Sometimes we think there is very little we can improve in something and then we come across an idea that would change our perceptions. I have been writing excel formulas for such a long time that it was easier to remember when I first shaved than when I first wrote a formula. (may be, because of the razor-blade-thin-chin-trembling-hands experience)
Today I want to present a very interesting functionality in Excel that would save a lot of time when you are entering formulas in spreadsheets.
If we have 5 cells and we want to CONCATENATE all the text in them to one cell, we would usually write =CONCATENATE( and then start typing addresses of each cell one by one. But there is a faster and simpler way to do this. You can just hold the CTRL key down and select all the five cells one after another and excel will neatly type the references for you and include a comma to separate them. See this:
You can also use the same technique for speeding up formula entry for other multi-argument formulas like VLOOKUP, MATCH etc. Just select the cells corresponding to each parameter in that order while holding the CTRL key down.
Read more quick tips and save a ton of time and impress everyone.
2 Responses to “Weighted Sorting in Excel ”
Just add a column calculating the "performance" or whatever is your criteria and sort by it? No?
have no patience to waste 13min. Save your time too.
Just thought I would mention, the "weird" custom sort behavior mentioned at 5:45 where "% return" doesn't appear to be sorting is because the "August Purchases" field has the sort preference and since these are such unique values, no additional sorting is possible on the "% return" field. If there were two entries that had the same "Customer Since" year AND the same "August Purchases" amount, THEN you would see a sorting of the "% return" on these two entries.