More pending issues>>

put questions to

How to filter data in one column smaller than that in another column by excel filtering

Reported answer
How to filter data in one column smaller than that in another column by excel filtering
Ask online customer service
Scan the code to ask online customer service

  • Number of answers

    four

  • Number of browses

    10,041

answer

4 answers Default sorting
  • Default sorting
  • Sort by time

xiangcon

Adopted
As shown in the figure below, filter data 2 smaller than data 1, and use an auxiliary column, C2 formula=B2A2 drop-down formula,

Select the data area, click Data - Filter on the toolbar, select only TRUE from the filter drop-down arrow of the auxiliary column, and then click OK.

Get results
comment
cancel comment

baidu_fengdesi_

First, I'll give you an emergency answer. I'll send you other methods when I think of them

After filtering the data, add a column of numbers to the blank, such as 1, 2, 3, 4

In the new table, insert a column, and also use 1, 2, 3, 4

It's easy to do next, just go to vlookup

I have to think about other methods. I haven't noticed the problem before --#
comment
cancel comment

clsen

Select Filter by Color.
comment
cancel comment

bscom88

Nah
comment
cancel comment

Latest answers more >

ZOL Q&A > How to filter data in one column smaller than that in another column by excel filtering

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