×
Angličtina
Ľutujeme, tento článok nie je dostupný vo vašom jazyku.

Speedy lookups

Monitor showing a worksheet with a speedometer in the lower right corner

Have you ever used VLOOKUP, HLOOKUP, or MATCH to find an exact match in unsorted data? If so, you might have noticed that it took a little while. However, in this update of Excel, you'll notice these calculations are noticeably faster.

For example, in a previous version of Excel, we found five VLOOKUP formulas that took 37 seconds to calculate. But in this update, the same calculation took only take 12 seconds. That's approximately a 67% reduction in calculation time!

There are other performance improvements in this update as well. Read more about these improvements here.

Rozšírte svoje zručnosti práce s balíkom Office
Preskúmať školenie
Buďte medzi prvými, ktorí získajú nové funkcie
Pridajte sa k insiderom pre Office

Boli tieto informácie užitočné?

Ďakujeme za vaše pripomienky!

Ďakujeme vám za pripomienky. Pravdepodobne vám pomôže, ak vás spojíme s pracovníkom podpory pre Office.

×