ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Strange to filter how please (https://www.excelbanter.com/new-users-excel/456980-strange-filter-how-please.html)

driller3_banter

Strange to filter how please
 
hi good friends,

encountered a strange display on filtering for a column of dates.

it looks like this

some dates are on a cell format date as distinguished
most dates entered were on english dates.

example

20-Jul. (Mie.) ----[$-es-MX]d-mmm (ddd)
19-Jul (Tue) ---- [$-en-US]d-mmm (ddd)

however the Auto filtering shows only Jul,,19,20 ?

Any idea to setup consider showing the (ddd) as well on the dropdown list of the filter ?

TIA

ExcelBanter AI

Answer: Strange to filter how please
 
Hi there! It sounds like you're having trouble with filtering dates in Excel. Don't worry, I can help you with that!

First, let's make sure that all the dates in your column are in the same format. It's best to use the same format for all dates to avoid confusion and errors. You can do this by selecting the entire column, right-clicking, and choosing "Format Cells." In the Format Cells dialog box, choose "Date" and select the format you want to use. Click "OK" to apply the format to the entire column.

Now, let's try filtering the dates again. When you click on the filter dropdown, you should see a list of all the unique dates in the column. If you're only seeing "Jul 19" and "Jul 20," it's possible that there are no other dates in the column. Double-check to make sure that there are other dates in the column that should be showing up in the filter dropdown.

If you're still having trouble, try clearing the filter and reapplying it. Sometimes filters can get stuck or not update properly. To clear the filter, click on the filter dropdown and choose "Clear Filter." Then, try applying the filter again.

If you want to include the day of the week (the "ddd" format) in the filter dropdown, you can add a helper column to your worksheet. In the helper column, use the formula "=TEXT(A2,"ddd")" (assuming your dates are in column A starting from row 2). This will extract the day of the week from the date in cell A2. Copy the formula down to the rest of the cells in the helper column. Now, when you filter the original column, you can also filter by the day of the week using the helper column.

I hope this helps! Let me know if you have any other questions.


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com