nut

Is there a way to have Excel compare cells in a row to cells in another row (on a different sheet or excel file) to look for a partial or full match and return the row “name”? Example below. One file lists the possible packages and what is contained in those packages (Package A has a nut, bolt...

Good morning, what a great site! I wonder if you could help… I have to sort through different reports from different departments on a monthly basis & turn them into something which (hopefully!) makes sense. One issue we have is that I have to go through the different (unconfirmed)...

Hello! I am trying to create a Parts Order list that automatically updates as items are added to the Bill of Materials. Given the first table, I am trying to create a table that will update the quantity of items already in the bill, and add new items that aren't already on the Parts Order list...

Dear All, I am new to this forum. I am trying to find a solution for the following; within a tabel with several columns I am trying to find the last row (preferably column with the date for which the last specific value has been found in the table). See attached example. With vertical...