MASOODAHMAD
Board Regular
- Joined
- Mar 28, 2012
- Messages
- 105
- Platform
- MacOS
Hi,
I want to sort the data from Highest (Old price) to Lowest (Old Price) for each product in the row. Please remember that it should not be sorted columnar wise. The New price in each Row should intact with it's corresponding Old price.
The data is given below:
Version:1.0 StartHTML:0000000170 EndHTML:0000016601 StartFragment:0000001567 EndFragment:0000016555 SourceURL:file://localhost/Users/agi-sony/Documents/Sorting.xls <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Verdana; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl24 { border: 0.5pt solid windowtext; }.xl25 { background: none repeat scroll 0% 0% rgb(204, 255, 255); }.xl26 { font-weight: 700; background: none repeat scroll 0% 0% rgb(255, 204, 153); }.xl27 { font-weight: 700; background: none repeat scroll 0% 0% rgb(255, 204, 153); }</style>
<col style="" width="85"> <col span="16" width="75"> <tbody>
</tbody>
I have done one row manually:
Version:1.0 StartHTML:0000000170 EndHTML:0000002679 StartFragment:0000001551 EndFragment:0000002626 SourceURL:file://localhost/Users/agi-sony/Documents/Sorting.xls <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Verdana; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl24 { border: 0.5pt solid windowtext; }.xl25 { font-weight: 700; background: none repeat scroll 0% 0% rgb(255, 204, 153); }</style>
<col style="" width="85"> <col span="16" width="75"> <tbody>
</tbody>
I want to sort the data from Highest (Old price) to Lowest (Old Price) for each product in the row. Please remember that it should not be sorted columnar wise. The New price in each Row should intact with it's corresponding Old price.
The data is given below:
Version:1.0 StartHTML:0000000170 EndHTML:0000016601 StartFragment:0000001567 EndFragment:0000016555 SourceURL:file://localhost/Users/agi-sony/Documents/Sorting.xls <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Verdana; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl24 { border: 0.5pt solid windowtext; }.xl25 { background: none repeat scroll 0% 0% rgb(204, 255, 255); }.xl26 { font-weight: 700; background: none repeat scroll 0% 0% rgb(255, 204, 153); }.xl27 { font-weight: 700; background: none repeat scroll 0% 0% rgb(255, 204, 153); }</style>
Products | Old Price | New Price | Old Price | New Price | Old Price | New Price | Old Price | New Price | Old Price | New Price | Old Price | New Price | Old Price | New Price | Old Price | New Price |
Apple | £27.50 | £23.38 | £20.00 | £17.00 | £8.00 | £6.80 | £28.00 | £23.80 | £35.00 | £29.75 | £24.50 | £20.83 | £14.00 | £11.90 | £17.50 | £14.88 |
Guava | £17.50 | £14.00 | £15.00 | £12.00 | £25.00 | £20.00 | £12.50 | £10.00 | £20.00 | £16.00 | £22.50 | £18.00 | £21.00 | £16.80 | £28.00 | £22.40 |
Mangoes | £35.00 | £28.00 | £24.50 | £19.60 | £21.00 | £16.80 | £17.50 | £14.00 | £28.00 | £22.40 | £18.00 | £14.40 | £40.00 | £32.00 | £25.00 | £20.00 |
Pineapple | £3.00 | £2.40 | £30.00 | £24.00 | £65.00 | £52.00 | £50.00 | £40.00 | £35.00 | £28.00 | £45.50 | £36.40 | £42.00 | £33.60 | £70.00 | £56.00 |
Watermelon | £3.00 | £2.40 | £30.00 | £24.00 | £65.00 | £52.00 | £50.00 | £40.00 | £35.00 | £28.00 | £45.50 | £36.40 | £42.00 | £33.60 | £70.00 | £56.00 |
Melon | £27.50 | £23.38 | £28.00 | £23.80 | £8.50 | £7.23 | £18.00 | £15.30 | £30.00 | £25.50 | £20.00 | £17.00 | £21.00 | £17.85 | £17.50 | £14.88 |
Cherries | £24.00 | £19.20 | £35.00 | £28.00 | £42.00 | £33.60 | £24.50 | £19.60 | £40.00 | £32.00 | £45.00 | £36.00 | £21.00 | £16.80 | £28.00 | £22.40 |
Strawberry | £24.50 | £19.60 | £24.00 | £19.20 | £40.00 | £32.00 | £45.00 | £36.00 | £35.00 | £28.00 | £17.50 | £14.00 | £29.50 | £23.60 | £21.00 | £16.80 |
Grapes | £50.00 | £40.00 | £45.00 | £36.00 | £35.00 | £28.00 | £40.00 | £32.00 | £80.00 | £64.00 | £42.00 | £33.60 | £25.00 | £20.00 | £60.00 | £48.00 |
Pomegranate | £10.00 | £9.00 | £7.00 | £6.30 | £2.00 | £1.80 | £3.00 | £2.70 | £5.00 | £4.50 | £8.50 | £7.65 | £9.00 | £8.10 | £1.75 | £1.58 |
Plum | £15.00 | £12.00 | £12.00 | £9.60 | £8.00 | £6.40 | £17.50 | £14.00 | £18.50 | £14.80 | £3.00 | £2.40 | £14.00 | £11.20 | £20.00 | £16.00 |
Pear | £15.00 | £13.50 | £8.00 | £7.20 | £10.00 | £9.00 | £12.50 | £11.25 | £16.00 | £14.40 | £6.00 | £5.40 | £25.00 | £22.50 | £20.00 | £18.00 |
£20.00 | £16.00 | £18.00 | £14.40 | £14.00 | £11.20 | £12.00 | £9.60 | £30.00 | £24.00 | £25.00 | £20.00 | £17.50 | £14.00 | £21.00 | £16.80 | |
£10.00 | £9.00 | £20.00 | £18.00 | £17.50 | £15.75 | £14.00 | £12.60 | £18.00 | £16.20 | £16.00 | £14.40 | £8.00 | £7.20 | £12.50 | £11.25 | |
£3.00 | £2.40 | £30.00 | £24.00 | £65.00 | £52.00 | £50.00 | £40.00 | £35.00 | £28.00 | £45.50 | £36.40 | £42.00 | £33.60 | £70.00 | £56.00 |
<col style="" width="85"> <col span="16" width="75"> <tbody>
</tbody>
I have done one row manually:
Version:1.0 StartHTML:0000000170 EndHTML:0000002679 StartFragment:0000001551 EndFragment:0000002626 SourceURL:file://localhost/Users/agi-sony/Documents/Sorting.xls <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Verdana; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl24 { border: 0.5pt solid windowtext; }.xl25 { font-weight: 700; background: none repeat scroll 0% 0% rgb(255, 204, 153); }</style>
Apple | £35.00 | £29.75 | £28.00 | £23.80 | £27.50 | £23.38 | £24.50 | £20.83 | £20.00 | £17.00 | £17.50 | £14.88 | £14.00 | £11.90 | £8.00 | £6.80 |
<col style="" width="85"> <col span="16" width="75"> <tbody>
</tbody>