Problem 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.
Filter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehow
IF 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...
Worksheet tabs to include date from a cell
Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.
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 youSummarizing 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.
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!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 2028
