B
Bryan
I have a data worksheet created in excel with a column containing 5 digit
serial numbers, up to 300 diferent serial numbers (in individual rows). I
have the data sorted in assending order based on serial number column.
Serial numbers are random and not consecutive (ie. 05943, 05944, 05945,
05968, 05988 etc..)
1) I need to be able to select all the serials and transfer them to another
worksheet in excel, placing them in one cell, table, or ? - for purpose of
issuing a certification to our customer listing all the serial shipped- is
this possible?
2) If they can be in be transfered, is there a formula that would list them
in ranges instead of all 300 serial numbers? (ex. 05943 thru 05945, 05968,
05988 thru 06112 etc...)
serial numbers, up to 300 diferent serial numbers (in individual rows). I
have the data sorted in assending order based on serial number column.
Serial numbers are random and not consecutive (ie. 05943, 05944, 05945,
05968, 05988 etc..)
1) I need to be able to select all the serials and transfer them to another
worksheet in excel, placing them in one cell, table, or ? - for purpose of
issuing a certification to our customer listing all the serial shipped- is
this possible?
2) If they can be in be transfered, is there a formula that would list them
in ranges instead of all 300 serial numbers? (ex. 05943 thru 05945, 05968,
05988 thru 06112 etc...)