View Single Post
 
Old 10-08-2017, 05:23 AM
nrsmd nrsmd is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2014
Posts: 22
nrsmd is on a distinguished road
Default Sorting problem in Excel

I have a sorting problem. I have attached a copy of the excel file (Excel 2010, Windows 7).

The name of the person needs to be sorted alphabetically.

For example, information about Jones (A1) is located A2, A3, A4, A5, A6, and A7 through Z2, Z3, Z4, Z5, Z6, and Z7. For example, for Jones, in B2 he paid $1. in C5 he paid $6, in X3 he paid $12.00, and so on.

The Grand Total paid in in Y1

Then, starting in A9, we start the exact same again with Mr. Anderson, with the next 6 rows dedicated to him (A9 through A15 continuing through Z through Z15.

Now, I want to put Mr. Anderson and ALL his information above Joone's information, as a sort.

THANKING YOU IN ADVANCE.

My email is nathan_strahl@yahoo.com
Attached Files
File Type: xlsx practice1.xlsx (10.8 KB, 19 views)
Reply With Quote