Sep 9, 2014 · I used the Data Model to create a Pivot table (ticking add to Data Model on creation) using the data model data sources (the pivot table combined details from a couple of …

Nov 28, 2018 · Consolidate works for one worksheet but does not work on the other. Not trying to consolidate both sheets. Each sheet contains unique data. Trying to consolidate the data from …

Jul 10, 2025 · Here, I have a column for reference ID & expiry date, can conditional formatting work if I have to highlight expiries with today's date with reference ID.

Oct 14, 2021 · As far as I know, too much circular reference in Excel is not recommended as it may cause calculation problem. And there is no official article mentioning about if old computer …

Mar 12, 2024 · Thanks for the speedy reply! I've attached two documents here, the first is the template that is being completed by x amount of people and then returned to us. The second …

Feb 16, 2021 · VBA Code Worksheet Deactivate issue with resorting table upon exit I posted a different code a few days ago for the same issue but different coding, but I gave up on that …

May 14, 2025 · Hello, I'm a user who is using an Excel program. I'm just a user who is using an Excel file in Sinology When using Excel data of 1.27MB in the file format ".xlsb", it is common …

Jun 15, 2023 · I pasted an Excel object on Word, I got a description of the link but not the excel table. This abnormality suddenly occured and I don't have a clue. I no longer be able to copy …

Jan 30, 2024 · JW Jarrad Winman Created on January 30, 2024 Excel formula to sum the product of multiple rows with two criteria

Sep 25, 2023 · i am trying to add an hyphen to a cell and i only want it to show up when there is an actuel number in the cell, as there are other formulas attached to the cell and will affect …