• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. imla

    get complement rows and distinct union

    how can generate attached pivot Tables.
  2. imla

    filter by month in time range entry

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

    Dax calculated column and lookup

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

    Dax calculated column and lookup

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

    Count last sequence of duplicate values of a given value

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

    Count last sequence of duplicate values of a given value

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

    Count last sequence of duplicate values of a given value

    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!
  8. imla

    Count last sequence of duplicate values of a given value

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

    mouse Cursor appearance and position

    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!!
  10. imla

    mouse Cursor appearance and position

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

    transform cells value between 2 workbooks with multi-sheets

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

    C++ and excel automation

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

    count if between date range and cell has red font

    I see that the data is organized in complex way. and you need ony one case of red per period (day/night) So I think only one column is enough! Why not juste create a simple "table". it is true that you will enter more data but the filers by Name or month or years or Period will be a piece...
  14. imla

    Leader Board - Update

    I hope that you can report the leader board of accepted answer in the new forum. or at least "I like" counter. So blah blah ... like this one will be filtered PS: did I got a new post now? from nothing!! Regards
  15. imla

    Adding a Sheet to a bunch of selected Workbooks [SOLVED]

    wbk is a variable that hold one workbook at a time and loop in all your destination workbook(s); those destination files can be browsed for example. you can check this file for a compleate code. http://www.mediafire.com/download/c57it3z5xwhdqs7/AddSheets.xlsm regards
  16. imla

    Modify my code to continue even if the file is not found

    Try this it may do your work! Option Explicit Sub Filemover() Dim sPath As String, dPath As String, sFN As String Dim r As Range Set r = Range("A2") Do Until IsEmpty(r) sPath = r.Offset(, 1).Value2 & "" dPath = r.Offset(, 2).Value2 & "" sFN = Dir(sPath & "*" &...
  17. imla

    add product snaps

    ok, in this case I change (*.jpeg) to (*.jpg) Please reload the file and test it again! http://www.mediafire.com/download/qcinnzzghh2jz9a/picture.xlsm regards
  18. imla

    add product snaps

    Please check that you have D:photo1001.jpeg and not D:photo1001.jpg This is what I can figure as error! or to be sure rename one of the file to aaa.jpeg and enter aaa in A2 for example.
  19. imla

    Footer

    +1 @James Perry, Cool... very good solution, ...(but it did not add a footer to an old Workbook). Thanks for the tips.
  20. imla

    add product snaps

    @poojavasti, Please download this file and remember to enable macro before you can try to test it. Let me know if it did not work! (I use excel 2007) http://www.mediafire.com/download/qcinnzzghh2jz9a/picture.xlsm
  21. imla

    A new forum....?

    +1 to Faseeh for his suggestion.
  22. imla

    add product snaps

    Please try this code I dont know how to work in inch!!... Private Sub Worksheet_Change(ByVal Target As Range) Dim isect As Range Set isect = Application.Intersect(Range("A:A"), Target.Cells(1, 1)) If isect Is Nothing Then Exit Sub GetPicture isect End Sub Sub GetPicture(r As Range) Dim...
Back
Top