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 help
Must 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.
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. TIA
Spin 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 helpConditional 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, Somnath6309
Version 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?
Online 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.logical 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 pleaseSetting 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?)
