Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
certain rows from a lot of data
I'm doing an assignment on executive payments and need to organise my data
set. currently i have a column for executive ID's (execid), companies for which they work (GVKEY) and in what year (YEAR). I need to somehow organise it so that only executive that have worked for at least 3 years for the same company are showen in a new table and that this table includes all the years they have worked for that company (including the first 2). there is also other columns If anybody could help it would be much appreciated. the data list is about 30,000 rows long so can't really do it manually. Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
certain rows from a lot of data
Assuming execid and GVKEY data running in A2:B2 down
In say, D2: =IF(COUNTA(A2:B2)<2,"",SUMPRODUCT((A$2:A$30000=A2) *(B$2:B$30000=B2))=3) Adapt the ranges to suit your actual data extents. Copy D2 down all the way. Freeze col D with an "in-place" copy n paste special as values. Autofilter col D, choose TRUE. Copy the filtered results (that's what you seek), paste on another sheet for your downstreams. Any good? hit the YES below. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "ozzyed" wrote: I'm doing an assignment on executive payments and need to organise my data set. currently i have a column for executive ID's (execid), companies for which they work (GVKEY) and in what year (YEAR). I need to somehow organise it so that only executive that have worked for at least 3 years for the same company are shown in a new table and that this table includes all the years they have worked for that company (including the first 2). there is also other columns If anybody could help it would be much appreciated. the data list is about 30,000 rows long so can't really do it manually. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto extract data & inserts rows additional rows automatically | Excel Discussion (Misc queries) | |||
Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions |