I would like to sort the data in a sheet that is 6-9 columns wide so as to
find the event(s) when 3 consecutive horizontal cells in a row have the same
info. Can sort the selected events either to the top or the bottom of the
sheet, doesn't matter.
Using excel 2007. I would appreciate input how to do this if possible.
--
Bill

So what do you need help with -- sorting the data or finding the 3
consecutive cells?

To sort, highlight your data, then use DataSort. Follow the prompts.

For the duplicated data, the typical solution is to use Countif. If you're
checking column A, use:
=countif(A:A,A1)
and copy down

Any number greater than 2 meets your criteria. If you want to check for
exactly three, use:
=if(countif(A:A,A1)=3,"3 in a row","")

Regards,
Fred


"Bill C" wrote in message
...
I would like to sort the data in a sheet that is 6-9 columns wide so as to
find the event(s) when 3 consecutive horizontal cells in a row have the
same
info. Can sort the selected events either to the top or the bottom of the
sheet, doesn't matter.
Using excel 2007. I would appreciate input how to do this if possible.
--
Bill