Forum Widgets
Latest Discussions
UNIQUE table
Hi, Might be beginner question but i have a list of names from where i extract unique information with =UNIQUE command to a different sheet. But the problem is when i change the original lists sorting or filtering it changes the unique operators list order also which messes up with my sheet2. Question is how do i lock the rows together or fix the whole operation. Thanks in advance and sorry for dumb question. Starting point img After changing sorting imgLeeviFeb 10, 2025Occasional Reader8Views0likes2Comments"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THISPREETFeb 10, 2025Copper Contributor22Views0likes1CommentSorting dates in Excel from oldest to newest is not working
Hi all, I would like to sort a date series in Excel, formatted as Mon Feb. 10, 2025 08:59 AM, from oldest to newest, but I can’t get it to work. Every week, I have to download a list from a program that uses this date format (see screenshot). I want to sort it in order from oldest to newest, but when I try to do so, the dates get mixed up. Downloaded list: 2. I select the cells and want to order it from old to new, then it gives me this: Does anybody has a solution for this? Thanks so much in advance! ArianneArianneCFeb 10, 2025Occasional Reader17Views0likes2CommentsCheckbox and countif
Hi everyone, I'm experiencing an issue with checkboxes in Excel Online. I have a table where I use checkboxes (TRUE/FALSE) in five rows, and below them, I use the following formula to count how many checkboxes are checked: =COUNTIF(F1:F5,TRUE) However, when I check a box, the counter briefly updates (e.g., from 0 to 1 if only one box is checked) but then immediately resets back to 0 within a second, as if the checkbox is being unchecked in the background. This behavior does not occur in the offline (desktop) version of Excel, where everything works as expected. Additionally, after reloading the page, sometimes the checkboxes reset to an unchecked state, and other times the counter updates correctly. Is there a known issue with checkboxes in Excel Online, or is there a setting I might have misconfigured? Any advice would be greatly appreciated! Thanks in advance.MichalPavFeb 10, 2025Copper Contributor23Views0likes1CommentHelp creating a custom table in a template
Hi! I'm cannot get formatting a custom table to work. I would really appreciate some help. I have started from a new, blank document and this workflow; Home > Format as a table, but options are either greyed out or the design is not saved. In the preview, every second column is greeen, but when saved in the table gallery all settings are gone. What am I doing wrong?desiree23Feb 10, 2025Copper Contributor72Views0likes6CommentsRegarding the filter by condition option in pivot table in the excel
I'm taking Google Data analytics course in the coursera, there they use filter in the pivot table and apply conditions like, less than or greater than, they were using the Google sheets, and I couldn't find that option in the excel, you can select or unselect the value in the filter but there's no option to apply conditions like lesser than or greater than such value. Is there any way you guys know, from which you filter the fields by conditions, please let me know.BHARGAV_RAM_D_RFeb 10, 2025Copper Contributor1.8KViews2likes3CommentsSlicer not updating when source data is updated
Hello, I have a dashboard showing project data with multiple pivot tables. There are two slicers that are connected to all the pivot tables, Project ID and Project Status, these used to update when the source data changed but this is no longer the case and still doesn't update after refreshing the data. E.g. The Project Status of Project LIB682 changed from Active to Closed in the source data, however, if I select 'Active' in the Project Status slicer, LIB682 still appears in the ID slicer where it used to be greyed out to show it is not active. I have tried refreshing data and deleted and re-added the slicers but neither of these worked. When I first created the dashboard everything worked and I've not changed anything so would assume it should still be working. TIAAmanda2503Feb 10, 2025Copper Contributor30KViews0likes7CommentsFormula worked in Excel under windows10 but not in Windows 11
=SUMPRODUCT(((Urenregistratie!A2:A2500)=1)*(Urenregistratie!I2:I2500)) The Formula above worked in Excel under windows10 but not in Windows 11, did something change? How can I make my formula work again? Hope anyone can help me... Best regards, Rick.SolvedRick_DijsFeb 10, 2025Copper Contributor47Views0likes6CommentsMissing Tabs at Bottom of Excel Spreadsheet
This is my first post so I apologize if I'm seeking help on something that's obvious or simple. I'm working on a Dell laptop and I've got the Microsoft suite, including Excel, loaded on it. I've been working on a particular Excel spreadsheet for years, updating it quarterly without problems. Each quarter, I've added a new tab at the bottom of the spreadsheet identified by the appropriate month/day/year. Recently, when I opened this spreadsheet, all the bottom tabs (with the dates) were missing. I've looked at my Advanced settings and I see that the box "Show Sheet Tabs" is checked, so I don't think that's the problem. Also, I see my bottom tabs remain on my other Excel documents so it's not a systemic problem, only a problem with this particular spreadsheet. I'm working with a touchpad and not a mouse so if I need to touch the touch pad in a particular way, please let me know. Please help. Thank you!Dave12355Feb 10, 2025Copper Contributor4.7KViews0likes3Comments
Resources
Tags
- excel42,177 Topics
- Formulas and Functions24,448 Topics
- Macros and VBA6,348 Topics
- office 3655,931 Topics
- Excel on Mac2,616 Topics
- BI & Data Analysis2,329 Topics
- Excel for web1,878 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,607 Topics