| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Is there anyway this can be done with out using the filter?
"CLR" wrote: You could break out the date components into separate columns using........ =DAY(A1) =TEXT(MONTH(A1),"mmm") =YEAR(A1) =TEXT(MONTH(A1),"mmm")&" "&DAY(A1) Then do Data Filter AutoFilter, and then select your desired criteria using the dropdown arrows at the top of each column. To return everything to normal, just do Data Filter AutoFilter again.........it's a toggle. Vaya con Dios, Chuck, CABGx3 "Purfleet" wrote in message ... I have a large spreadsheet (like the sample below) and i need to be able to look in the date column and if date (day and month only) is present then look up the Opponents The table is as per below and the date column is unique (15 years worth of dates) so we could have 10 games all played on the (example) 24th of August but for different years. Date Opponents Result Score(us) Score(them) Please help!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| Date Math Problem | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hybrid Mode
