collect

  1. B

    Looking for good Power Query Websites and Resources

    Hi All, Can you please share some good websites which you've come across to learn Power Query? I'm finding a lot of excel websites, but they hardly cover Power Query. I currently own the following books: 1: M for Data Monkey and 2: Collect, Combine, and Collect, Combine, and Transform Data...
  2. JTL9161

    FIND Option

    I have several strings of data each 200-500 characters. I am trying to collect the 9 places of data within the string that come after a constant "EX". For example: 12345DEFCT444556EX987654321XX2DS84EGSS5.... There will be only 1 EX in the line each line so in this example I am trying to...
  3. J

    Collect data from a row in multiple sheets

    I have monthly workbooks (October, November, etc.) with data, and in each month -there's cycle of work of seven days (call it sheets:1,2,3,4,5,6,7) -after each cycle it stops for two days (sheets:8 and 9) -and it starts again (sheets:10,11,12...16) I want to resume the data from some columns...
  4. J

    Collect data from multiple worksheets in one worksheet

    I have monthly workbooks (October, November, etc.) with data, and in each month -there's cycle of work of seven days (call it sheets:1,2,3,4,5,6,7) -after each cycle it stops for two days (sheets:8 and 9) -and it starts again (sheets:10,11,12...16) I want to resume the data from some columns...
  5. F

    How to Collect Data after Cycling?

    In reference to the linked spreadsheet below: I want to collect time and H data starting when cycle=6000, displacement <0.001. The problem is that there are at least 2 points where these conditions are met: Row 174 and Row 258 of the linked spreadsheet I want to start collecting at Row 258...
  6. L

    Divide Value of a Cell not to exceed 999 and Copy other Row info down

    I have this sample data: <tbody> AcctNo Name ReferDate DocNo PatientID units num Code Service Claim ID 361004 TEST1 4/30/2013 99 1 2099 2.1 COLLECT 12/13/2016 1234568 361005 TEST2 10/31/2014 99 2 1636 1.6 COLLECT 12/13/2016 1234569 361006 TEST3 10/11/2013...
  7. T

    Math Help!

    Hi there, Please take a look at my sample spreadsheet I've imported to google. I do use Excel 2016, I've just imported for you guys to view. https://docs.google.com/spreadsheets/d/1C2frEj0Lmzghy5nyDJxOgD57hjeORUEf5V183jCpMKA/edit?usp=sharing I need a formula/code that calculates the following...
  8. M

    Excel bar code ticket system

    Hi i hope you can help i am trying to create a database that uses bar code's to scan a ticket out for a goodie bag then scans it back in when they collect the bag. Its so i can see who has still yet to collect there bags. I have all-ready created the bar codes for each individual person i just...
  9. N

    Difficult Timer question

    I'm stuck on a timer issue. I need a timer that is automatically activated upon opening excel (not clicking a button to activate it) I have multiple sheets so far and I need a timer to automatically add the value from sheet1 C14 to cell E14 in the same sheet every 3 seconds. C14 starts at 0 but...
  10. S

    Copying data of a particular customer from 12 different sheets onto 1 sheet

    I have a worksheet with name 'Pump Loan'. It has 13 worksheets. 1 for each month of the year(12 Sheets) and 1 with the name 'OVERALL'. I just add a new customer alphabetically in 'OVERALL' sheet and if that customer has a transaction in a particular month, than his name and transaction amount...

Some videos you may like

This Week's Hot Topics

Top