Forum Widgets
Latest Discussions
Count cells with numbers and text but only want cells with number counted
My statistics record of our flighted golf league, records scores and letter entries for did-not-finish, absent and absent with substitute. I want to count the number of player who played, by using their scores but not include any text entries. The count total cell is: =COUNT(H6,H9,H12,H15,H18,H21,H24,H27,H30,H33). If H9 and H24 did not play an "X" is entered. Formatting all cells as Numbers will still count the "X" in the total. TIADaveHillJul 16, 2025Copper Contributor51Views0likes2CommentsConditional Formatting Rules for Icon Sets
Hi, The following pivot table has been created using Conditional formatting Icon Sets : However, the Default Formatting Rule applied by Excel is not understood. Following is the screen shot of Formatting Rules: Under the Formatting Rule Section: 01. The Green Icon is applicable when the value is >= 67 % 02. The Yellow Icon is applicable when value is < 67 % but >= 33% 03. The Red Icon is applicable when the value is less than 33%. The above Rule is clear but in my following pivot table data I have not achieved 67% or 33% of Total Revenue. Pls take a look of the screen shot : In Column E , Sales_Amount / Grand Total does not achieve 66% or 33%. All values are less than 33%. But Icons in Col B are appearing in Red, Green and Yellow. Pls let me know what is the logic behind the application of Icon Sets in Col B (Sum of Sales Amount). However, Same Default Formatting Rule is applied in Col D (Sum of Dollar per Hour). Pls see the screen shot below: However, it is not clear on which amount 67% and 33% are getting calculated. In Pivot Table CALIFORNIA has Dolloar Per Hour ( Sales Amount / Contracted Hours) 68.30 and it is getting Yellow Icon. Pls let us know the logic / Calculation of : 67% and 33% for Dollar per Hour. I have also attached the Excel file for reference. Regards, Somnath6309somnath6309Jul 16, 2025Copper Contributor36Views0likes2CommentsVersion History Empty
I use to use the feature https://support.microsoft.com/pt-br/office/restaurar-uma-vers%C3%A3o-anterior-de-um-arquivo-do-excel-89c09b39-8f01-456e-82be-5d89f371436a to recover old versions of my files. But today, when I went to recover a June 30th version of an Excel file, the versions table is empty. Is there any other way to recover old versions? This empty table is an application bug?MC11Jul 16, 2025Copper Contributor39Views0likes3CommentsShift-F2 in Excel 2025 does NOT go into edit mode as expected
I have a workbook which I have very comments in it. In Excel 2013 on the old computer, whenever I pressed "Shift-F2", it would go into edit mode with the cursor in it. Now that I am in Excel 2025 (Desktop version as I refuse to become a renter of MS with it's 365 product regardless how hard they push and disable certain functions such as the "STOCKHISTORY" function will NOT work in desktop version of Excel, only in 365 version as MS wants everyone to rent from them so as they have that continuous stream of income with them getting a third or more of the product total cost annually, which when I build my systems, the systems are expected to last a minimum of 5 years and possibly up to 10 years. Yeah, yeah, many people say they are outdated within 18 months, but when I build the systems, the specs are high enough the system doesn't become obsolete that quick. Why then would I want to pay 1/3 of the product price annually when I can pay for the total product just once for a minimum of a 10 year time frame? Rarely is there much of a difference from one version to the next version, so I don't see the point in it.) Anyhow, all the Shift-F2 does is show the comment. I have to actually click into the comment to go into edit mode with Excel 2025 vs. with Excel 2013, I didn't have to do that. I could instantly use my keyboard to edit the comment. I hate the idea of constant switching back and forth between the keyboard and mouse. That's because as those in data entry knows, that is wasted time when you have to constantly be switching between the keyboard and mouse to get things done.DodgesterJul 16, 2025Occasional Reader27Views0likes1CommentExcel ran out of resources
Hi I am facing an issue with excel for Mac version 16.98, I am continuously getting message "Excel ran out of resources while attempting to calculate one or more formulas", when I delete the cell and type the formula again it is working and displaying the results, however when I try to close the file I am again getting the same message and the data gets changed to "Cal!" or Spill etc.... Can anyone support to resolve this issue Regards RamseshRameshYedhulaJul 16, 2025Copper Contributor29Views0likes2Commentsconditional flashing cells
Hello. I would like to make a cell flash if a certain condition is met, ie a value higher than another value. I can find instructions to make a flashing style, but I can't see a way to use this in conditional formatting. Is it possible?knmcbrideJul 16, 2025Copper Contributor28Views0likes1CommentDefault Date Format refuses to use system regional settings
There are lots of forum questions about date format - this might be answered somewhere, but it's too deep to find the answer. I have Excel from Microsoft 365, installed on my Windows 10 computer. Excel says it's version 2506. I have the regional settings on my computer set to US: Notice the date formats. When I open a new workbook in Excel, and type a date, if I don't include the year, it immediately converts it to a European format. I type 7/15, and it converts it 15-Jul: How do I correct this behavior? I typed it the way I want it. My system is set up to use MM/DD. But I have to change the column format to MM/DD to get Excel to use that.kjmcJul 15, 2025Occasional Reader29Views0likes1Commentlogical function
I have tried building a logical function that can help me calculate the exact values in the Score column. This can help me calculate for large data. values under the score section are the criteria that is reach if any of the conditions under the 6 disability domains is met. I need help pleasecnoah92Jul 15, 2025Copper Contributor95Views0likes4CommentsConditionally Fill a Cell Based on Row/Cell Count
I am trying to conditionally fill/highlight a cell in column A, based on the number of rows to count to get to it... For example: Adding to a cell just adds to the cell's value, so it's likely it's some kind of add-to-row-count kind of function? Anyone have any suggestions on how to go about accomplishing this? Thank you, KristineKristine2021Jul 15, 2025Copper Contributor32Views0likes3Comments
Resources
Tags
- excel42,919 Topics
- Formulas and Functions24,899 Topics
- Macros and VBA6,452 Topics
- office 3656,104 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,405 Topics
- Excel for web1,943 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics