ST Alpha - "Time for ST to earn it's keep for when I have to explain what you all do for me...Excel question inside." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

Time for ST to earn it's keep for when I have to explain what you all do for me...Excel question inside.

Posted by Mel Profit (aka Mel Profit) Nov 12 '10, 08:46

I have a series of dates, about a year's worth. Is there a way in Excel to group them into various buckets easily?

For example:

> 2wks
15 Days - 30 Days
31 Days - 60 Days
61 Days - 120 Days?

Any suggestions will go a long way in me not continuing to Force Choke a Coworker and will help during my review to answer the question, "so what is this Slicker Talk"?

Responses:

thanks everyone. I'm about to go through this and see what works. I'm sure I'll have questions. Thanks in advance. -- nm - Mel Profit Nov 12, 09:15
You can also use =IF to dedicate a column to your IMs list of descriptions, and reference the cell containing the date -- nm - con_carne Nov 12, 08:59
Conditional formatting - con_carne Nov 12, 08:53 2
- Yup. Highlight the fields based on the conditions, then you can sort/filter by cell color. -- nm - JaxSean Nov 12, 08:55 1
  - why not just directly sort by the same conditions? -- nm - loosilu Nov 12, 09:00
this might help -- (link) - Beryllium Nov 12, 08:51
they store dates as seed numbers, so if you use today()-14 and stuff like that, it should work. -- nm - TFox Nov 12, 08:48

Post a message top

Time for ST to earn it's keep for when I have to explain what you all do for me...Excel question inside.

Replies are disabled on threads older than 7 days.