excel
44399 TopicsProblem creating an Excel formula
I am contacting you because I am having trouble creating a formula to count names in an Excel spreadsheet. I have created a schedule in Excel in which there is usually one name per cell. The calculation of these simple cells is fine. However, in cells where there are two names written ‘NAME F.1 / NAME F.2’, only the first name is counted. I do not know how to make the second name count as well. If necessary, I can send you the Excel file. Thank you for your help, as I do not know how else to solve this problem.20Views0likes1CommentSummarizing Text From Multiple Excel Tabs
I have created a workbook with several tabs. I have a tab where I want to capture a summary of data from the other tabs. The data I want to summarize is in cells where I have used data validation to create drop down boxes (Y/N). I have tried to summarize the number of Y's and N's using SUM and COUNTIF but neither have worked. I've looked at YouTube videos to help to no avail. I have even tried to do add the text in each cell manually and that didn't work either. I am not an expert in Excel so can someone please tell me what I'm doing wrong. I've been trying to figure this out for a couple of days.49Views0likes3CommentsFormula help
I am trying to write a formula to search my sheet for a particular name and when that name is found, I would like to average a particular column values. There are multiple names on this sheet, but I only want to average the set belonging to that person. I believe it is an IF, THEN formula, but I'm not sure how to average the values. Thank you!47Views0likes4CommentsMS Forms If function ignoring new data
Hello, I have a MS form setup collating information, I need to then reformat how this data comes in so it can be copied directly into another bit of software. Currently we have sheet 1 as below which is what gets filled in automatically and directly from the form I have created a new sheet in the same excel file which then pulls the data from sheet 1 and rearranges it into the order I need. This uses the function as below. =IF(Sheet1!J2="","",Sheet1!J2) This works fine when initially setup, but when new entries are submitted to the form and new rows of data appear in sheet 1, the If formula on sheet 2 then skips these new data rows. For example if a new submission to the form has been made, then on sheet 2 cell b5 will say =IF(Sheet1!J6="","",Sheet1!J6) which is correct but the cell in the one below will =IF(Sheet1!J8="","",Sheet1!J8) which has missed J7 Can anyone shed any light on this? Thank you44Views0likes4CommentsExcel formula
How to revise the formula to become a string to calculate if the review year is not 36 months but can be 36 months or 48 months. The Original formula in column C is EOMonth(b3,36) column A column B Column C Document name Release date Next review date in 3 year time (mth-yyyy) Document management 1/8/2025 Aug 202881Views0likes5CommentsIF ISBLANK and NOT
Hi all, I am banging my head against a brick wall trying to figure this out. Column C has a day in it. Cell X6 has a value in it which automatically updates every day. Column X has new values entered every day. The value in column AM for each row is calculated with a formula, so it will give the value of X6 if X in the same row is empty, or 0 if X in the same row has a value. =IF(ISBLANK(X324),X$6,0) will give me what I want if just looking at the cell in row X, but I also need to check if C324 is either Saturday or Sunday. =IF(AND(OR($C327="Saturday",$C327="Sunday"),(ISBLANK(X327))),0,X$6) will give me 0 if X327 is Blank and C327 is either Saturday OR Sunday, but will not give me 0 if X327 is Blank and C327 is not Saturday or Sunday. Is there a way to use the NOT function with the ISBLANK to say if X327 is Blank and C327 is not either Saturday or Sunday then it will return value X6, but is any of those statements are not true then it returns 0. Thanks in advance...3Views0likes0CommentsExcel font rendering blurry when zoomed out (Windows 11, Microsoft 365)
Hello Community, I’m experiencing an issue with Excel (Microsoft 365) on my new Windows 11 ASUS touchscreen laptop. The text in Excel becomes noticeably blurry when zooming out, but looks fine when zoomed in. This problem does not occur in other applications (like browsers) and did not happen on my older Windows 10 laptop running the same version of Excel. What I’ve tried so far (with Microsoft Support): • Tested in Safe Mode → still blurry • Checked ClearType text and confirmed scaling at 100% • Verified “Optimize for best appearance” is already set • Installed Office updates and restarted device • Disabled all add-ins • Disabled hardware acceleration in Excel • Updated graphics drivers and adjusted GPU scheduling • Removed second monitor → no change • Compared display settings and Excel files between devices • Checked Excel Options for missing settings (e.g., Hardware Graphics Acceleration toggle not visible) • Remote session with support agent confirmed the issue persists Observations: • Only affects Excel (not other apps) • Text looks fine when zoomed in, but blurry when zoomed out • Blurriness persists even after updates, safe mode, and driver changes • Same Excel version works fine on Windows 10 • Touchscreen and scaling differences were considered but ruled out Has anyone else experienced this issue with Excel on Windows 11 (especially on ASUS touchscreen devices)? Is this a known rendering limitation, or are there any reliable workarounds/fixes to improve text clarity when zooming out? Thanks in advance for any insights! See the attached below for your reference: with blurry: without blurry issue:123Views0likes4CommentsHow 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.892KViews1like68Comments