Guy has attended:
Excel Intermediate course
Tables
Hi there,
I have created a table that is designed to show market rates entered comparing buying and selling.
The table is displayed as;
Month;
Buyer, Size, Rate | Rate, Size, Buyer
The left side is buying and the right side is selling. Would it be possible to create the table in such a way that each side automatically sorts in Highest/Lowest or Lowest/Highest order?
RE: Tables
Hello Guy,
Thank you for your question. Unless you use VBA coding, Excel won't automatically sort data. The simplest way to sort manually is to right-click the column you wish to sort by and then pick the desired sort option.
If you have separate data sets, make sure there is an empty column between the tables if you want to sort them differently.
I hope this helps.
Kind regards
Marius Barnard
STL
