Current location - Loan Platform Complete Network - Big data management - EXCEL a unique value corresponding to a number of data, screening out the unique value of the largest data and sum (the database is often huge).
EXCEL a unique value corresponding to a number of data, screening out the unique value of the largest data and sum (the database is often huge).
Assuming that your data source in sheet1, the target location in sheet2, first of all, do a little advanced screening:

Choose "copy the results of screening to other locations"

List of areas: sheet1!a:b

Conditional areas: randomly point to a blank cell

Copy to: sheet2!a1

Check "Select non-repeating records"

OK

Then fill in c2 in sheet2

=SUMIF(sheet1!A:A,A2,sheet1! !C:C)

Fill down

Fill in d2 of sheet2

=MAX(IF(sheet1!A:A=A2,sheet1!D:D))

Press Ctrl+Shift+Enter at the same time

Fill down

Related articles
  • Bed brand top ten ranking list is how?
  • Taobao super recommended how to use the effect will be good?
  • How often should I clean my car's water tank? How to clean?
  • Please ask Shijiazhuang where there is a professional airbag computer programming?
  • Blind date rejected? Because the sesame credit score is too low!
  • What's the job like in the IT industry? Is it stable?
  • How's the Employment and Entrepreneurship Promotion Center?
  • Why would the old family check a person's big data
  • County-level big data work concept
  • Four catastrophes in the history of Buddhism's development in the Central Plains

    • copyright 2024 Loan Platform Complete Network All rights reserved