Recent content by KapardhiSarma

Thanks Vinod, this helps, good idea infact. Thanks a lot.

Vivek, You got the point right, which i missed to realize that why this error message. The reason for populating blanks instead of 0s is, i dont want to see any value in the cell if it is not found. Please help me overcome this situation. Thanks, Kapil

I need help with the formula please, attached the file. In "# Planned" column of Summary tab, from cell D6 the cell should add up values from preceding "# Backlog" (Cell F5) column in addition to the available formula in "# Planned". Thanks in advance, Kapil

Nebu, I need one more help please, attached the file again. In "# Planned" column, the cell should add up values from preceeding "# Backlog" in addition to the available formula in "# Planned". Thanks in advance, Kapil

Thank you Nebu, it works.

I am looking for a formula which helps me with retrieving data comparing the row header and column header. Attached the file for reference. My answer should be as follows. I have pivots in "Team Performance - Pivots" tab, and in "Summary" tab, i have different resources in columns and week no.s...

Thank you Deb and Somendra...This helped with my requirement.

Hi Team, I have a requirement that in a row of 20 cells if the 1st cell is 0 it should show as 0, and if the number is 1 it should start counting till it find 0 by end of all 20 cells in a row. Attaching an example for your reference. Explained in column 'W' of the attachment about the end...

Fantastic...its awesome!!! :D

The issue is its not working, excel and VBA are not responding once started executing. Please see my further explanation below. Column A Column B Column C Column D Column E XXX name1 123456789 XXX name2 234567783 3456677889 YYY name3 213123123 YYY name4 123451231 123412312 1231223523 When the...

I never programed an excel macro, i'm facing a problem i hope excel macro can solve it, because i have huge amounts of data that need filtering its simple i will explain in an example Original Table: Column A Column B Column C Column D name1 123456789 name2...

Thanks a lot @Jake Collins and @ThrottleWorks. This really is working. Thanks a ton for your time and suggestions.

@ThrottleWorks, Thanks a lot for the reply.

Thank you Jake for the response and help here. I have one more doubt. Would this handle negative values as well? There are some negative values say -12d and 0d. Would the formula handle this? Thanks, Kapil

Hi Team, I have an issue with the formula i am using. I have a duration of days for two months in two different columns like 22d and 44d. I used a formula to find out if there is a change in the duration or not. My formula below. =IF($A1>$B1,"Up","Down"). But there are few cases where there is...