Calculer les coordonnées des dernières cellules avec Excel

✔ Excel workbook and detailed training on the website: https://www.bonbache.fr/calculer-les-... Excel tips for identifying the last column and row of a table, as well as for locating the last numerical value or the last text entry. Our initial steps take shape using a table of used vehicles. Its width and height can vary. We determine the positions of the first and last columns using the MIN, COLUMN, and COLUMN functions. Using the ADDRESS function, we can retrieve the letter of the last occupied column. We apply this principle to find the coordinates of the very last cell in the table using the ADDRESS function. Finally, an approximate search triggered by the MATCH function on Big Data allows us to identify the references of the last text and numbers in the Excel table. #ExcelTraining #LearnExcel #ExcelTips #ExcelCalculations Remember to subscribe to the channel: ❤    / @formationsexcelaccessetbiendau   Don't forget to click the little bell 🔔 so you don't miss any new videos. 👀 All Excel tips and tricks:    • Astuces Excel   👀 All videos on matrix calculations with Excel:    • Formation Calculs Matriciels Excel   📚 Find the complete book on Excel exercises: https://www.bonbache.fr/livres-excel-... 📚 Find the complete book on matrix calculations with Excel : https://www.bonbache.fr/livres-excel-... =============================================== 📑 CONTENTS: 00:00 Coordinates of the last cells - Demonstration 00:36 Excel workbook to download 01:49 Detect the last column 06:15 Detect the last cell 08:58 Detect the last number 11:01 Detect the last text ============================================