collect

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

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

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

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

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

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

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

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

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

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