Sort If

[jschnegel]

Hi,

Is there a way to sort a set of data by a given column value only if a different column contains a certain value?

For example: If there are numerous entries separated into 4 groups (numbered 1-4) and each entry is assigned a cost. I want to sort all the entries first by group, then within each group sort the entries by cost. The number of entries in each group changes.

I am able to record a macro to automatically sort all the entries by group, but is there also a way, possibly in VB, to then automatically sort each group taking into account that the number of entries for each group may change?

 

[Andrew Poulsom]

Why can't you sort by group then by cost? Sort allows more than one field.