Search results

Really Appreciate your effort Atul, But my Requirements are as below 1. Color for a Res# and the same Row needs to be highlighted with same color untill there is another Res# 2. Once i have the new res# on that row i want the color assigned to him/her has to be highlighted untill i see next...

Hi Atul, Please find the attached Original file requirements are as below. This is Shift roaster where i would like to see the in which shift he is continue Color coding helps me for same. i would need the same color for same person anywhere in the sheet. .

@ Atul i retried several time with actual data, but was not successful yet,, hence requesting you help here to do the same conditional formatting for the attached file.. please which is real data...

Thanks a lot Atul and Soma !:) @ Atul could you please let me know how does this work meaning can you please explain me on the same...

attached in my previous post

attached the sample file now

Sorry my apologies, But you never mentioned that you are using office 2010,

I need the Continued color coding using Conditional formating Example which is Shown above if I repeat the value 1 any where in the cell I need the Organe color to be highlighted till the end if there is no other value attached is the sample file

you can also use the flash fill option, if you are using Msoffice 2013

Hi All, i am posting complicated roaster which has the similar Thread name for my previous question in here. i am uploading a file where i have explained my requirements. Please help me to get this .. Thanks in Advance..

Thanks you Ninja Sir....

Hello All, Needing your help here i have attached a file for reference... My Requirement are as below. W is Working , WO is Weely off 3 shift which is A1 to A10 are shift members Default A2 and A1 are shift leads who will get there Weekly off on every Saturday and Sunday A4 will be...

Hi All, i have team of 20 and we work on emails and tickets, and need to have dash board where i can show them their performance. Can some one with the best Dash Board where i just need to updload data and see individual performance PLease help....

Thanks a lot Bobhc... will do as said :)

Can some please help with the above....

Great Help Bobhc, But this problem again which i missed to mention below is the another problem Example :] Total Ticket where 4 but in Sub BGL Total it says 5 The same is also been show in above uploaded sample file. Can you please help with this BGL Sub :BGL Total...

Hi All, How do i had multiple values or multiple Pivot Table to "Show Pivot Report Pages". i have prepared a Pivot chart for one customer but i need this to be shown for all other 20 customer which same and chart and pivot which i can change the filter accordingly...

Hi Bobhc .. Please find the below link where i have uploaded the and mention what is need the yellow colored thanks for you https://www.box.com/s/9gj96krzi4k9bjzo8bcv

Great help Bobhc, i have calculated as said, i got the values as well, but the problem is i dont get same calculation for Grand total for the calculated Item :the error is : #DIV/0!

Hi All, Can someone me in Calculatio item in Pivot Table in Pivot Here is my Pivot look like the formula i need is Pending/Grand Total Pending Resolved Grand Total AOL 4 4 ARA 5 5 CLX CRL DHL 2 1 3 GEN 1 1 Total 2 11 13

Hi All, Can some one help me on Start and Stop time Watch in excel Start and Stop time in Excel for each individual Member in team which will help me to track the time they have spent on each task.. Thanks in Advance

Hi SirJB7, Thanks for you advice. will take care hence forth.

Can some one help in the calculation of OLA Compliance i have uploaded a sample file in the below link.,, https://dl.dropbox.com/u/94380636/New%20Microsoft%20Excel%20Worksheet.xlsx Thanks in advance

i meant Blank column inserted in Pivot Table

Hi All, How do i edit the blank Column in Pivot tables in VBA..