excel
44662 TopicsTop n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.Solved1KViews2likes32CommentsTime sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!68Views0likes3CommentsHow to unlink cells in Format Control
I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential responses. In developer I have inserted a group box, into which I placed 6 option buttons. After formatting the buttons so that they snap to the excel grid I then linked them to a cell to make calculating responses easier. On-line advice then suggested that I could copy and paste these to each new question. However, by doing this, I am only able to choose 1 option as they are ALL linked to the same cell. How do I unlink each group box of 6 option buttons so that I can link each group individually to a different cell for each question? Or - do I have to create a group box and option boxes from scratch for each question set? I have removed the questions for simplicity of view (note that there are 6 in Q1 and Q2 not visible) and highlighted the linked cell from Q1. As you can see - for Q5 this has given an answer of 26 (the 26th option button) rather than 2 (the 2nd button in Q5)Solved146Views0likes6CommentsHELP! stuck excel cell formula I cant get rid of
Hi - I'm no excel guru - was doing a cut/paste of a few hundred rows of data, and somehow hit a wrong key(s), and now can't get rid of this weird formula I inadvertently created, which has my spreadsheet locked up. Hitting delete or backspace does nothing. The formula at the top of my excel spreadsheet displays this: =421:G6562.45 421 is the very top row in the section I was highlighting, and G656 was the very first cell I started to highlight. 52.45 is the value in that cell Any help someone can provide so that I can get back to my project is SINCERELY appreciated. THANK YOU in advance! Tom73KViews0likes21CommentsTender Tracker formula help
Hello, I am creating a spreadsheet to track tenders for various part numbers so that I can track when each part number is up for renewal. Is it possible to create a formula which based on the tender renewal date, excel would colour fill the row up until that date which is in the top row? Example screenshot. Not sure how to add an excel file40Views0likes1CommentLink doesn't work
We have recently started experiencing an issue when opening links within Excel on Azure Virtual Desktop. Our AVD environment is currently running the Version 2601, but the behaviour is very inconsistent, only a couple of users are affected, and the issue appears completely random. Interestingly, it works fine for most users both inside AVD and outside AVD. Affected users are receiving the following error message (screenshot below). So far, I have tried the following without success: Clearing the Excel cache Deleting the Excel container from the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel Is anyone else experiencing the same issue, or aware of a fix/workaround? Any help would be greatly appreciated.68Views0likes3CommentsHow to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.965KViews1like69CommentsMacro Dummy
I have written a Macro and it doesn't run the way it is designed and I am having problems finding my error. How would I solicit help here? I've written Excel macros for years but this one has me stumped. Probably easy for the geeks here.. I have a workbook with several tabs and then a report tab at the end. I want to identify the search criteria at in one cell and then go search in another tab in a certain row. When it finds the match it should then go down the associated column a specific number of cells and copy the contents of that cell. Then it should go back to the reports tab and paste it in a specified location. here is my macro...32Views0likes1CommentExcel auto-truncating timestamps sub milliseconds
I would like to leave feedback. It is very frustrating that when I try to look at logged data csv in excel, I cannot open it by double clicking, because Excel date-time format is so limited. It truncates sub millisecond data (don't save that file - or the data is lost!), so that any graphs start looking like stairs. And the work-around, to import the csv data and change the timestamp column format to text , and then convert it to a number, is very clunky. It forces me to other programs, like Matlab, which many people do not have. Example data: Timestamp,V-Output ,I-Output ,V-Normal ,I-Normal ,V-Emergency,I-Emergency,VGND ,IN , 2025-12-18 00:08:46.730845, Is it possible that you improve your product?46Views0likes5Comments