More pending issues>>

put questions to

How does Excel find the two closest numbers to a certain data in a group of data?

Reported answer
How does Excel find the two closest numbers to a certain data in a group of data?
Ask online customer service
Scan the code to ask online customer service

  • Number of answers

    three

  • Number of browses

    five hundred and eighty-three

answer

3 answers Default sorting
  • Default sorting
  • Sort by time

dssrzcmtpkfz

Adopted
The maximum value formula less than or equal to 5.4=MAX (IF (A1: A8=5.4, A1: A8))
Minimum value formula greater than or equal to 5.4=MIN (IF (A1: A8=5.4, A1: A8))
For array formula, Ctrl+Shift+Enter is used to end the formula. Normal operation can only be performed after the curly braces {} are generated before and after the formula. As shown in the figure:
comment
cancel comment

xtajeamd

Can the original data be processed? Add auxiliary columns or cannot move the original data?
comment
cancel comment

qinghan

If the data is in ascending order, use VlookUp to find it.
comment
cancel comment

Latest answers more >

ZOL Q&A > How does Excel find the two closest numbers to a certain data in a group of data?

Top mobile phone rankings

See more rankings>

report

Thank you for contributing to the harmony of the community. Please select the type of report

Advertising content Reactionary speech Pornographic content Other illegal contents

Reported successfully

It will be handled after verification
Thank you for your contribution to community harmony

Scan the code to participate in the trial of new products at 0 yuan
You can get the sheets and grand gifts on the top floor

Scan and pay attention to us
Tips

Are you sure you want to cancel this registration and exit this activity?

determine cancel