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