Thread: Sort formula or macro

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

Why not enter the data in a sortable form
say Price Delivery URL
Retailer
David Jones $50.00 $0.00
JB HiFi $300.00 $0.00
Myer $20.00 $0.00
and then write code to put the data into another sheet in the format that yopu want post sorting.

Or if you have a fixed or maximium number of price checks on the sheet then write code to create an array which you sort and put back into the desired cells in the VB Code?
Does this make sense?

Hi Ian,

That's not really possible, the reasoning for this formula is to try and cut the amount of work down, easier to enter the data in this format otherwise I'll have multiple sheets and data all over the place.

I'm trying to find a solution that will allow me to sort hundreds/thousands of products and price check data.

Thought of doing it in Access?