Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
delete quintuplicate rows of data in spreadsheet
After importing data from a daily racing form into an excel spreadsheet
I will have the lifetime past performance of up to 100 +- race horses so Column A will contain as many as 15 to 20 races of the same (horse) name even though the data in Column B through ...........................(whatever column) will be unique. I only need to use 4 races from each horse, I would like a way to filter data so that only 4 races of each horse are available, the rest will be deleted. If exporting it into MS Access is a way to do it that is OK too!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Delete rows with no data | Setting up and Configuration of Excel | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) |