CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
icy
icy

Reputation: 934

Google Sheets filter view -- sort string before number

Text

Hi, I have this sample data of cast times for a game (Instant, 1.0, 2.0, 6.0 etc). I'm trying to make a filter view just to sort (not exclude) -- "Instant" first, and the rest ascending. So looking for

Instant
Instant
1.0
1.0
2.0
2.0
6.0

Tried a bunch of variations but I'm either getting no results or just Instant

=regexmatch(D:D,"Instant|\d\.\d") <-- the "or" did nothing? Gave me "Instant" rows

thanks

Upvotes: 1

Views: 187

Answers (1)

player0
player0

Reputation: 1

you will need a helper column with formula on first row:

={""; ARRAYFORMULA(IF(D2:D="",,IF(D2:D="Instant", 0.5, D2:D)))}

(you can set the font color to white)

enter image description here

demo sheet

Upvotes: 1

Related Questions