Anyone can help? I have attached an excel table of what i mean
Anyone can help? I have attached an excel table of what i mean
Hi, with 2 helper columns you can achieve the first 2 points, but the last one regarding the address is difficult to achieve for be because the the Delivery company will not be sorted alphabetically. Apply the following formulas and see if is good enough:
D2:Please Login or Register to view this content.
F2:Please Login or Register to view this content.
F2 formula is arrayPlease Login or Register to view this content.
G2, array entered:H2:Please Login or Register to view this content.
E2:Please Login or Register to view this content.
orPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks