I need to sort the following data in excel: High to low, left to right via price
So this is the problem I have to price check a number of products (each represented by a row). There can be up to 3 price checks per row and the data needs to be sorted by price from high to low, left to right but the relevant price check information need to remain intact.
Store, Price, Shipping, Total (hidden), Url.
Simply put i need a formula that can turn the data in row 4 to look like that of row 5 in the attached file Freelancerjob.xlsx
Can anyone help? Ideally this would be a formula or code that automatically sorted the data on entry.
S
Last edited by Wyngle; 01-27-2012 at 02:54 AM.
There is no attachment
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Hi RoyUk,
Sorry, now attached
S
Attach a workbook not an image
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Worked it out, please find workbook attached.
Kind regards,
S
Last edited by Wyngle; 01-27-2012 at 02:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks