Make Office Better
Top tips for the best office programs
LIBREOFFICE CALC & MICROSOFT EXCEL
Use the XMATCH function to find item positions
LibreOffice 24.8, released in August, added the XMATCH function to Calc, making it a more credible alternative to Excel. At its simplest XMATCH lets you find the position of a specific item within a range of cells. But you can perform more complex tasks, such as in our example where we’re finding out how many pub quiz teams have scored above 100. In cell C2 we type 100 ( 1 in our screenshot), then click C3 and type =XMATCH(C2,B2:B21,1) 2 .