Hi Marsil I think you should include as many All name scenarios as possible so that I could test it all at once. See if this works. Sunny
Try this
Hi Marsil Hope this helps. Sunny
Hi Marsil Give this a try. Sunny
Hi Roxanne Are you looking for something like this? Sunny
Hi Frans Those cells you mentioned (with the "stubborn"dates) are formatted as General and not Date so they show numbers instead of dates. When ...
Hi Michael Just multiply each date with 1, for example C2*1 etc. Hope this helps Sunny
Did you refresh the Pivottable?
Hi Roxana From what I can see, the Project No in the Summary by Project sheet does not match that of the April sheet etc. There are extra traili...
Hi Tina It looks like the values with decimal place (34.5, 1999.95 etc) is the cause of your problem. Try rounding them to the nearest whole num...
Hi Tina 10-60 and 61-111 is a bucket of 51, not 50 60-10+1=51 111-61+1=51 I suggest you post a file with sample data and your expected res...
Hi Tina In a PT, the grouping bucket must be the same size. The bucket you wanted for 10-59 is 50 while 60-99 is 40, so it will not work in a PT...
Hi Varma Just remove the *24 For example =B3-A3+(B3<A3) It is better for the time to be combined with a date, then it will be easier to ca...
Hi Bill See if this helps. It should be able to handle A-Z (if you have that many ) Good luck. Sunny
Hi Rafi You will need to add helper columns to your source data. See attachment for an example. BTW I believe you mixed up the fields in your...