Hello,
I wonder if you can help me, I need to Group full rows based on "Open date" column and create 3 groups:
less than 5 days
between 5 and 14 days
older than 14 days
Please check the attached example
Classification sample.xlsx
Hello,
I wonder if you can help me, I need to Group full rows based on "Open date" column and create 3 groups:
less than 5 days
between 5 and 14 days
older than 14 days
Please check the attached example
Classification sample.xlsx
Hi,
Have you considered adding a helper column to your data which identifies which group a record belongs to and then use a Pivot Table to summarise
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thank you Richard,
Honestly I don't know how to create a helper column, could you please provide some guidance? once I have that value how can it be used to obtain the reults shown in the attached file?
In the attached file there is a sheet for Raw data and another with the deired results, currently, I populate raw data, then manually select the rows within 5 days and paste them in the <5 days section in the "classified" Sheet.
Thanks again for your help.
Hi,
You'll need to tell us which is the relevant base date for comparing with the Open date. Is it today's date or some other date?
Uppss sorry , Yes it is TODAY
Maybe a solution like this will help you. All of your date and times are TEXT and I converted the ones needed in a helper column to real dates. I ignored the time values. I then subtracted those dates from TODAY and finally grouped the day differences into groups with an IF formula.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Awesome Ron!!
That’s and excellent solution!, thank you very much for your help! I already classified today's report using the helper column and everything looks great after some minor adjustments!!
Thank you for the feedback and the rep.
I'm glad that it is working with your reports.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks