Sorting and priority

Hi, I’ve been trying to figure out a reasonably simple solution to a sorting issue I’ve been having and wondered if anyone can help point me in the right direction? My searches have been informative, but I haven’t been able to get any solution to work properly (and I’m not sure which method I should be using).

  • I have a very simple spreadsheet with a header in the first row and then data.
  • There are two columns, the first column has an identity (text), the second column has a value (number).
  • I want to display the identity, or identities, of the row(s) which has(have) the lowest (or equal lowest) number in column B in a separate cell.
  • I’d like to be able to manually change the numbers in column B and have the cell which shows the identity (identities), automatically update if this is possible?

It’s extremely unlikely there will ever be more than 10 identities which have a value which is equally the lowest.

I’ve tried to use rank, vlookup, and small… But all I get is errors and confusion on my part. I’d be very grateful if anyone could suggest an alternative, or point me in the direction of any examples which achieve the same thing!

Thanks

I am sure there is a better option; meantime:
C1: =IF(B1=MIN(B1:B7);A1;""), fill down
D1: =TEXTJOIN(", ";1;C1:C7)
imagen
IF_TEXTJOIN.ods (9.4 KB)