Microsoft Excel

Excel 3D Reference - easily reference data on another worksheet

Chris Menard

15 May 2023 — 1 min read

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

Excel 3D reference

Excel 3D reference

You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count, Counta, Max, and Min all work with a 3D reference.

Examples of 3D references

1. In cell R2 we can use a 3D reference for =B2. Changes in B2 will reflect in cell R2l. 2. =Monday!B2 reference the Monday worksheet. Changes in cell B2 on the Monday worksheet will update when the source updates. 3. =Sum(East:West!B2) changes in the worksheets that start with East and go to West for cell B2 will reflect. We could have multiple worksheets between the East and West worksheets.

YouTube Video

Excel 3D Reference - easily reference data on another worksheet

Video of 3D references using multiple worksheets

Excel how to use a 3D reference to add worksheets by Chris Menard - YouTube

Read more

Count Unique Values in Excel with UNIQUE, SORT, and COUNTIF Functions Tutorial

Table of Contents * 📋 Why this method works and when I use it * 📋 Setting up the table * 🔎 Extract distinct values with UNIQUE * ↕️ Sort the unique list with SORT * 🔢 Count occurrences using COUNTIF * ✅ Why tables beat ranges for this task * 🔁 When to use this instead of a pivot table * 🔧 Quick checklist to

Financial Ratios - Formula Completion in Excel using Copilot

Financial Ratios - Formula Completion in Excel using Copilot

Writing formulas in Excel can be time-consuming and challenging, even for experienced users. Selecting the right function, referencing the correct cells, and ensuring proper syntax often slows down workflows and leads to errors. Many users spend extra time troubleshooting mistakes, searching for examples, or trying to recall the exact formula

Excel Formula Completion - Using XLOOKUP

Excel Formula Completion - Using XLOOKUP

I tested how well Excel's formula completion with Copilot handles a multi-step calculation that would normally require a nested function. The goal was simple: calculate profit by subtracting the total cost of units sold from total revenue, with unit costs stored in a separate lookup table. Instead of

Copilot in Teams Meetings without Transcription: Use AI While Respecting Privacy

Copilot in Teams Meetings without Transcription: Use AI While Respecting Privacy

Microsoft Teams has a great Copilot feature. A Microsoft 365 license is required for this feature. In a Teams meeting, I need AI assistance during a conversation, but the participants do not want the call recorded or transcribed. There are plenty of situations where privacy matters: a vendor asks for