items

hello, i am trying to do an IF OR statement for a sheet that looks like this <tbody> Column A Other Non BAU Event-Use Comments Other-Use Comment Box </tbody> so i want it to return a 1 if the fields say either of those items i tried this but it didnt work: =IF(OR($A2="Other Non BAU...

Let's say I have a spreadsheet that has all towns in the world. All towns have houses in it. All houses have items inside. All those items have smaller items inside. And so on until row level 6. I want to make a macro that based on my filter search opens all of its children. For example if I...

Where I am pasting to is a table. My Titles in the Table (CMOPTable) start on Row 11 in B. Note the Table size will vary depending on what's being pasted each time. This Pastes from the last Row up. So if the TABLE has 15 Rows in the table (and they are blank) and I select 3 items to Paste...

Hello- I am stuck on Excel Solver question. I have 4 decision variables used to determine thresholds for items to stock in warehouse. From a list of of all items, by changing these variables in any combination, I can identify new opportunities to generate incremental revenue. I have a binary...

Hi I'm using excel 2016, with data running down the columns Q,S,T it calculates items divided by hrs, but I'm stuck as i have partial hrs and this over inflates the value in T1, is there anyway i can make it more accurate say to the nearest 15 minutes also how do i remove #DIV/O! as my...

Hi All: I've got a worksheet that includes a running list of To Do items for various projects. Right now it shows both closed and open items in the same list. I use filters to hide closed items. I close an item by putting an X in column A, which then puts the date closed in column K. How...

Hi, I have an Excel file which tracks expiration dates of all items with a support contract. I need to be able to lookup at anytime and quickly identify which items are coming up for renewal in the next 60 days. I can pull the concerned SNs in a separate sheet or color code them in the same...

I am looking to count what locations are using a specific item. I am not sure the best way to do this based on how my data is generated from an external source. I don't like adding sheets/columns if needed. Any suggestions? CURRENT SET UP SHEET 1 COL A= Locations (70,000 rows, but only 10...

Hi All, I have the following formula that i wanted to total up where items in Col E match items in Col F and give me back a total. =SUMPRODUCT(--('Pending Prod Orders'!E:E='Pending Prod Orders'!F:F)) For some reason its counting all the blank cells that are contained in these columns which...

Hello all, I need the macro created below to preform same action in subsequent rows, same column. I though the range copy method would work, but I am missing something. Sub RemoveHypens() Dim the_string As String the_string = Sheets("Gopher Items CSV Test").Range("E3") the_string =...

I'm having to add (and subtract) a lot of numbers in a lot of cells and want to be able to count the number of items being calculated in that cell. It's so I can compare to the document I'm copying the numbers off of as a cross-check. So: =15+32+50-42+3 would be 5 items being calculated...

Hi There, I have a few sheets of items. I want a person to be able to put x's in the cell to the left of any one of those items on any one of those sheets, and have the selected items appear one after the other on a final sheet, i.e. an order form. Any idea how I might be able to...

Hi all! Was hoping someone might have some more insight into how I can leverage named ranges and SUMPRODUCT. My objective is to create a business score card that contains subcategories within overall brands. So, for example, think about Brand X containing items in Subcategory A, B, and C...

Hello, I want to build a simple sheet to manage inventory for rental business with 3 warehouses. Items can be pulled from, and return to any warehouse. When the quantity of items is entered, I want some kind of button to appear where I can choose which warehouse the items will pull from...

I have a data table and would like to filter out all items starting with an X, Y, Z I have tried using Text filters does not contain, but it only allows 2 criteria It would be appreciated if someone could kindly assist me

Hello all, I have an inventory list along with the lead time of each item. Can someone help me with a formula to get the 1 average lead time number for all items for each vendor. VENDOR A has 330 items - Average Lead Time for Vendor A 5.65 VENDOR B has 693 items - Average Lead Time for Vendor...

how do i Paste all clipboard items with match formatting?

Hi all, hoping you can help as I'm a bit lost with this. My data has several columns of information regarding deliveries, the dates they were made and if all the items ordered by the customer were in the delivery. I need a formula to check the data and put a value of "bulk" if a delivery with...

I created a Personal.xlsb file that has saved successfully but it doesn't open automatically when I open an Excel workbook. I tried checking under Add-Ins and Disabled Items, but there are no items listed. If I locate and open the file directly from the C:\ drive, it then gets added to the...

Good afternoon, Assuming I have the following items in a selected range: 1,2,2,2,3,4,4,5,6,6,7,7,8,8,9 can anyone suggest a VBA solution to display the number of items that occur in the list only ONCE? In the above example, the answer would be 4 as only four numbers occur uniquely in the list...