| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy row to new sheet if cell data is repeated more than 3 times
I have a spreadsheet with various pieces of data. Each value will be
repeated at least once in the sheet. I would like to use a macro that will look thorugh the rows of a specific column, and copy the entire row if it the data appears more than three times. Could anyone help me with this? For example, in the following all rows for credential 2, 3, and 5 should be copied onto a new sheet. timestamp 24/05/10 23:54:39 Valid credential 1 24/05/10 23:37:04 Valid credential 2 24/05/10 23:27:03 Valid credential 3 24/05/10 23:26:59 Valid credential 4 24/05/10 23:26:55 Valid credential 2 24/05/10 23:18:10 Valid credential 1 24/05/10 23:15:42 Valid credential 2 24/05/10 23:14:11 Valid credential 3 24/05/10 23:09:18 Valid credential 4 24/05/10 23:02:47 Valid credential 4 24/05/10 23:02:42 Valid credential 3 24/05/10 22:38:59 Valid credential 5 24/05/10 22:38:33 Valid credential 1 24/05/10 22:38:31 Valid credential 5 24/05/10 22:38:29 Valid credential 2 24/05/10 22:38:27 Valid credential 5 24/05/10 22:33:39 Valid credential 3 24/05/10 22:31:35 Valid credential 5 24/05/10 22:31:33 Valid credential 5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return names which are repeated 5 times | Excel Discussion (Misc queries) | |||
| Max no. of times a text repeated | Excel Discussion (Misc queries) | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Inserting Data Repeated Times | Excel Discussion (Misc queries) | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
Threaded Mode
