31 views
Part Two 1. Combining the Index & Match functions for reports where we want to search and return data simultaneously in rows and columns of the report based on 2 conditions and without restrictions 2. Combining the Mid & Find functions to extract and separate part of a cell text string after the desired text or number. 3. The Subtotal function to perform the sum and count of data only in the filtered range. 4. Another useful function, comment on the number of friends. #Excel #Excel #Learning #AdvancedExcel #Exceltips #ExcelAccounting #Exceltricks #Accounting #Microsoft #Formula #Accountant