#### Michele Ferrao

##### New Member

- Joined
- Sep 9, 2014

- Messages
- 3

I would really appreciate your help in understanding how to automatically sort rows depending on the value in a certain column.

The data in the table is based on a Vlookup formula. The range of data including the headings is from B9 to K24. I want to sort the information in these cells depending on column C(Product Code) with values from C10 to C24 in a descending order automatically. Row 9 is the heading of the table.

Component Ingredients | Product Code | Weight Kg/L | % | Allergen, if present | |||||

Roast beef | 35 | 0.100 | 28.33% | nil | |||||

Rock melon | #N/A | 0.070 | 19.83% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |

Whole grain mustard | #N/A | 0.040 | 11.33% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |

Melon | #N/A | 0.070 | 19.83% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |

Tomato Wedge | #N/A | 0.026 | 7.37% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |

Parmesan | #N/A | 0.020 | 5.67% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |

Pesto | 5 | 0.010 | 2.83% | nil | |||||

Diced tomato | #N/A | 0.005 | 1.42% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |

Arugula | #N/A | 0.005 | 1.42% | ||||||

Sundried tomato | #N/A | 0.004 | 1.13% | ||||||

Lolorosso | #N/A | 0.002 | 0.57% | ||||||

Kalamata olive | #N/A | 0.001 | 0.28% | ||||||

Chive | #N/A | 0.001 | 0.28% | ||||||

Wheat bread | 400206 | 1 slice | #VALUE! | ||||||

#N/A | 0.000 | 0.00% |

<tbody>

</tbody>