services

hi, So I have this excel file made by developer. It's quite complex and has a scraping procedure. I have two copies of it, one at home and one at work - I was wondering if you could recommend me any online services to deploy this file and use it as Web App instead? I know it's possible but...

Hi, I'm trying to do a countifs, that will count the number of cells with the criteria 'Adults' in column A, that have one of the following criteria in column B; 'Active assignment', 'secondment', 'acting up'. I'm writing the following but recieving a circular error: =COUNTIFS(Fire!$F:$F,"826...

Hi Can any one help me on below code:- first check that how many cells or times one/same id contains and then match and color code (if matches then green else yellow) company name with the similar times.Below is the code given in this forum but it not working properly- [CODE] [Sub...

I need to get unique value of Suppliers based on the different columns Input: <tbody> Functions Suppliers Sites Due Date Operations Apple #N/A #N/A Operations Orange #N/A 4/13/2020 End User Services Watermelon #N/A #N/A Operations Pineapple #N/A #N/A Operations Kiwi Mulgrave...

I have a list of symbols in Tab "TSM_Picks" Col G starting in row 3. In a second Tab "Services" I have rows of information, each row associated with a symbol in Col E. I need a macro that reads each symbol in "TSM_Picks", identifies all the rows associated with the same symbol in "Services"...

Hi all, I would like to use an an ActiveX ComboBox to drive the formatting of the Excel workbook. Particulars of relevance: - ComboBox name: ComboBox1 - ComboBox options: Total, Products, Services What I have thus far: However selecting the drop-down options in the ComboBox does absolutely...

Hey I hope someone can help I have two sheets in my workbook Sheet 1 with column called Services (cells H15:H28000) and column called quantities (cells J15:J28000) Sheet 2 with column called Services (cells B4:B150) and Rates (cells C4:C150) I'm trying to put a formula in sheet1 that will look...

I have thousands of cells with text containing various descriptions. I'm trying to search the text and tell me if the description says x, y, or z and to return which one it says. The descriptions are all over the board, but contain certain key words that I need to categorize. Example Below...

Hey guys I am trying to compare delivery shipping opens for different zip code pair and the ata is coming out in a format that I really can not use. I want to be able to see the zip code pair and all services that are available with all the other info. <colgroup><col width="107"><col...

Hi all, I'm trying to create a excel table of organizations for other people to be able to filter and look for specific organizations. One of the fields you can use to filter the table is "Service areas", which can include things like employment, disability, housing, and etc. Many of the...

Hey Everyone! I need some help figuring out how to delete certain text that repeats itself within a cell in Excel 2010. Right now I have (for example) all in one cell A1: "John Smith (Services - 6)/OAI; David Frame (Services - 6)/OAI; Kyle Pilot (Services - 6)/OAI" and I am trying to...

<tbody> <tbody> Youth Service - NEET / Youth Payment, Support and Training for Service Providers - Education, Programmes for Young People, Elder abuse,Local Community, Elder abuse </tbody> <tbody> Intellectual Disabilities, Finding work, Community Courses, Work </tbody> <tbody>...

Hi All, I have a list of records <tbody> <tbody> 3 </tbody> <tbody> Youth Services </tbody> <tbody> 3 </tbody> <tbody> Family / Whanau Services </tbody> <tbody> 3 </tbody> <tbody> Family Violence </tbody> <tbody> 3 </tbody> <tbody> Education...

Hello, I am new to web services, and I am trying to connect to DHL timetable WS. https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx The WSDL can be found here: https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx?wsdl When I connect through SoapUI 5.4.0, I can send requests and recieve...

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

Hello community, I am stumping over a problem this afternoon. I have the following formula in my Sub: ActiveCell.FormulaR1C1 = _ "=GETPIVOTDATA(""Hours"",'[TestClient.xls]Pivot Table'!R3C1,""Department"",""Client Services"")" I would like to be able to replace TestClient with a string...

Hi, my data set is below, with different dates in column A, and there are multiple rows with the same dates I would like to get the total $amount, for 9/22/17, for example, where Type is not = services could you help me with the formula for this? <tbody> 1 A B C 2 dates $amount...