You can define your custom comparison criterion by using a particular event. By default, sorting and grouping is based on the standard logic for comparing cell display values. If this logic does not meet your requirements, you can always handle the CompareRows event and provide custom comparison logic.