Contabilitate și nu numai ...

Auxiliary menu for Microsoft Excel ( 23.03.2025 ) New in version 23.03.2025: - change color and formatting, as appropriate, for text fragments in cells; - IMAGE_UDF function – imports images from URL; The IMAGE_UDF function may have some functionality limitations in Microsoft Excel 2010. - change of menu appearance; - information about the menu; - improvement Calendar date correction ; - corrections and improvements to Number to text conversion ; - improvement Change to upper/lower case ; - improvement Measurement unit correction ; - guide revision. New in version 20.01.2025: -  restoring the download link for this kit; - changing the appearance of the menu. New in version 27.11.2024: - a new function; the REMOVEDIACRITICS function deletes the diacritics from the reference cell.  This function applies to characters with diacritics related to the languages: Romani...

How to find the first occurrence of a desired item, searching from bottom to top in Excel When working with large datasets in Excel, there are times when you need to find the first occurrence of a specific value, but starting the search from the bottom up. This technique is useful when your data is organized chronologically or in a way where the most recent entries are the most relevant. In this article, we’ll explore several methods to achieve this, including Excel formulas and a custom VBA function. Methods to find the first occurrence from bottom to top 1. Using INDEX and MATCH Formula: =INDEX($B$6:$B$15, MATCH(2, 1/($A$6:$A$15=$E$3)) This formula uses the INDEX and  MATCH  functions to find the last occurrence of the value in E3 in column A, then returns the corresponding value from column B. 2. Using XLOOKUP Formula: =XLOOKUP($E$3, $A$6:$A$15, $B$6:$B$1...