Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that is 59752 x 2, with the one column Contact ID A and
the other column Contact Link ID. It is like an instant messaging system. It looks something like this: 1 2 1 3 1 15 2 1 2 15 I want to count by different values in column A, and any count that is not within one of several ranges, those rows get deleted. So if the range is 3-5 contacts, then I want to keep the set of 1s, but delete the set of 2s. My ranges are 4-5 contacts, 30-41 contacts, and 100+ contacts. I am also brand new to macros, but I have experience with some other coding in Matlab and other programs and I understand logic statements and the like. Still, the more help/explanation the better. I am using 2007. Thank you!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select a range of rows to delete | Excel Worksheet Functions | |||
Delete rows based upon a range of times | Excel Discussion (Misc queries) | |||
Macro to delete blank rows in a data range | Excel Discussion (Misc queries) | |||
UDF to Count, but delete duplicate entries in a range using Excel2003 | Excel Discussion (Misc queries) | |||
delete rows in range - macro | Excel Worksheet Functions |