Thread: Sorting rows based upon YTD scores highest down
View Single Post
 
Old 07-25-2017, 12:32 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
At present the formulas span the rows 5:26. If you extend that range in your table you must adjust the formulas accordingly.

Please note that the formulas in column AF are array formulas. They are special in that they must be entered a certain way. Where you normally just press Enter when finishing a formula, an array formula must be entered by holding down Ctrl and Shift before pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula. Don't try to enter these braces manually. This will just lead Excel to think it is a text string and not a formula. When you have entered one array formula correctly you can copy to other cells as you normally do.

You can hide column AB:AC if you want or you can move the formulas in those columns to another place.
Attached Files
File Type: xlsx EXample_5.xlsx (15.0 KB, 9 views)
Last edited by xor; 07-25-2017 at 07:37 PM.
Reply With Quote