rack

I have.... Column A) Part Number, Column B) Locations of that parts and Column C) Available qty per location for each part The locations (Column B) I have are divided into A(Right side of the rack) and B (Left side of the rack) for each Rack. Ex. location NN.34.03.A and NN.34.03.B are...

I have the following 3 formulas. Is it possible to combine them into one or write a macro for them. =IF(LEFT(C:C)="R",G:G&" Rack") =IF(AND(LEFT(C:C)="R",RIGHT(C:C)="B"),G:G&" BLM Rack") =IF(RIGHT(C:C)="B",G:G&" BLM",IF(RIGHT(C:C,1)="C",G:G&" BLM",IF(LEFT(C:C,3)="TRT",G:G&" TRT",G:G)))

How can I change name of cells if 1 cell changes name. If A1 has the name "Store Rack 1" then Cells display names Pens, platic Bags, Paper in cells D5, F5, H5 If A1 has the name "Store Rack 2" then Cells display names eraser, Box, Pencil in cells D5, F5, H5 Example:1 If Cell A1 = Store Rack...

How can I pull certain text from a string using an fx? In my target column I only have two different sentences. OSV to Bulk Anodize OSV to Rack Anodize depending on which one it is, I only want to extract either the Bulk or the Rack text. How can I do that?

I have two lists. One is my source data. The second is the truncated version that I want the first list replaced with. I need a solution that will make this efficient and preferably automated as I don't want to have to follow a lengthy process every time I update the source data (typically...

I have searched all over the internet for a solution to this but have so far been unsuccessful. Lots of folks with similar issues out there but not exactly the issue I am having. I am trying to import a custom list that contains 54 entries. I have the list typed into excel with each list...