u/oubuob

Functions that check the first instance of some text
▲ 3 r/sheets+1 crossposts

Functions that check the first instance of some text

So I'm creating a GPA calculator and my college doesn't count the first instance of an F in a given class towards your GPA. I was wonder if there is either a function that can tell if something is the first instance of text, or a function that can identify which cell has certain text and name it (like if D2 has "F." then it would say "D2"), which would allow me to brute force the issue?
Sample Version: https://docs.google.com/spreadsheets/d/1k9FNMW8Ud9slBW1816ZtWyUDSSJ6qzaWdc9TPpFeT_c/edit?gid=2100307022#gid=2100307022

u/oubuob — 12 days ago