Search results

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...

This is exactly what i wanted Ravi. Thanks you very much for your help. Please can you tell me why you used + after = in the formula? Thanks a lot again.

Hi Ravi, Please find the attachment. Thanks, Kapardhi

Hi team, I was trying to write a formula to get data. My requirement is as below. I want to get the sales, $ and % of a project by month in the column next to project which is available on a different tab in the excel. Say i have 5 project numbers and data of 12 months in another tab, now...

Hi All, Please see my requirement below. I have 4 Phone numbers - Phone, Phone2, Office and Mobile. I need a formula to get the Phone number if all the values are different, if phone and phone 2 are equal then phone number, and if these 2 are blank then it should give me office number and if...

Thanks a lot for your suggestions and quick responses Vallabha. I am not much in to VBA but please give me the code..ill try to implement it please. I have small issue here. The formula you have suggested is working fine, but please consider the below. I have a name JackCBack in cell A1. The...

Hi Vallabha, Thanks for the reply. This helped. Here's a new requirement. Say i have my data KapardhiPVK in cell B1, i want all the uppercase letters in C1, like KPVK. Please help. Thanks.

Hi, I have a requirement to convert the first word of the letter to upper case, and every first word after a '.' should be an upper case. See my requirement below. kapardhi.p.v.k should be changed to KapardhiPVK Please help.