Hello all
I have the following table in excel
Full Name HisSuper SuperId
DAVIES, ROBERT K 1 1
WILLIAMSON, BRUCE E 1 2
WOLFE, THOMAS B 1 3
CARLSON, JERRY 2 4
KEATING, JOHN P 9 5
SWARTZ, KURT 3 6
DENISON, LESTER 5 7
RICHARDS, KARYN B 1 8
JENSEN, JAMES K 1 9
FRANK, PETER J 8 10
DUNSTAN, FRANK 1
KASHDAN, LINDA R 1
REILLY, SUSAN 1
SHEEHAN, FRANCIS E 1
ANDRITZ, GERALD J 2
CRAWFORD, SLOANE N 2
GORKA, DEBRA A 2
KRAMARCHYK, MARY C 2
LEE, DAVID 2
SCHMID, DOUGLAS A 2
BERNHARD, DOUGLAS 3
FRASER, CAROLE A 3
PERHAM, DENNIS R 3
VANDREI, CHARLES E 3
DENHAM, JASON 4
DIAMOND, STEPHANIE J 6
VERSCHOOR, KARIN 6
EDDY, DARRYL G 7
HUGHES, DONALD R 7
MORRELL, ROBERT A 7
REYNOLDS, TIMOTHY A 9
MESSENGER, ROBERT 10
How can i get the values of Full name based on "hissuper" for example
supervisor for row 2 is 1=Davis Robert K,like wise i want for all the values.
Thank you for any help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only