parts

So, I got "in-trouble" today at work for screwing up on my inventory file. I forgot to add some shipments back into inventory that didn't actually leave the building on the day of inventory. Never mind that part. What I need, please, is some help designing an inventory file that will help me...

Hello, I currently have 2 lists of part numbers List A contains 80 parts. List B contains 403 parts. I'm looking to find a way to return any part number in list B if it has the part number from list A in it. Example: List A part TBS-66 List B part numbers i'd want to return: TBS-66...

Hello, Im currently working on a spreadsheet for my work to show what parts we need each week to finish our project, i have been requested to make out all the parts by sundays, and was wondering if putting the delivery date in one cell, if there was a formula that would see say "25-Jan" and put...

I'm wanting to present the EU with a way to identify who referred a Client to them. If another Client did, then I want to track how many referrals that Client has sent the EU's way. Client's have the following identifiers: Name, Nickname and Client ID. All 3 are already named ranges and of...

Hi I have been given this formula but I don't understand some parts in the false section, please could someone explain the parts of the formula to me in detail, especially what the (1- means many thanks in advance {=IF($U2="Fuel...

I'm trying to figure out this formula: minimum value in the range which is less than zero than to display a result if Need to order parts or Not. so far this is what i have: {=MIN(IF(AND(04>0,04<0),"OK","Not enough parts"))}. But i get an error message a value used in the formula is of...

Hi Everyone, This is probably a really simple thing but when inserting the VLOOKUP function, what is an easy way to know and remember what to insert in each of the parts of function like in lookup_value, table_array and col_index_num? It confuses me as to what to put in each.

The attached spreadsheet is an inventory list. Each tab is a different category of parts and supplies and the first tab, called "All Parts Catalog Only" is the main page. I am having a problem with people adding new parts and pictures to the individual tabs but not adding them to the "All...

I wood say ;) that one of the most practical uses of an advanced spreadsheet for the Average User, would be to create a sheet that determines the best use of several pieces of wood, such as plywood, based on a parts list. Im not saying its possible for the intended purpose, but if they could do...

Help with what should be a easy solution I will set the scene Column named Parts Made, (31 rows 1 for each day dated for every day) I want to average the parts made on Mon to Fri and make a projection of how many parts we should by month end. I also want to average the parts made on weekends as...

Hello Col A (A4:A1500) is populated with part numbers using formula =IF(' Parts List'!A4 <>"",' Parts List'!A4,""). I'm trying to count number of part numbers in Col A only that are displayed (filtered). I tried this formula, but obviously is wrong...

Hi Under View tab there are 2 options: one is Split and another in New Window. I thought if we can split a worksheet then we can compare different parts of the sheet but we can also create a new window and compare different parts. So why we have these 2 very identical? Thank you.

Hi All, I am trying to write a VBA code to perform the task mentioned in the title. Here are the specifics: Notes: -The function needs to loop from row 1 to the last row that contains a value (in Sheet1). The range can be a static range for Sheet2. -Row A will always be used for the check...

we can search a web portal for a specific part or multiple parts. however, to search for multiple parts, we have to enter like so; abcdfe;syajkaiaioaoa;sdjhsjsiioa; etc. What we want to search for, with a semicolon delimiter. i would love a macro that would take the values in a column, put...

Hello, I have a workbook used to determine the cost of constructing machinery. There is one worksheet which is a massive list of parts (bolts, screws, etc.) and their costs. The user will select what parts they need on other sheets, and their are cells to multiply the cost of what they need by...

Hi, I have a sheet which lists the number of parts for every supplier. I have a column for a list of current month parts, last month parts and parts of the last 12 months. I have been trying to build a formula in order to compare the three columns with comments...

Hi All, I'm having some troubles calling the value in a dictionary, I assume it's a simple syntax issue so hopefully someone will be able to educate me easily enough. I'm also not 100% sure that a dictionary is the best/easiest way to go about doing what I'm doing, so I'm open to alternative...

In it's most simplest form my need is simple... I have a cell that contains a "note field". I would like to search inside this note field and pull out a date that is before a specific sub-string. It gets tricky when I start to break it down and try to actually make it happen, however. The data...

Hi all, Imagine you run a fleet of thousands of vehicles. You have a few hundred which are not usable because they are waiting for one or more spare parts. You keep track of all the spare parts ETA to your workshop. I'm struggling to make a formula which would rank the whole list of spare parts...

Hi there everyone I've just converted a bunch of emails from an Outlook folder into Excel. All went well except for the field that is the body of the email is causing me an issue. In Excel, the converted field shows in the cell as e.g.: Name John Smith Company John Smith Limited Position...