show a due date using data from multiple columns
I have a spreadsheet in excel, such as the Table 1 below. For the 5 Due Date columns, I have conditional formatting set up to format the cells. See Image 1 for a list of rules applied to all Due Date columns. I'd like for another table to populate, showing only columns, Laboratory ID, Description, and any column that is highlighted per the conditional formatting rules. For example, I'd like the return table to look something like Table 2. Table 1. populated in cells G9:N12 ID Description Due Date 1 Due Date 2 Due Date 3 Due Date 4 Due Date 5 Out of Service? 1234 Instrument 1 11/17/2025 N/A 1/31/2027 3/11/2026 11/17/2027 FALSE 1235 Instrument 2 1/14/2026 2/17/2026 3/31/2027 1/23/2026 12/29/2027 TRUE Table 2. Conditional formatting rules applied to cells I9:M12 This Week = White font color, Red fill This Month = Red font color, Light Red fill Next Month = Dark Yellow font color, yellow fill Table 2. If today is 11/10/2025, the table will display columns ID, Description, and only column show for due dates within This Week: ID Description Due Date 1 1234 Instrument 1 11/17/2025
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
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.
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
Summarizing 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
