Urgent help required.

[Guest]

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

 

[Guest]

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:

 

[Guest]

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?