Search results

Hi, Maybe this is more a math question than an excel one so sorry in advance if this is an offtopic but id appreciate if someone could help me on this. I have several tests delivered to a group of users and id like to have a column to have some kind of "success rate" related to the test itself...

Hi, How could I do something like this? (between ----> and <----): =SUMPRODUCT((Table[Column1]=A9)*(Table[Column2]=---->IF($B$2<>"ALL",$B$2,"<>ALL")<----)*Table[[costs january]:[costs december]]) I mean, to set a conditional returning a dynamic value for that column. If value in B2 is "ALL"...

Hi, Im trying to sum values from a row until column named with the limit date (month in current year) manually entered in a cell. Maybe attached file is clearer than me... sorry Thank you in advance,

Hi, Is there a way to access a table column range from a given cell value? Lets say that table1 is named "People" and one column header is "ene-15". I would be able to access that column range with "=People[ene-15]". How could I set a formula to access dynamically to that column based on other...

Hi, Im trying to locate last column with value from non adjacent columns and set that one's column name in a cell. Please check attachment because this is a bit tricky. Column in red for line 1 should say "jan-15" and it should be empty for line 2. It should be the last month in which we have...

Hi, Im trying to sum columns from a table based on values in different cells. Something like =SUM(Table1["Invoicing "&B16&"-"&C15]) Is this possible? (excel attached) Thank you in advance

Hi, I have one table with different columns: Col1, Col2, Col3 -> Values Selector -> Contains duplicated values which will be used for dropdown in Test sheet Auto1, Auto2, Auto3 -> Calculated cells to be shown in pivot table at Calculations Sheet When I select a value from the dropdown at test...

Hi all, Just wondering if there would be an optimized way to calculate days between two dates and just taking those in a given month. For instance, id need to get from 05/01/2014 to 07/15/2014 the numbers of days in june 2014 (these would be 30). Also, from 06/15/2014 to 12/31/2014 would be...

Hi, Im starting with PowerPivot and just moving previous reports to practice. I have a date column which includes both dates (dd/mm/yyyy hh:mm:ss format or just "unlimited" text). I created a calculated field with =IFERROR(DATE(MID([end date], 7,4),MID([end date], 4,2),LEFT([end date]...

Hi, Im trying to get data from a different sheet table by matching IDs but im in troubles with values containing "~" character. For those the formula returns "#N/A" =INDEX(Keywords[Description];MATCH([@Keyword];Keywords[Keyword];0)) How would you manage to get this working? (Id like to avoid...

Hi I have a Pivot table like this (named regionSales): Region1 |------Advertiser1: Revenue1 |------Advertiser2: Revenue2 |... |------Advertiser10: Revenue10 Region2 |------Advertiser1: Revenue1 |------Advertiser2: Revenue2 |... |------Advertiser10: Revenue10 Region3 |------Advertiser1...

Hi there, Its nice to read these forums and find answers to almost everything :). Tried to find something in which my dashboard could be based on with no success so here It is what Im thinking about and ill appreciate if someone could point me in the right direction. I have 2 sheets: sheet...

Hi, I'm just modifying a pivot table field from a dropdown list and all of my pivot tables work except one (Pivot_Devices) and they have just the same code: With Worksheets("Dashboard").Shapes("months_unique").ControlFormat Worksheets("Dashboard").Range("C2") = .List(.Value)...

Hi, I need to sum several fields in a column based on conditions from others. This is it: ColA / Col B / Col C --------------------- Jan / castle / 10 Feb / house / 6 Mar / flat / 7 ... I'd need to get all sums for items matching (ColA = Jan) AND ((Col B = castle) OR (ColB =...

Hi, I've just known about this site and It is great! Thank you for your work. How could I get from other sheet's pivot table values with a certain text in a field? I mean, i have a pivot table showing 2 columns: Concept | Amount I want to get to my dashboard SUM of amount for concepts...