Wps's method of selecting the same number at the end

How does wps choose the same number at the end? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

How does wps choose the same number at the end?

If you filter data for which the Mantissa of column B is a certain number.

Add a secondary column C column, enter the following formula in it, and then fill the formula down

=-- RIGHT (B1)

Then select column C, filter, and you can.

Thank you for reading! After reading the above, do you have a general idea of wps's method of selecting the same number at the end? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.