Date filtering in Numbers

Question

Level 1

0 points

Date filtering in Numbers

I am using the checking template in Numbers. It seemed a good way to organise my expenses when travelling.

I wish to filter the data between certain dates (for example, every month.)

The program will not filter my entered dates in any type of selection. If I select a single date the program simply shows the header.

If I wish to select between two dates the program simply beeps after entering the first date.

I tried adding an extra column and re-entered dates with no success. I also tried different date formats.

I have read the manual and as far as I can see I am doing things correctly.

The other columns will filter OK.

Any ideas, please?

MacBook Pro, Mac OS X (10.7.5)

Posted on Oct 22, 2012 8:14 AM

Reply

Answer 1

Oct 22, 2012 8:22 AM in response to Bessacarr

can you post a screenshot? Maybe replace personal data with made up data and leave the dates .

Reply

Answer 2

Oct 22, 2012 9:12 AM in response to Wayne Contello

Ian,

To post a screen shot ise the key combination <COMMAND> + <SHIFT> + 3, then click the top left corner of the area to capture, hold the mouse button, then drag to the bottom right corner, then release. The screen shot will appear on the desktop as a file with then name "Screen Shot....", in this forum click the camera icon in the toolbar, then navigate to the file on your desktop.

I think you should use the reorganize panel to filter by date as:

Reply

Answer 3

Bessacarr Author

Level 1

0 points

Oct 22, 2012 10:24 AM in response to Bessacarr

Wayne,

Thanks for the excellent response.

To be fair to me, and the others who had the same problem, the User Guide could be better. As a reasonably literate man I assumed that "is between" was the way to go.

The words "date is" do not look promising until the second box pops up.

Thanks once again.

Reply

Answer 4

Oct 22, 2012 11:40 AM in response to Bessacarr

It toook me a minute to idendify that as well.

Reply