Hi all, first post and not really sure how best to explain so here is a shot...
I have a set of data looking at individual education level (e.g. HS, BS, MBA, and PHD) and what concentration for each one (e.g. Chem, Bio, Finance, etc.). If you went to HS, got a BS and an MBA, you would have 3 separate rows specifying as such with your name repeated.
My goal - I want to come up with the least complex way of accounting for the highest completed education level for each person (there are about 300 individuals) so to only count you once and note which degree was the highest.
Any thoughts as to which way/formula would be most simple so that I can then create a pivot with this information to count the number of (BS, MBA, PHDs, etc) and majors? Concatenate comes to mind but I do not want more formulas than needed if it can be avoided as this will be passed on to less techy users
Hope this is a little clear.
Much thanks in advance
I have a set of data looking at individual education level (e.g. HS, BS, MBA, and PHD) and what concentration for each one (e.g. Chem, Bio, Finance, etc.). If you went to HS, got a BS and an MBA, you would have 3 separate rows specifying as such with your name repeated.
My goal - I want to come up with the least complex way of accounting for the highest completed education level for each person (there are about 300 individuals) so to only count you once and note which degree was the highest.
Any thoughts as to which way/formula would be most simple so that I can then create a pivot with this information to count the number of (BS, MBA, PHDs, etc) and majors? Concatenate comes to mind but I do not want more formulas than needed if it can be avoided as this will be passed on to less techy users
Hope this is a little clear.
Much thanks in advance
