takes the two smallest values

Tried to open your file on a Windows laptop and an iPad. Both report that the file cannot be opened.

I also encountered the same issue, but I was able to open it with WPS Office for Android. What seems to be the problem in opening the file?

So what should happen if there are two smallest values - which corresponding value from row 2 should be returned?

The workbook is reporting as invalid or corrupted - it can't be opened. If you encountered the same issue yourself, then you know what the problem is. You can't expect members to get WPS in order to be able to assist!

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

So you want ALL of the matching values?

What product are you using for this? That's really important. Is it Excel or GoogleSheets or WPS - what?

Does row 5 here show the outcome you want? If not, then WHAT do you want instead?

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	B	C	D	E	F	G	H	I	J	K
2	0	1	2	3	4	5	6	7	8	9
3	1	2	1	3	2	2	1	3	7	6
4
5	0	2	6

Sheet: Sheet1

OK - the formula is this:

=FILTER(B2:K2,B3:K3=SMALL(B3:K3,1))

and it works in GoogleSheets:

https://docs.google.com/spreadsheets...it?usp=sharing

Please change your forum profile from 2020 to GoogleSheets Mobile ASAP.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Pldeaes update your profile before you leave.

Please remove ASAP - that means as soon as possible! ;

Thanks for the rep.

Or maybe this:

Formula:

Please Login or Register  to view this content.