Tables

Resolved · Low Priority · Version 2016

Wed 16 Aug 2017, 08:04 Delegate Guy said...

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?

Thu 17 Aug 2017, 13:33 Trainer Marius said...

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

Thu 24 Aug 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips