service

I have a list of part types in column E1:E57. In cell F59, I want to add up all the ones that include the word "Cover", but I don't want it to include any that contain the word "service". Like this: Sheet1 <colgroup><col style="font-weight:bold; width:30px; "><col...

Hi all, I'm trying to find a formula that will allow me to search multiple tables with multiple criteria e.g: I have a main sheet with multiple criteria: shop name, engine type, type of service. I then need to use these criteria to search within a number of different tables set out like...

Hello Forum, I am in need of getting the totals by month for service types. I have a tab named Spot Quotes, in column R is the Service type, Col 'N' has the date and time completed like this '2/1/2018 13:00' My total tab is named Total Quotes. Starting in cell H4 would be the total for the...

I have the attached data. I am trying to sort column F from largest to smallest but after the Month, LOC and then Disch Service. Please help.

I have a scoring matrix for a number of services. Each service has its own RAG status. Example below. <tbody> Minutes <30 30-59 60-89 90-119 120-149 150-179 1 2 3 4 5 6 Serv1 3 3 6 9 12 15 18 Serv2 3 3 6 9 12 15 18 Serv3 2 2 4 6 8 10 12 Serv4 1 1 2 3 4 5 6 </tbody> I...

Hello, I have searched the threads and cannot find the solution that fits my situation. I have a worksheet with a data validation drop down menu in E3. This list is comprised of four types of services: Service 1, Service 2, Service 3, Service 4. For each service, there is a unique set of...

I'm struggling with how to build out something in an application I'm building. There are 5 services that a Client can sign up for. Payments for each service are tracked on separate sheets (each named after the respective service). Each service can have different due dates, payment amounts and...

Hello and thank you in advance. Ok here is my question. I'm using the yearfrac function to determine Years of service. YearFrac works for me because if shows the years with the months/days shown in decimal. Each employee earns a week of vacation as follows: 2 years of service - 1 week 5...

<tbody> How to build a macro </tbody> How to build a macro that senses when a multi-column csv file has finished downloading and then proceed to process that information. The web service is called manually by the User; it does not support a Data Connection but it does download to the User's...

Hey All, I'm looking for some guidance on how to approach creating worksheets based on a matrix in a table in my workbook. If Background: I'm building a reporting tool that runs a few stored procs (Stored on sql server) I built and then based on various user inputs it creates a fancy and...

Hi Guys, I have been using this code successfully to save my file to our company's intranet Workbooks("Value Added Service Pivot.xlsx").SaveAs Filename:="http://sharedapp/marketing/Marketing Department Dashboard/Daily Activity/Value Added Service Pivot.xlsx" this code has all of sudden has...

Hi Guys, I have been using this code successfully to save my file to our company's intranet Workbooks("Value Added Service Pivot.xlsx").SaveAs Filename:="http://sharedapp/marketing/Marketing Department Dashboard/Daily Activity/Value Added Service Pivot.xlsx" this code has all of sudden has...

I have a timesheet application where I want the users to select from a table of options but have only one column returned in the spreadsheet. I have a series of 'Service Line Codes' that are numerical (0-50) and each one has a description "example RT Inspection". I have a column in my...

Hi everyone. I hit a brick wall and not sure what to do. I'm using a Vlook up to track weekly trends of issue drivers, with a count of issues and an average of customer scores. So right now, my totals work just fine. It's the Score I can't seem to do. I attached the summary of what I'm...

Hello, I have following system for updating contracts and their prices: <tbody> Portfolio Service Start End Monthly cost (Period 1: 1.4.2016-30.3.2017) Monthly cost (Period 1: 1.4.2017-30.3.2018) Portfolio 1 Service 1 1.5.2016 100 € 200 € Portfolio 3 Service 2 1.7.2016 1.8.2017 300 € 200...

Hi team, I feel like I'm not that far off from what i want to achieve, but what I'm essentially trying to do is have multiple criteria reference a table where there are 2 criteria are dynamic ref cells. With Sheet2, i managed to get it to work somewhat, but it the result doesn't show the first...

I'm building an application for a friend and I'm struggling with a concept. There are currently 4 worksheets ('Client Info','Client Measurements','Financial Tracker','Variables'). The Client Info sheet holds core info such as bio and service details (Start Date, Amount, Payment Frequency - all...

Any help on this would be MUCH appreciated! What I am trying to accomplish is basically, determining the time duration between a start and end time value relevant to a given Record id and Source entry. The formula would need to identify matching Record ID's, then determine if the Record ID...

Hi All, Greetings to all :) I need your help on countif and frequency formula using. 3 columns in Excel: These are all the input data Column 1: Client code Column 2: Service Code Column 3: Service value My request is from the above data is: It is an separate sheet or separate column...