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

    Convert Text to Date?

    I have a column of dates (column A) stored as text in the format Jun 2 2020 12:00AM Jun 20 2020 12:00AM which I'm trying to convert to dates in the format (dd/mm/yyyy), ultimately so that I can do calculations Any suggestions would be appreciated.
  2. A

    How to calculate Productivity and Efficiency

    Productivity - Excel formula is required
  3. A

    How to calculate Productivity and Efficiency

    Can anybody any help me with the formula for this
  4. A

    Count unique distinct values that meet multiple date criteria

    How to count unique distinct values that meet multiple date criteria
  5. A

    Excel formula count unique values with multiple criteria

    Can get a formula to count unique text value with date criteria
  6. A

    Forecast for the month

    Please help me to forecast formula for the year
  7. A

    VBA excel cell value into power point table

    Excel cell values will be automatically using VBA to update in a PowerPoint table cell value Note: I don't want to use PowerPoint with Insert > Object > Create a file from > Link Is it possible .
  8. A

    COMBINATION STACKED CHARTS IN EXCEL

    I need to create one stacked for a column in terms of NGB+ RGB, How can you do it
  9. A

    VBA - GET HTML elements inside frame using Selenium Webdriver

    I'm trying to access the script first under the frame'onclick="javascript:eek:penPage(this)" and then elements click that are present under the text 'Vendor Master' but received error selenium WebDriver: unable to locate element <FRAME id=contents src="" name=contents scrolling=no> <HTML> <BODY...
  10. A

    Clicking a button via IE automation VBA

    Hey, I'm trying to click a submit/go button on a webpage and I can't seem to get it to work. Everything I've worked with so far seems to have an ID that works well with getElementById call, but with this button i can't seem to find anything that will reference to it and click. Here's the...
  11. A

    Calculate number of days between two dates - not show zero

    I've tried this using the simpler A3-A2 and while the calculation works fine, but it doesn't factor in weekend days and showing 0 for the same date instead of 1. Is there a simple formula to calculate the number of working days between two given dates?
  12. A

    Partial cell(or string) match in excel macro

    not working
  13. A

    Partial cell(or string) match in excel macro

    I am new to VBA and I would like to do a partial string (or cell) match between two sheets. An example of A B Result '200001840036,'20812646883,'86414226 '20000812646883,' Partially Matched with B ,'0650050010888 0650050010888 Partially Matched '50200009667407...
  14. A

    Extract Unique Values From Row

    Hey, I Want To Extract One Value From The Row and Result should be like below
  15. A

    Text Data to Excel column data

    I have data in text format and need to convert to Excel column data Can you please help me
  16. A

    Error Showing Outlook mail with VBA when changed to Windows 10

    For a long time I have used a macro to send an Excel worksheet via mail (downloading and sending ) but when I updated to Windows 10 everything failed and I cannot understand why. This is the code: Set olApp = New Outlook.Application (error showing here) Set OutMail = OutApp.CreateItem(0)...
  17. A

    Heat bar chart

    Am looking for a heat bar chart, can anyone help me with this chart similar like Thanks
  18. A

    Using Excel VBA to Add events into Google Calendar

    Hi What I would like is, when a user selects a date and a time, it would then automatically update Google Calendar. Is this possible at all? All I'm after doing is, in Excel , click a command button, and then VBA does the following: Connect to my Google account Add an event / or multiple...
  19. A

    Sum only unique values

    I have number values and what I'm looking for is a formula that will add all the values together but will only add total values once one time. Example O Code Imports Total 1703024 10 44 1703024 4 1703024 20 1703021 20 110 1703024 10...
  20. A

    Excel Shape Mouseover event

    only change the color is it possible
  21. A

    Excel Shape Mouseover event

    When i move my mouse over the shape and it changes the color, is any method in Macro? is there without using the label (ActiveX)
  22. A

    SUMIFS - Multiple Array

    But if I create 3array, it won't work. Is there any other method?
  23. A

    Sum-product multiple conditions

    Thanks !!!
  24. A

    SUMIFS - Multiple Array

    i tried to include SUMIFS with single array and it works fine: =SUM(SUMIFS(Sheet3!H:H,Sheet3!G:G,"X",Sheet3!E:E,"SA",Sheet3!D:D,{"A","B","C"})) When I try to include a second array as below it gives me only the first/last item from {"X","Y","Z"}...
  25. A

    Sum-product multiple conditions

    I run into several postings on the internet with code like this Conditions for search are neatly put into {}. I have such conditions to search for, so I'm looking for a way to make the formula easier to read. If I try it, i get N/A. Is there a trick I'm missing? Thank you in advance
Back
Top