service

Hi, Need help my codes keeps crashing my excel. I'm looking to check is the data in cell A and Cell B is the same as Cell A and Cell B on row 2 for the entirety of the data on the sheet. e.g. if a2 row1 = a2 row2 and b2 row1 = b2 row2 Then combine D1 row 2 with d1 Row1 and E1 row 2 and E1...

Please see the table below for the cells referenced in my question...... Cell D1 is Data Validation from cells A1:A18 If cell D1 = Cell A2 then I need the value typed into cell E1 to contain the symbol in cell B2 $15 If cell D1 = Cell A7 then I need the value typed into cell E1 to contain the...

Hello, I’d like to find a solution to the following problem - preferably using pivot tables, but I can also use a work around with the raw data before running the pivot table if needed: Essentially, my data lists medical encounters with criteria such as date of service, service code, client...

I have a spreadsheet that looks like this, https://www.screencast.com/t/EhxupL7A. The spreadsheet is for developing quotes. CSC stands for community service centre and is a drop down list next to it allowing you to chose the CSC. Each CSC will be in a different location, remote, regional or...

Hello, I am currently creating a spreadsheet that will be used forclient data-entry into excel. I am fairly new to excel and was wondering ifsomeone would be able to help me with developing a macro that will automaticallyarchive rows into a separate worksheet after they have become “completed”...

Based on formulas I found in other threads, I've tried them all unsuccessfully. Here's the last one I tried. =IFS(F37>=10,F37<=19,"♪",F37>=20,F37<=29,"♫",F37>=30,F37<=39,"†",F37>=40,F37<=49,"◊",F37>=50,"∆") These are the results I need: Years of service 10-19 = ♪ Years of service 20-29 = ♫...

Good evening from Australia. I'm new to the forum have been told it's a great forum with very helpful members. I require some assistance with a formula for work. Hoping the formula is possible. I have a number of fleet vehicles that I look after and want to get a reminder when services are due...

Let's say we have a table service 1 price service 2 price service 3 price cell A1 contains service 1, service 2 And we get values of service 1 and service 2 from the table. If we add service 3 in the cell A1, we get all the values.

<colgroup><col><col span="2"></colgroup><tbody> Client Name Service Orders Kevin Service 1 Orders 1 Kevin Service 2 Orders 2 Kevin Service 3 orders 3 John Service 2 Oeders 1 </tbody> <colgroup><col><col span="2"></colgroup><tbody> Client name Service order Kevin Service 3...

I'm wanting to import a CSV file into an excel workbook, and previously had just recorded this operation and tweaked the code generated from the recorder. Now with the PowerQuery / Get Data features in excel it wants to create a query connection which seems like overkill for my needs. Is it...

The formula below calculates "Time of Service" of many employees with different start dates. The years and months calculate correctly but the number of days are all the same when they should be different. =DATEDIF([@[Seniority Date]],$F$2,"y")&" years," &DATEDIF([@[Seniority Date]],$F$2,"ym")&"...

I have a document I had the if and then statements in excel but I was messing them up yearly because it is based on years of service. I want to do it as VBA, so it will calculate automatically without having to do anything. The columns I have are YTD salary, hire date, the year (to calculate...

I just started learning Reporting Services of Ms SQL Server and found it is no match with Power BI from a beginner view. Anyone is still using Reporting Server and please advise if I should continue with MS Reporting Service or simply jump onto Power BI instead ? What is the advantage of...

Hi I've created a spreadsheet to record VAT returns for a small computer repair business in Ireland. I like to tweak it to make it run smoother and faster - it has a selection of if statements working well but the macros are proving too difficult to implement. There are two applicable VAT...

Large amount of client data, multiple clients per service date, looking to highlight charges per client, based on duplicate charge entry for that service date. If no duplication, no high lighting of the involved rows, if there are duplicate charges for that service date only then highlight...

Please consider this snippit of code: For p = 5 To 14 ctime = ws_sbase.Range("B" & p) 'shift start time dtime = dpgo 'preferred groom time (start time - 1 hr) If...

I need to calculate a customer's age based on their date of birth (for example 8/10/2017) and a past date of service (2/28/2018). Basically, how old was each customer on 2/28/2018. What formula would I use? <tbody> A B C D DOE, JANE 08/10/2017 2/28/2018 0.6 DOE, JACK 1/10/2017...

On my spreadsheet Column “R” on ‘Spot Quotes Tab’, has a dropdown with several Service types that a user can select, as shown below. Column “X” has a yes or no dropdown, If yes is selected I need the formula to count up, by service type, on another tab “New Customer Report”. So If 'AE' is...

Hi guys! I'm not new here...I have an older account but no idea what email or username I had back in 2016 (Could have been an old employer email).. sorry =( So I've done a search and couldn't really come up with what I'm looking to do specifically.. I have a report that provides me with the...

Hi, I've been given a set of data which has a column of tariff names on the left, and a list of included service codes across the top row. Inside this table, there are letters (A,O,N), indicating whether a particular service is included in the tariff. I need to create an array formula that...