Recent Discussions
Index and Match command is return results from the wrong column
Within Excel I'm using the Index and Match command to search an array. I've provided copy of the workbook. Here is the command =IFERROR(INDEX(D7:H11,MATCH($D$13,L7:L11,0),MATCH($E$13,M7:M11,0)),"") Here is an added twist on sheet 1 I use this formula and it works correctly. This formula is on sheet 2. The results for the Average column returns correctly. The other columns appear as if the were flipped. When the Marginal column is selected I get results from the Above Avg column. The opposite happens if I choose the Above Avg column I get the Marginal results. The same thing happens if I choose the columns on the ends. As shown in the image above the Extreme row is selected and the One column is chosen. The result should be "Caution", but instead the result is "None6". FYI, this is part of larger workbook where the results will be posted on a different worksheet, but to simplify everything I've placed it on its own page. RegardsHow to eliminate any height beyond text height on textbox
Why? I need to make a special Quick Part where stacked text boxes are close enough to overlap each other before the actual texts start overlapping. This makes the text input afterwards a struggle. I can fine-adjust the space at the bottom by dragging a text box's resize handle, but the space at the top doesn't disappear. I've already removed margins, paragraph spaces and set line spaces to minimum. Setting vertical alignment from Top to Middle doesn't change this behavior. Is it possible to adjust the text box's size to fit the text size exactly?
Excel bug Data sorting largest to smallest
I have some problems by sorting data in excel. First sorting by column M Largest to Smallest, than by column L also Largest to Smallest. In one case sorting is not successfully (Marked font color RED). Can someone explain this to me? https://drive.google.com/file/d/1n_IWsw9YH6FDxXnFm_wWwJEVQIN9AxRu/view?usp=sharing
Filter cells in stead of full rows by color
Hi, I have an excel that contains a set of columns with values where in each column each cell has a certain fill color. Now I want to see per column only the cells with a specific color e.g. red. I tried the filter option on the columns, but that filters complete rows. I only want to filter the cells in a column. So in the image below I want to see only the red cells. So in column B no cells, in column C C3, in column D D4 and D5. The regular filter option would show B3 and B4 as well, because it would show the full row for C3 and the full row for D4. Any ideas on how I can achieve this? Thanks!
COUNTIFS Range Not Working
Hi, I'm a teacher who is trying to get data on my student's proficiency without manually counting individual numbers for 100+ students in 7 different criteria. I also can't upload the file because it contains information about my students that I cannot reveal. Just to give an idea, this is what I'm working with. I've made the columns super small because I can't get the first three columns to freeze without it freezing a whole window, so this is my solution to keep track of what my rubric is out of while I finish grading. I will make them normal again when I'm done. My formulas here are all working correctly, and I have no issues. The issue is in my Proficiency scale below. This is the formula I currently have in the active box in the image above: =COUNTIFS(D40:CU40,"<50,D40:CU40,>-1"). I didn't want it to disclude the zeroes or 49s, so I set it to one higher according to what I learned from researched on how to use COUNTIFS. From the screenshot, you see that I should have at least 1 student in the 0-49% (although it should be much higher calculating in the students who never submitted their essay but not pictured in my screenshots). However, the formula is not working, so I'm not sure what I did incorrectly. Any help would be appreciated. I need this data for Friday.Filter function with Time criteria
Dear Experts, I have a data like below:- For a Single rnti== 17975(say), and in Column No B is the time-difference between each rows for this rnti, for lcid==4 (column=F) I want to populate Column H~K in a way that if the "isStatusReportRequested_" between 0~5ms then "YES" will be populated in Column "H", and so on Attached is the Worksheet, I tried using IF, but not seems this didn't worked:- Attached is the Worksheet. Br, Anupam
How to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on. if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful. Worksheet attached. Br, Anupam
Recent Blogs
- The 2025 Microsoft Excel World Championship and Collegiate Challenge wrapped up their season in spectacular fashion at Las Vegas’ HyperX Arena, drawing competitors from nearly every continent and cro...Dec 04, 2025
- With version history in Copilot Pages, you can now explore and revert to earlier versions of your work.Dec 03, 2025
