Sorting

Resolved · Low Priority · Version 2007

Mon 12 Mar 2012, 16:56 Delegate Christina said...

Christina has attended:
Excel Intermediate course
Excel Advanced course

Sorting

If there is space in the data, will the sorting still work?

Tue 13 Mar 2012, 11:05 Trainer Paul said...

RE: Sorting

Hi Christina,

In a normal table it wont work it will only sort the data until the blank row. However, if you first select the entire table manually and then select >insert (on the ribbon) > table, then your table will be formatted as an excel table and this will allow you to sort your data with blank rows or spaces, the blank row or cell will go to the bottom on the table.

Thanks
Paul

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)