Search results

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

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

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

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

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

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

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.