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 each …

Feb 11, 2011 · rounding calculated numbers in Excel Using the ROUNDUP function or any other means, is there a way to round a calculated number in cell to the nearest nickel $0.05? Ie. take a price in US …

Mar 27, 2017 · Using IF function in Data Validation I am currently modifying a worksheet that I made in LibreCalc so that it works in Excel, and as such I encounter small problems every now and then.

Aug 18, 2024 · Hi there. I am trying to find the minimum difference between two sets of numbers, but am having problems with the formula not ignoring blank cells... My current formula is =MIN(B2:B10 …

Oct 22, 2024 · Hi everyone, We are tracking all of the staff training and we want to create some highlight cell rules. I can only find formulas that calculate with the =TODAY function and im not sure if this is …

Dec 9, 2013 · In Excel 2013 I am trying to input a "days" function which will return the number of days between to dates. I've been trying to use the "days" function which is in the drop down menu under …

Jan 31, 2012 · Automatic Ordinals in Excel 2010+ I have to admit that I am a little stunned that Microsoft has never included Ordinal-formatting this as a format option in Excel-x, let alone Excel 2010. It …

Nov 30, 2019 · But, my problem is not related to the data. "My" Excel cannot sort any data, not even a very simple table. There is also a problem in auto-filling. If I try to fill some serie in a column by …

How to get th MS Excell Macro to output correct DMS values with negative Decimal Degree values?

Jul 29, 2019 · When I use the Sum function in Excel for one cell I can no longer copy this formula to another cell; I have always been able to copy functions before today. How do I fix