Forum Widgets
Latest Discussions
Sorting numbers
Hi, I have a excel sheet with x number of columns. I have formated the rows so that if there is a specific number it is marked in red. See picture below. The numbers that are marked are Top row 0 - 3 and 9 - 13. So numbers 4-8 shall not be marked Middle row 0 and 6 - 13. So numbers 1-5 shall not be marked Bottom row 0 - 1 and 7 - 13. So numbers 2-6 shall not be marked What I now whant is to count all columns that are not marked red. As of now I do this manual with marking with "1" below and use function Count. Someone that can help me with a function for this? Most thankful.
Y-Axis Not Grouping?
Hi there, I am working on creating a block schedule chart, you can see the table at the top left and what my chart looks like right now. The y-axis represents a different room. I want the block schedule to overlay rooms so that there are multiple blocks in the same row. For example, TUA TOPS OR INTRAOP 2 would have the 4 blocks displayed on the same row. My problem is that I cannot seem to get them to group together. You can see that in the table I have identified duplicates to ensure that the naming conventions are the same. I have also formatted column C as text. I have also assigned the Axis Type to be "Text axis" as you can see on the right of the screen. Any suggestions? I think ChatGPT is sick of trying to help me at this point lol.Skipping cell while pasting data
Hi, I'm trying to figure out if there's a way to skip cell at constant interval while pasting Huge amount of data. Something that will act as a pasting template/guide eg.: I need to copy huge amount of data (around 5000 cell) in a row but I need to let 2 blank cell every 5 Data cell. So lets say column C is where I want to paste the data, but I need it to skip cell C7,C8 and then C14,C15 (and so on) while pasting the data. like this: Thank you
Removing a line between two points expands the legend
Hi all, I'm wondering how to avoid the following problem: When I remove the solid line between two points, where there's a break in data logging, the legend seems to expand to describe each point's x value instead of the series name. Is it possible to avoid this? Images below. Many thanks, Faz
get count from multiple rows in one cell by unique identifer
I have a tab "Tab1" with a column named DND that has multiple rows with the same cell data. See my pictures, for example there are three lines for "location 1". I need to count the totals in the "Count" column for that location and put the result in my second tab named "Tab2". So, on "Tab2" for "location 1" the answer should be 3.Excel 365 Focus Cell - "Show Auto-Highlight" feature is disappeared
Hi everyone, I recently update the Excel 365 to and I found the "Show Auto-Highlight" feature is disappeared. From Microsoft website: Increase ease of navigation with Focus Cell in Excel | Microsoft Community Hub, this feature is very handy when using the find fuction. how can I get this function back? Thank you!
