| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain if atleast 4 entries
Hi
I have a unique problem here. I have got an excel file with almost 2500 rows of data in it. Coulumn "A" contains the ID # of companies. Each company might have more than one data entry (row), so it looks something like this: A B C D E 34982 data data data data 34982 data... 5533812 data... 5533812 data... 5533812 data... 5533812 data... 5533812 data... 456832 data... 456832 data... 456832 data... What i need to do is to write a program which will look at the first column of ID#s and if the ID# occurs less than 4 times, i delete those rows. Basically if a company has ATLEAST 4 data entries, i have to keep it, if not, delete entire rows of that company. Any kind of suggestion would be very helpful! Thanks a lot in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW I US "IF" FORMULS ATLEAST 15times, | New Users to Excel | |||
| De-dup and retain new records only | Excel Worksheet Functions | |||
| Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
| retain formatting when concatenating | Excel Worksheet Functions | |||
| retain cell formatting | Excel Discussion (Misc queries) | |||
![Randy[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
