Formula 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!
MS 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 you
Excel 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 2028How 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.
Excel - Showing which Carrier is used based on selected quote cost
Hello, I am looking for a formula to show me which carrier is being used based on the selected quote column (J5). I need the formula to tell me which quote is selected (Columns M/O/Q for example) in J5 based on the selected quote amount in I5. Thank you in advance. Victor
Another issue with Value transformation.
I've played for a couple of days with this, having tried a number of different solutions that worked for others. Cannot figure out how to make a text field convert to value. Here is my XLS. I am running MS Excel for Mac, V 16.102.1 (25101829), Office Home and Business 2021. Years of my "moderate skills" applied with Excel but stuck on this transformation. https://1drv.ms/x/c/4d0957bca9736d6d/Ec0gUD0-JTlCsi2fCIg8bpUBvkTobtXpP5Mt-piIA90uqg?e=AGOdCD
