Two sets of two coluns of data on the same spreadsheet add toget

Resolved · High Priority · Version 2016

Mon 23 Jul 2018, 10:29 Delegate Sam said...

Sam has attended:
Excel Advanced course

Two sets of two coluns of data on the same spreadsheet add toget

I have two sets of data both are in two columns, how do I add them together by Smallest to largest so I dont have to reorder them there are two columns. I can send the file if needed. As it is easier to show on there.

Mon 23 Jul 2018, 11:14 Trainer Jens said...

RE: Two sets of two coluns of data on the same spreadsheet add t

Hi Sam,

Thank you for the forum question.

Please forward the file to:

jens.bonde@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips