If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting data field
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 |
#2
|
|||
|
|||
Sorting data field
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 |
Thread Tools | |
Display Modes | |
|
|