Tag Info

New answers tagged


I had a go at the most frequent value. Not sure if it would work in libreOffice, but it seems to work in excel =INDEX($B$2:$B$9,MATCH(MAX(--($A$2:$A$9=D2)*COUNTIFS($B$2:$B$9,$B$2:$B$9,$A$2:$A$9,D2)),--($A$2:$A$9=D2)*COUNTIFS($B$2:$B$9,$B$2:$B$9,$A$2:$A$9,D2),0)) Column A would be the payee, column B would be the category, D2 is the payee you want to ...


You can use an array formula to get data from the last matching record. =INDEX(IF($A$1:$A$20="c",$B$1:$B$20),MAX(IF($A$1:$A$20="c",ROW($A$1:$A$20)))) Enter the formula using Ctrl+Shift+Enter. This works like the INDEX/MATCH construction of a VLOOKUP, but with a conditional MAX used instead of MATCH. Note that this assumes that your table starts at row ...

Top 50 recent answers are included