Search results

how can generate attached pivot Tables.

Hi, if I have a list of pair (start_date, end_date) what technique to use to filter by month some calculation --see attached file-- in the attached example, the measure should return 3 as a result of the selected range (Feb) thanks.

Using Dax; I want to lookup a value by a date, but ignoring the day (just some moth and year) to fill a calculated column some thing like IF AND(month(table2[date]) = month(table1[date]), year(table2[date]=year(table1[date])) I will get the data

Hi, I need help using only formula to count last "cl" sequence before empty cell in: a,b,ab ,ac, cl, bb, cl, cl, ab , cl, cl, cl, cl, cl the count is 5 And for this sequence cells: a, b , ac , cl, cl, cl, ab, ac the count is 0

Hi, in excel 2007, How can I change the cursor appearance other than the 4 XlMousePointer? Also I want to capture the mouse event and cursor position Left, Top in Point in order to add a shape at that location? Thanks

Hi, The problem: Using excel 2007 and given 2 workbooks "wbA" and "wbB", what I want is to transform some cells value from wbA.sheet(i+const) to different cells locations in wbB.sheet(i). Is there a tool or a macro for this task that I can start to customize it?! More info: if I can write a...

Hi, I write a programe in C++ (no MFC) to do calculation and I use excel to plot the results; So for this reason I need to fill 3 big tables to 3 excel worksheets . untill now my solution is to output the data to a 3 temporary csv files, and open and move those sheets to a master workbook then...

Hi, given a 2 rows: row date: is an incremented serie of dates B2, B2+1, C2+1, ...etc row data: is an increasing sequence of values from a fixed set X={60,30,20,10} date: 7/22/2013 7/23/2013 7/24/2013 7/25/2013 7/26/2013 7/27/2013 7/28/2013 7/29/2013 data: 60 60 60 30...

How to always format cell date to output only month in english ex: 17/05/2013 -> "May" and not (Mai) in french I use Format Cells... ->Custom-> mmm Thanks in advince.

I have a workbook that start with one sheet and grow every day (I use move and copy... to create a new copy of previous sheet) my question is: in sheet(i) where i>1, I have a lot of formulat (~50) depend to sheet(i-1) so when I mad a copy of sheet(i) to generate sheet(i+1) what I whant is...