Forum Widgets
Latest Discussions
Auto-fill not working
Hi. I am trying to fill a series of dates in excel to advance weekly but when I use the drag handle at the bottom of the cell it keeps the same dates but changes the year. Where there used to be autofill options offered im only getting a dialogue box with formatting/chart/totals/ tables none of which helps me format autofill. I have autofill option turned on. The file is saved to my onedrive folder on my computer Thanks in advance for helpJimJonesJul 16, 2025Occasional Reader19Views0likes1CommentMust Go Faster
I work in Sales. Every week I have to create an availability for our customers based off of our Availability. Our availability has multiple duplicates. I know how to highlight the duplicates. What I would like to do is run a formula for selecting 1 of the duplicates based on criteria from a different column. For Example A387-A392 are all 1gal Boxwood. I have to manually compare each row by column so that I only have 1 row left. Manually I would select Row 390 based on rooting, size, counted, and date last. I have tried IFAND, COUNTIFS, but I keep coming up with errors. Any help is appreciated.KttheplantladyJul 16, 2025Copper Contributor40Views0likes1CommentCount 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 Contributor65Views0likes2CommentsSpin Control only increments
I have a sheet that I use for tracking statistics. Each cell contains a simple number with 0 decimal places. I have added a spin controls in my sheet to simply increment and decrement the value of a field by 1. As I have added and tested the spin controls, I have found that many of them will only increment the field, not decrement the value. Both the up and down buttons are visible, but when clicking the down arrow in the control, the field is incremented improperly. Thanks for the helprickgouseJul 16, 2025Copper Contributor7.8KViews4likes17CommentsConditional 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 Contributor47Views0likes2CommentsVersion 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 Contributor40Views0likes4CommentsOnline Word Doc Problem
Hi. Recently I noticed my online word doc in Edge is displaying in Russian, despite all settings everywhere are English. I restarted Edge, laptop, Word docs etc. Nothing changing this issue and nowhere Russian to be found in settings. What can I do to change it? I am using a work laptop, so a lot of settings are not available as my laptop is managed by my organisation. Please help, this is frustrating! I tried everting, googled all answers and possible questions. Nothing helps.DashaCJul 16, 2025Occasional Reader6Views0likes0Commentslogical 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 16, 2025Copper Contributor102Views0likes5CommentsSetting Cell type format as V or L
I have an XLS that's been produced using python and two columns with dates in. Although the cell format is set to Date my upload to another system fails, investigation has found that this is because the cell 'type' is set to 'l' rather than 'v'. I've found a work around using the Text to Columns function but without using cell("type",A1) formula I wouldn't have found this. So two questions really Is there a way to easily identify / set the cell type in excel without adding in the type formula and using Text to Columns to copy and paste Is there a python command that would force this type to value rather than label? (We'll be moving the system to Java in the future so will this likely do the same thing?)orangeblossJul 16, 2025Occasional Reader8Views0likes0Comments
Resources
Tags
- excel42,922 Topics
- Formulas and Functions24,901 Topics
- Macros and VBA6,452 Topics
- office 3656,105 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,406 Topics
- Excel for web1,943 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics