For example if I had the numbers 3, 7, 9, 12, 15, 20 I would love to select filter, select "by proximity to" and then type in the number 10. Excel would then arrange the data as 9, 12, 7, 15, 3, 20 as 9 is closest to 10, 12 is the next nearest etc. It doesn't matter whether the number is higher, or lower than the given number.
It would be a really quick and easy way of saying if the mean of this data was 10 which data is closest to average, irrespective of whether it's higher, or lower than the average value.

For an amateur spreadsheet user, if there is a way to personalize the items on the Snapshot page, so I could see a snapshot of all my monthly spending, not only the Frequent merchants or merchants where the most was spent, it would be great.
I need a report I could produce using Money in Excel that I could take to a family meeting that shows all our monthly spending, yet organized. I realize I could copy and past info from my transaction page and then sort the way I want it, but having it already completed in a template would be awesome!

And if there is a template to change or add to the snapshot page boxes that are already created that would be great!

Thanks for listening!
Karen

If there is a way to personalize the items on the Snapshot page, so I could see a snapshot of all my monthly spending, not only the Frequent merchants or merchants where the most was spent, it would be great.
I need a report I could produce using Money in Excel that I could take to a family meeting that shows all our monthly spending, yet organized. I realize I could copy and past info from my transaction page and then sort the way I want it, but having it already completed in a template would be awesome!

And if there is a template to change or add to the snapshot page boxes that are already created that would be great!

Thanks for listening!
Karen

I want to sort data. However, the data in the table had references in it. I know that can cause problems. So I copy the table and paste it back in place with just the values.

This allows the sorting to work properly. However, sometimes I forget to do this and the sort gives strange results due to the links/ references to other cells getting corrupted. I would hope this would be a simple check that is worth doing before any sorting is done. Since sometimes I forget to do this and the sort gives strange results due to the references to other cells getting corrupted.

It works fine when I just use values. But it is an easy mistake to make since the spreadsheet looks the same unless you look at a cell that uses references.

Hello,

Background

Create a table with any data and make sure number of rows is bigger than your screen can fit.

Problem

CTRL+SPACE on a range

1. Convert a table to a range.


2. Press CTRL+SPACE.

Entire column is selected. View is not moved anywhere.

CTRL+SPACE on a table

1. Select any cell in this table visible on the screen.


2. Press CTRL+SPACE.

Entire table column is selected. View is moved to a last cell of selected table's column.

Proposal

Current behavior is not consistent and annoying. Imaging working with data somewhere in the row 10, selecting column and view shifted to a last cell to a row 1000.

A function that allows for a more complex cell reference that allows for compounding functions while still resulting in a basic cell/range.

Example you want a cell to equal cβ where β is a cell location determined by a random between or a number in another box.

Format
=Coord(Xaxis,Yaxis)
Xaxis a number value corresponding to a column reference (1=a 2=b….)
Yaxis a number value corresponding to a column reference

Usage
=Coord(1,5) results in A5
=Coord(1,RANDBETWEEN(1,3)) results in a either a1 a2 or a3 chosen at random

Notes: adding in an automatic alphanumeric value in the X_axis allows for use with existing functions to make this easy to use adding 2 boxes in the function screen one you enter numbers the other you enter letters and it will automatically convert the other box to the corresponding value

When using the filter button in a column it would be helpful for two characteristics to change.

First, after clicking on a filter and having the query window open, change the default focus to the "Search" box. At the moment there is no default so you have to move the cursor to select one anyway. That would speed up searching a filtered column greatly as it would eliminate key or mouse usage to get to the Search box.

Second, move "(Blanks)" from the last position in the list to the second position. Again this would eliminate us having to scroll through a potentially long list of entries to include blank cells in our criteria.