Get instant live expert help on I need help with part number generator excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a number generator (randbetween(1,69)) that will generate a table of 5 numbers. I am trying to eliminate previous number rows from the generator.
Solved by Z. Y. in 18 mins
Using MS Excel I have a list of part numbers, 90k, with the part number, a semi colon and another number after the semi colon. I want to remove all the numbers after the semi colon on each part number. Is there a way to easily accomplish this?
Solved by C. J. in 24 mins
I have a three column excel spreadsheet with part number, quantity, and price. The part number field is not unique and repeats with every different quantity and price break. I need to reformat the data set so the part number is unique with all the quantities and pricing extending in the same row.
Solved by X. B. in 29 mins
I have a combination of packing lists. The parts are listed under headings. Only the first item has the part number. I want to allocate that part number to the other items in the list. For example the first number in column A is "Part 1", there are 15 sub parts in the "part 1" bundle. I want them all to be noted as "Part 1". The next number in column A is "Part 2" item is "Part 2", there are three sub parts. I want them to be noted as "Part 2". What I am looking for is a formula that will read the first number and allocate to the following blank entries until the next Part number is found.
Solved by A. A. in 26 mins
I need to update an excel sheet with new pricing - I have part numbers so i need to use the part number and use that as a key to update the pricing
Solved by K. E. in 11 mins