Recent content by imla

its perfect

thanks, it worked

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.

Good idea, better than what I'm currently using! I will apply it. Thank you very much.

I use excel 2016

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

works and also gives other info in negative value (I may use it in conditional formating!) thanks

Thank you all very much, solutions is exactly what I want (BTW I never used the Frequency function) you saved my day this formula helped me a lot.

this is a sample file ...the purpose of this formula is to find a sequence that the count exceed a threshold value, and start filling from the empty cell to reset the count (it does not have to be 0) thank you for the help, and I'm here for any other clarification of the problem!

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

I already red that and I still struggle to convert the point from screen coordinate to Point inside excel sheet. and I use Workbook_SheetSelectionChange to capture the mouse click event!!

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