Absolute Reference Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/absolute-reference/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:31:21 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Absolute Reference Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/absolute-reference/ 32 32 How to Use Excel Conditional Formatting with Formulas https://www.xelplus.com/excel-conditional-formatting-rows/ Thu, 03 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=10404 Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows. I also share the secret to get it right every time.

The post How to Use Excel Conditional Formatting with Formulas appeared first on Xelplus - Leila Gharani.

]]> How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? https://www.xelplus.com/excel-cell-references/ Sat, 01 Feb 2020 14:35:00 +0000 https://www.xelplus.com/?p=11502 Properly referencing a cell is THE most important rule you need to master in Excel. Should the reference be relative, absolute or mixed? I explain it all in this quick article.

The post How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? appeared first on Xelplus - Leila Gharani.

]]> Excel VBA to Copy Data from one Sheet to Another https://www.xelplus.com/excel-vba-to-copy-data-from-one-sheet-to-another/ Thu, 29 Mar 2018 13:26:00 +0000 https://www.xelplus.com/?p=10999 See how you can use the macro recorder to copy data from one Worksheet to another sheet, appending data from two tabs. Also, learn how to insert a button and assign the macro to it.

The post Excel VBA to Copy Data from one Sheet to Another appeared first on Xelplus - Leila Gharani.

]]> Find Multiple Matches in Excel & Create a Dependent Drop Down List https://www.xelplus.com/find-multiple-matches-in-excel-dependent-drop-down-list/ Thu, 15 Mar 2018 10:38:00 +0000 https://www.xelplus.com/?p=11023 In this tutorial, we will create a dependent drop-down list based on a messy Excel Table. For that purpose, we will extract all records for each category using the combination of INDEX and AGGREGATE. Next, we will fix the column referencing in the table. Finally, we will use a combination of OFFSET and COUNTIF to get a drop-down list restricted to non-empty cells.

The post Find Multiple Matches in Excel & Create a Dependent Drop Down List appeared first on Xelplus - Leila Gharani.

]]>