Globe Trotter Medic
New Member
- Joined
- Sep 25, 2018
- Messages
- 2
I am new to the forum and new to Excel.
Work book contains 2 sheets,
Sheet 1
Column C, beginning at C2 contains names, that may or may not duplicate,
Column D, beginning at D2 contains Company names, that may or may not duplicate,
Jumping over to Column J, J2 contains a numerical value.
Sheet 2,
I want to have Column B, starting at B2, list the names from Sheet 1 without duplicates, Alphabetical Order, and auto populate as Sheet 1 is manually populated
Column C, starting at C2 list the company name from Sheet 1 Column D that corresponds to the individuals name,
Column D, starting at D2, have the sum of numerical values that correspond to the individual.
Currently on Sheet 2, B2, I have
=IFERROR(LOOKUP(2,1/(COUNTIF($B$1:B1,RECORDS!$C$2:$C$1999)=0),RECORDS!$C$2:$C$1999),"")
I now have "0" in B2 and the Individual names (NOT alphabetized) in subsequent cells of Column B.
Work book contains 2 sheets,
Sheet 1
Column C, beginning at C2 contains names, that may or may not duplicate,
Column D, beginning at D2 contains Company names, that may or may not duplicate,
Jumping over to Column J, J2 contains a numerical value.
Sheet 2,
I want to have Column B, starting at B2, list the names from Sheet 1 without duplicates, Alphabetical Order, and auto populate as Sheet 1 is manually populated
Column C, starting at C2 list the company name from Sheet 1 Column D that corresponds to the individuals name,
Column D, starting at D2, have the sum of numerical values that correspond to the individual.
Currently on Sheet 2, B2, I have
=IFERROR(LOOKUP(2,1/(COUNTIF($B$1:B1,RECORDS!$C$2:$C$1999)=0),RECORDS!$C$2:$C$1999),"")
I now have "0" in B2 and the Individual names (NOT alphabetized) in subsequent cells of Column B.