facility

Hello, I have been trying to figure out a formula that will count how many times a particular part has been in our facility. Parts are identified by part number and serial number so I need to count the combination of the 2. Example: <tbody> <tbody> part_number serial_number Amount of Times...

Hello Fellow Users, I need help concatenating two columns and retaining the color format located in column B. Please see the snapshot below. Can someone help me with the VBA code? Thank you! Column A (A1:A200) Name Column B (B1:B200).....Column B text color: RGB (47, 117, 181) Lname...

Can anyone point me to a good resource for learning how to do some basic analytics in Excel? What I'm trying to learn how to do is look at all the operating and maintenance costs of hundreds of facilities and determine which ones cost the least/most overall. Also to look for cases where a...

Hello, I am trying to figure out how to create a formula that will feed into a different worksheet. I have most of it figured out but I am stuck at two parts. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> AsOfDate BankId AccountNumber AccountName BaiControl Currency...

I'm working with a large table similar to the one below with thousands of Order #'s (Column A). In Column D I'm trying to identify the status of each Order # based upon the Line Description(s) in Column B associated with each unique Order #. If Column B contains "Fiber Facility - Enterprise"...

I have two tabs in a file. One tab has different facilities and their associated metrics (8-10 metrics). Each metric value is conditional formatted using color schemes option. The second tab is a report which has a drop down to select a facility. Depending on the facility selected, all their...

Hello, I trying to figure out the best way to group data according to a few fields available. In a nut shell, I have many different facility names in my data, however, because of humans entering different versions of the facility name, it's becoming impossible to pivot out correctly. i.e...

Good Morning, I was looking for some help on getting the difference between subtotals on two different pivot tables. The problem is that the rows on the pivot tables will not line up with each other so i need it to pull based on facility name and subtotal. So basically I am creating a table...

Hello. I am trying to compile a database and use some function to match the number of calls ran by date. For example: <tbody> 1/1/18 1/2/18 Facility A 15 Facility A 25 Facility B 20 Facility B 15 Facility C 30 Facility C 15 Facility D 20 Facility D 10 Facility E 8 Facility E 7...

Hello, I am trying to create a heat map of the facility I work in. Currently, I have conditional formatting set to darken cell color as each microbial instance is input into the worksheet at each location, but I would like to transfer this to points (like, literal circular spots) on a...

I have a report that I need to get the return as the facility name. I am trying to see if a formula or a macro will solve my problem. So in the sample below, I need to look up values on the First Sheet Column A (3 digit zips) and compare it with column B (3 digit zip to look up from) on the...

I have a spreadsheet that I need to calculate a bonus based on the years of service. I have had a formula in the past, but every year it has to be updated because the formula is if the employee has 5-9.9 years of service they get a 2% bonus of their annual salary, if the employee has 10-14.9...

I have a list of patients, admit dates to our facility, and readmit dates to a different facility. Columns: Name/Date of Admit/Date of Transfer to another facility I can manually drag range - lets say A1 to A100 and Columns A to C but can't get pivot table to pick up an entire columns so...

Problem: We searched a total number of cases (total cases searched) and found errors in x number of cases (cases found). The average errors in those number of cases found is "average mistakes per case". These cases were searched using 3 different softwares: Non-CAC, CAC, and Legacy Scrubber...