SOLVED

Excel: Condensing and Counting

%3CLINGO-SUB%20id%3D%22lingo-sub-1261430%22%20slang%3D%22en-US%22%3EExcel%3A%20Condensing%20and%20Counting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1261430%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20the%20left%20is%20a%20table%20documenting%20individual%20plants%20of%20a%20single%20species%20(B)%20in%20different%20plots.%26nbsp%3B%20There%20is%20also%20a%20Type%20designation%20for%20each%20plot.%26nbsp%3B%20I%20would%20like%20to%20create%20a%20new%20table%20which%20lists%20each%20plot%20just%20once%20along%20with%20the%20number%20of%20plants%20found%20in%20each%20plot%20and%20the%20Type%20designation%20for%20the%20plot.%26nbsp%3B%20Suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22448%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3EPLOT%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESPECIES%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ETYPE%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EMASTERID%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ENO.%20B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EVEG88%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E8%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E8%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E10%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E10%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E13%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E11%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E14%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E11%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E11%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E13%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E13%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E13%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E13%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E13%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E14%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E14%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E14%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3E15%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1261430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1261500%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Condensing%20and%20Counting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1261500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599249%22%20target%3D%22_blank%22%3E%40MADavis%3C%2FA%3E%26nbsp%3BThat%20could%20be%20SUMIF%20and%20VLOOKUP%20as%20in%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1261517%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Condensing%20and%20Counting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1261517%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599249%22%20target%3D%22_blank%22%3E%40MADavis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPivotTable%20will%20work%2C%20especially%20if%20TYPE%20are%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262577%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Condensing%20and%20Counting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262577%22%20slang%3D%22en-US%22%3EThanks%2C%20very%20much.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262581%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3A%20Condensing%20and%20Counting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262581%22%20slang%3D%22en-US%22%3EThanks%20very%20much%2C%20especially%20for%20the%20VLOOKUP%20suggestion.%20This%20worked%20great%20on%20my%2010%2C000%20row%20file.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

On the left is a table documenting individual plants of a single species (B) in different plots.  There is also a Type designation for each plot.  I would like to create a new table which lists each plot just once along with the number of plants found in each plot and the Type designation for the plot.  Suggestions?

 

PLOTSPECIESTYPE MASTERIDNO. BVEG88
8B3 823
8B3 1022
10B2 1134
10B2 1353
11B4 1432
11B4 1511
11B4    
13B3    
13B3    
13B3    
13B3    
13B3    
14B2    
14B2    
14B2    
15B1    
4 Replies
Highlighted
Best Response confirmed by MADavis (New Contributor)
Solution

@MADavis That could be SUMIF and VLOOKUP as in the attached file.

 

 

Highlighted

@MADavis 

PivotTable will work, especially if TYPE are numbers.

Highlighted
Thanks, very much.
Highlighted
Thanks very much, especially for the VLOOKUP suggestion. This worked great on my 10,000 row file.