tool

  1. C

    Formula/Build Excel Tool to Forecast SL

    Hello Excel Gurus! Hoping someone could help, or provide some guidance on this ask. I've searched online as well as on this forum, but haven't quite found an answer to what I'm looking for. What I'm trying to do: - use historical data to better forecast Service Level for the upcoming week...
  2. M

    Tool with users using UK and Dutch date format settings

    Dear all, I have a question about the date format in a tool I made. Some users use the Dutch format: dd-mm-jjjj uu:mm, and others the UK format dd/mm/yyyy hh:mm. For the output of this tool I transform the data to a text format =text(E6;dd/mm/jjjj uu:mm) because the upload doesn't pick up...
  3. M

    Copy pasting data from excel into company software tool

    Hi guys I'm from India working in a financial firm. In our process the most tedious laborious work entails copy pasting customers a/c nos from excel into our software. then again copy the data from excel and paste it into the software.We at times receive hundred's of these. Is there some...
  4. S

    Slicer Tool

    Hello All, I have used the slicer tool a few times with no issues but I can't figure this one out. I have a table with information and my slicer tools are on the right side of it. The filters in my slicers contain 9-15 items and I have the majority of them showing. The problem is that when I...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top