I am looking for a ="" formula that accounts for a few different things.
I have a spreadsheet that will always have AUS in A29 and may display a corresponding time in B29. B29 has a formula that may display a blank cell if certain criteria are met.
There may be dozens of other instances of AUS in column A, and if so, these will always have a corresponding time in column B. B29 is the only one that may not have a time - if there are other instances of AUS in column A, there will always be a time in column B. It's also possible that A29 is the only instance of AUS.
I'm need a minimum formula (in B2) that will find the quickest time from column B where there is AUS in column A, but it needs to display a blank cell if B29 = "" and that's the only instance of AUS, or it will otherwise have to display the quickest time.
Hope this makes sense
Any help would be greatly appreciated.
I have a spreadsheet that will always have AUS in A29 and may display a corresponding time in B29. B29 has a formula that may display a blank cell if certain criteria are met.
There may be dozens of other instances of AUS in column A, and if so, these will always have a corresponding time in column B. B29 is the only one that may not have a time - if there are other instances of AUS in column A, there will always be a time in column B. It's also possible that A29 is the only instance of AUS.
I'm need a minimum formula (in B2) that will find the quickest time from column B where there is AUS in column A, but it needs to display a blank cell if B29 = "" and that's the only instance of AUS, or it will otherwise have to display the quickest time.
Hope this makes sense
Any help would be greatly appreciated.