part number

I have an Excel sheet with 12 columns and 4000+ rows. In Column E, I have a list of part numbers. These part numbers may or may not be repeated based on the city names found in Column F. For example, Part A (located in Column E) may be in 3 different rows: one row for City X, one row for City Y...

I am having trouble coming up with a VBA code to find a part number I am searching for and then finding the highest (or last row) serial number, adding 1 to that number and creating a new line item. <tbody> Part Number Serial Number Description 5462H 023 Pan Head Screw 6524X 018 Washer...

Hi! I'm not an excel newbie but just learning all about the different functions that can make my job a lot easier.. In the spreadsheet I'm working on I know I need to use a MIN IF formula but I cant seem to get it to work. I have a list of Part Numbers in Column A, repeated multiple times...

I am a novice in excel (2010). I own a t-shirt brand, when I put together a print run with multiple designs, that have multiple colored shirts per design (as shown in my screenshot). I need to then total up the number of: SMALL BLACK-T, MEDIUM BLACK-T, SMALL BLUE-T, ETC from all designs...

Hi all - I am wondering if there is a way to create a dropdown list that outputs a different value than what the input was. For example, I want the dropdown list to contain full words (Machined, Bought, Assembled ect...) and when you click those words, it outputs a code based on the word (M, B...

I have tried everything I can think of to accomplish this sort. At this time I have spent more time trying to figure out the sorting of my document than it would have taken to re type it. Here is my problem: I have part numbers that are either solid numbers or alphanumeric. When Excel...