Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent help required.
We have an Excel file with all our suppliers products (which has 1000s of
products) and we want to sort them so we can print the list of and it match the list of our accounting program. Our accounting program sorts the list by supplier product code, and can't be sorted any other way. We urgently need to print of an Excel price list sorted to our accounting program. An example is below: Left is how Excel sorts the list and right is how we'd like it sorted (i.e. we need it sorted alphabetically, not numerically. You'll see if you sort the the list in excel you'll get the result on the left ACRULE 100 B1MEAUSRE 100a 72 1000BB 90 512 100 72 512 90 1000BB ACRULE 100a B1MEAUSRE |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent help required.
If cells are formatted as text, then sort gives you the required result.
Watch out! Simply reformatting cells doesn't change the real types of existing values! To do it you have to use =TEXT(A1,"@") function (and copy back the converted values to their original column if needed)! Regards, Stefi €žJonathanW€ť ezt Ă*rta: We have an Excel file with all our suppliers products (which has 1000s of products) and we want to sort them so we can print the list of and it match the list of our accounting program. Our accounting program sorts the list by supplier product code, and can't be sorted any other way. We urgently need to print of an Excel price list sorted to our accounting program. An example is below: Left is how Excel sorts the list and right is how we'd like it sorted (i.e. we need it sorted alphabetically, not numerically. You'll see if you sort the the list in excel you'll get the result on the left ACRULE 100 B1MEAUSRE 100a 72 1000BB 90 512 100 72 512 90 1000BB ACRULE 100a B1MEAUSRE |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent help required.
Can you import your accounting list into Excel (giving the required sorted
order) and then use VLOOKUP to get the corresponding prices from your Excel price list? "Stefi" wrote: If cells are formatted as text, then sort gives you the required result. Watch out! Simply reformatting cells doesn't change the real types of existing values! To do it you have to use =TEXT(A1,"@") function (and copy back the converted values to their original column if needed)! Regards, Stefi €žJonathanW€ť ezt Ă*rta: We have an Excel file with all our suppliers products (which has 1000s of products) and we want to sort them so we can print the list of and it match the list of our accounting program. Our accounting program sorts the list by supplier product code, and can't be sorted any other way. We urgently need to print of an Excel price list sorted to our accounting program. An example is below: Left is how Excel sorts the list and right is how we'd like it sorted (i.e. we need it sorted alphabetically, not numerically. You'll see if you sort the the list in excel you'll get the result on the left ACRULE 100 B1MEAUSRE 100a 72 1000BB 90 512 100 72 512 90 1000BB ACRULE 100a B1MEAUSRE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT IF STATEMENT REQUIRED:True if moving between financial years? | Excel Worksheet Functions | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Urgent Help required on printing option | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
excel page breaks - urgent help required | Excel Worksheet Functions |