I have a google sheet which is collecting data from a site which users are bidding on certain prizes.
In the screen shot above, lot 1 has 3 bids. I’d like to know how to add the highest bid (£60) in the Current Highest bid column and update when a new high bid comes in?
Many thanks
I know about Maximum: The maximum value is the largest value in the dataset, or the value that all other values in the dataset are less than or equal to - But I need to auto update based on a new high bid on a certain lot, can this be done?
You may try:
=map(unique(filter(regexextract(E2:E,"^.*? - "),E2:E<>"")),lambda(Σ, Σ&maxifs(F:F,index(--regexmatch(E:E,Σ)),1)))