reg

Hi, I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours. Example: <tbody> Company Code Payroll Name File Number Payroll Pay Date Timecard Hours PayCode AAA John Smith 0012345 07/26/2018 8.00 Reg AAA John Smith 0012345 07/27/2018...

I have a table, which on worksheet one, I get new data every quarter and based on that I create a pivot, and add extra formulas to gather data from the pivot. Raw data looks like this: https://imgur.com/a/sCkMsMW I want to make it simpler, since pivots don`t auto update, and the data I have...

I have a payroll workbook that has 26 payroll worksheets and an OT Totals worksheet at the end. I'm trying to figure out a formula in the OT Totals worksheet that will find an employee's last name in each worksheet and total their Reg OT. Last year I just made a formula by going to each...

Have I entered this incorrectly? =IF(L9<=L10,IF(L10>L11,TEXT(K10,"DDDD"&" Total Hours"),""),"") <colgroup><col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;"> <col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;" span="2"> <col...

Not sure what formula to use. Currently I am using index match but whilst it is returning a result it is not quite returning what I want. I have a table which contains the following info: <tbody> Staff Reg 1 Reg 2 Reg 3 Reg 4 AAB 7.1/Rg SAH 7LA/Rg 7LB/RG 7.1/Rg MAH 9.7/Rg 9BW/RG...

Hi all, I need help with a formula. I have reg date in column A, I would like to find out the next service date of the vehicle. I need a formula that will add 18 months to the reg date then keep adding 18 months untill a certain date. But only if its less than my end date. Thins is driving me...

Hello, I have worked with excel a long time but I have no coding ability to utilize VBA. I have an excel document that is updated daily and are need of alerts (is possible) that would help us stay on top of certain data. We enter data across the rows for every item entry we process. In column...

Hi Excel Gurus, Once again I am very much thankful to this community due to which I learned a lot. I am stuck in the current routine although it is not giving any error and executing but its not hiding the rows as mentioned which are blank has no data. To be more precise I have selected the...

Hello, I have a spreadsheet that contains several columns similar to the below: <tbody> A B C D E F G 1 Report Date: 6/22/18 2 First Name Last Name Category Sub Category Reg Code Dist Code Area Code 3 Jon Doe Fruit Apple 11 000 00 4 Jane Doe Fruit Apple 11 001 00 5 Jack Doe...

Hello, Need help with a formula that will find the first two blank cells in D column and then return back a start time and end. I been wracking my brain for a few weeks but still doesn't turn out right. My time system for night employees will add their lunch break return to the next day if they...

I am trying to add some more data and functionality to an existing database and having trouble figuring out how to pass the value that is being passed to main form also to the sub form. The reg# on main form is unbound. The reason the Reg# is passed as a variable I think is because that variable...

I am not sure if this is an easy task and I am just missing something but here is what I need. I need a formula that will assign a weight (with all weights adding up to 1 of course) to data in excel based off whether that data has a rating of "Low," "Mod" or "High." Naturally, low would have the...

Thanks in advance to everyone. I have the following code that allows me to select a list of names and post to a new range. It works well but my first pass was to just recreate code X times and change the selection criteria called REG to XXX and also change the variable to paste the selection...

<tbody> Reg No Class PG Nur KG 20 PG required answer is 3 instead of 4 Same Same 25 PG 27 Nur 29 KG 30 PG PG Nur 35 Nur </tbody>

Hi, Not sure what / how to do this. I need to lookup vehicle registration number + data as per below (below is what I have in one excel tab. Date Van Reg Driver Name 23/10/2017 ABC 123 ? The other tab contains...

I am a VERY beginner on macro's and can read minimal coding of a macro. I found a macro on the internet that is supposed to clear the contents of all rows that contain specific data in a specific column. Of course, I had to modify the coding to match what my data. My data starts on row 8...