Interesting problem that Microsoft has solved. It is not necessary to have Beta Channel. With a Current Channel version it works and allows you to group the dates. Thank you.
My Date column is the result of xlookup function. If Date is not found I tried to use IFFEROR and "" and NA() but I can't group Date column because these cells are not (blank). Have you any sugestion what to do?
Good day Mr Jelen, I am amazed by your excel explanation and solving various issues that I have. I am working on some numbers and I would like your assistance in solving the formula for the attached info I will add. Eg of pairing A. B. C D. E A B C D. E. A. B C D E 2 12 28 17 19. 10 28 32 36 1. 28 32 1 23 29 14 20 30 31 35. 8 16 24 26 1 Solving areas are as follows: -2 -odds number -2-even numbers -3-odd -3 even -All even -All odd And then grouping them in those segments
These combination will somewhat give you a better idea of what I am trying to get across. I have combination of numbers 1-36 , however I would want to sort them in this format Eg. A. 1-3-4-6-8 (2 odd,3 even) B. 2-4-5-7-9 (2 even,3 odd) C. 2-4-6-8-9 (4 even,1odd) D. 2-4-6-8-10 (5 even) E. 1-3-5-7-9 (5odd) F. 1-3-5-7-8 (4odd,1 even) Can use help me with a formulas that could be used to achieve this
How do the numbers in the first comment relate to the results in the second comment? In the first comment, the numbers in the “A” column are 2, 14, 10, 8, 28. But 28 never appears in the reply.
@@MrXL thanks for responding, the second comment is the one I really need the help with . When I notice the first comment was not really clear. So the second comment
I want to group dates by month, quarter and year. I want to display months with no data but when I select "Display Blanks" every quarter displays 12 months, ie. Jan - Dec.
Yes - I can see what a pain this would be. One Solution is to create a Custom Set to hide rows. I have two recent videos about this: ruclips.net/video/WQKxQTN970Y/видео.html (See what I do around 2:00 to 2:20 in that video.)
Interesting problem that Microsoft has solved. It is not necessary to have Beta Channel. With a Current Channel version it works and allows you to group the dates. Thank you.
Well, they seem to have half-solved it since it lets you group dates where there are blank cells, but not if there are cells containing text 🙄
That is crazy awesome!!!!! I had no idea. MS fixed it!?!?!?
Great Mr Excel thank you for this awesome video 📹 👏 👍
Thanks, Mr Excel!!!!!!
For the manual columns of year and month, I like to do an if with isdate. E.g. =if(isdate(A2),year(A2),"N/A")
Excellent improvement!
Thanks Mr Excel. :)
My Date column is the result of xlookup function. If Date is not found I tried to use IFFEROR and "" and NA() but I can't group Date column because these cells are not (blank). Have you any sugestion what to do?
Maybe you could also have added a part on PowerQuery / FillDown if the blanks are there to indicate "same date as above".
Great!!
Good day Mr Jelen,
I am amazed by your excel explanation and solving various issues that I have. I am working on some numbers and I would like your assistance in solving the formula for the attached info I will add.
Eg of pairing
A. B. C D. E A B C D. E. A. B C D E
2 12 28 17 19. 10 28 32 36 1. 28 32 1 23 29
14 20 30 31 35. 8 16 24 26 1
Solving areas are as follows:
-2 -odds number
-2-even numbers
-3-odd
-3 even
-All even
-All odd
And then grouping them in those segments
These combination will somewhat give you a better idea of what I am trying to get across. I have combination of numbers 1-36 , however I would want to sort them in this format
Eg.
A. 1-3-4-6-8 (2 odd,3 even)
B. 2-4-5-7-9 (2 even,3 odd)
C. 2-4-6-8-9 (4 even,1odd)
D. 2-4-6-8-10 (5 even)
E. 1-3-5-7-9 (5odd)
F. 1-3-5-7-8 (4odd,1 even)
Can use help me with a formulas that could be used to achieve this
How do the numbers in the first comment relate to the results in the second comment? In the first comment, the numbers in the “A” column are 2, 14, 10, 8, 28. But 28 never appears in the reply.
@@MrXL thanks for responding, the second comment is the one I really need the help with . When I notice the first comment was not really clear. So the second comment
I want to group dates by month, quarter and year. I want to display months with no data but when I select "Display Blanks" every quarter displays 12 months, ie. Jan - Dec.
Yes - I can see what a pain this would be.
One Solution is to create a Custom Set to hide rows.
I have two recent videos about this: ruclips.net/video/WQKxQTN970Y/видео.html (See what I do around 2:00 to 2:20 in that video.)
I Can't grouping field when pivot table with data model, why ? can you solved this problem..