formual required

I have a dataset (see example below) Where Key_Text equals AAAInterventionType, where the Ref matches, find AAAReviewReason in the Key_Text column return the value of Key_Code in the column called ReviewReason. DTS Ref KEY_Text KEY_Code 11/04/2023 8:03 9995a AAAChannel PHO 11/04/2023...

Could anyone help me with the formula for below problem. I need to find the item name with the maximum price in a new column against the name. Attached the excel for the reference. Name Item Name Price Expected Result Formula? Harry A 20 C B 67 C 87 D 87 Tom A1 25 E1...

Hi Would you be able to assist me with dates in excel sheet ? I need to creates formula in the grey filled cells. It is to monitor cash flow and when money is due in. Based on the work dates column A&B I need formula in columns P,R,T etc through to BF to show the sums which are portioned to the...

Hi All -- I am just looking for some help on the following issue -: I am trying to find a way where, I can return the week number, within a specified date range, based off an entered date. In the example below, if I enter a date in column E, column F will return the Period for which that date...

hello to you all - This (may) be an easy question, but I seem not to be able to find the answer, so all help/pointers will be much appreciated, thanks! Question: Is it possible to cal via a formula the hand-executed right-click: "filter by selected cell's value"? I have one tab with a bunch...

I am working within Excel 2016 and I am currently using the following formula to count the number of dates equal to the week number. =SUMPRODUCT(--(ISOWEEKNUM(A3)=ISOWEEKNUM('---General Chem---'!$E$2:$E$8000)),--(YEAR(A3)=YEAR('---General Chem---'!$E$2:$E$8000))) This formula works however, I...

I have a VLOOKUP formula that I am currently using =VLOOKUP(B1986,'QC T4 BOD'!$A$373:$D$517,4,0) What I am trying to do is avoid having to manually change the $373: $517 part of the formula every time I drag the formula down The start and end refers to the cell address, I would like to use...

I have this data below and when I input a date in column A (Cell 9) I want all the numbers due on or before that date to appear. I have been able to do this with =IF formula but i have to it makes it challenging having to reference the same cell and it also creates unnecessary spaces. This is...

I am trying to create a WORKDAY.INTL formula that only includes Monday, Wednesday and Thursday excluding Saturday, Sunday,Tuesday and Friday. I am having a little trouble getting the "pattern" down. This is the formula I have but it is excluding Sat, Sun, Tue, Thur instead of Sat, Sun, Tue, Fri...

i want to get automated add time for every 00:01:05, example 00:00:00,00:01:05,00:02:10,00:03:15. like this i want upto 5 hours.... example : <tbody> A(original) B (time changed) C ffmpeg -i zxcv.mp4 -ss 00:00:05 -t 00:00:7 -codec copy output.mp4 ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7...

Hi all. Im looking for some help with Formulas and conditional formatting. i have 1 work book with 2 sheets. i have information in column a and b of both sheets. i need the formatting to do a few things. the idea of the sheets is for sheet 1 to have information entered into it and sheet 2...

Hi, i have huge date contain text/number/combined devises. sample data as below A B A2 21411111 A3 21412232 A4 24600221 A5 24600000 A6 2K221212 A7 2K221213 A8 2D221213 A9 2D221212 A10 71717777 A11 3458 A12 3587 I wanted to get the devises model, result should...

HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING FORMULA IN EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA BELOW. I WANT TO COUNT THE " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN VALUES" FOR EXAMPLE: IT WILL GAVE ME THE FINAL RESULT AS. DISTRICT--> JAMSHORO HAD...

HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING THS FORMULA N EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA.. I WANT TO COUNT " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN" FOR EXAMPLE: DISTRICT--> JAMSHORO HAD FOLLOWING COUNT BASED ON column MEDIUM SINDHI (...

Hello, I need to write an formula to put a number in column H that will look at the name in column B then look at the same name on a different work sheet in the same book called "SHEET2". Once I have the matching name found on "SHEET2" I need to get the data from column E on "SHEET2" and put it...

I have two columns, containing a person's data on repeated measurements and other one with the presence or absence of a characteristic. Data reads like this; <tbody> PatientID Characteristic Yes/No 1 N 1 Y 2 Y 2 Y 2 N 3 N 4 N 5 Y 5 Y 6 N 6 N </tbody> I want the number...

I am using AFZ53=IF(AND(AFB53<>0,AFB53<$AFO53),-100,IF(AFA53>$AFN53,100,0)) but getting 100 (This is WRONG) I should get 0. What should the rectified formula be? AFA53=FALSE AFB53=FALSE AFN53=2.5 AFO53=-2.5

I have different dates in column A, names in column B and a product I column C. Is there a formula that will add 7 days to the most recent date for a given name that next time that name is entered if a certain product was entered? Column A Column B Column C 1/1/2015 John...

Dear Professionals... Please find the below picture...I am facing problem of manual dig f allotting cash out flow for the month...so could some one help me to built a formula to get the desired result Garbled image removed.