Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen through to extract highest education qualification
Hi
in a scenario whereby I have a listing of employee records, each employees with more than 1 row of education records, e.g. from elementary to college or masters... in such case, is excel able to screen through to extract the highest qualifications out for me? i am able to sort them out but will still require manual labour to extract the highest qualifications for each employee. i'm refering to a scenario whereby i have few thousands of records which manual extraction is strongly not advisable. thanks! =) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen through to extract highest education qualification
Adding an auxilary column will help
=IF(COUNTIF(A1:A100,A1)1,IF(COUNTIF(B1:B100,"Mast ers")1,"Masters",IF(COUNTIF(B1:B100,"College")1, "College","Elementary")),B1) this formula will put only the highest education level in the auxilary column. A1:A100 is the persons name. If list more than once than there will be more than one entry. If only one then the last B1 will display the one netry. B1:B100 is the education level listed as Master, College, or elementry. "KC" wrote: Hi in a scenario whereby I have a listing of employee records, each employees with more than 1 row of education records, e.g. from elementary to college or masters... in such case, is excel able to screen through to extract the highest qualifications out for me? i am able to sort them out but will still require manual labour to extract the highest qualifications for each employee. i'm refering to a scenario whereby i have few thousands of records which manual extraction is strongly not advisable. thanks! =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
premium solver education | Excel Discussion (Misc queries) | |||
counting distinct entries with a qualification | Excel Worksheet Functions | |||
computers in education | Excel Discussion (Misc queries) | |||
Auto clear when qualification is met | Excel Discussion (Misc queries) | |||
Training/Education Documents | Excel Discussion (Misc queries) |