formual required

  1. C

    Lookup and Match Formula

    Hi I'm looking to find formula to return a value in sheet 2 after searching for a specific product code and month in sheet 1 and matched to the date in sheet 1 for example find the price paid for an ingredient in October 24 Thanks in advance
  2. J

    VBA or formula to copy value from one column into another column where certain conditions are met.

    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...
  3. K

    Finding maximum against a value

    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...
  4. D

    Formula to add sums to data range in Excel

    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...
  5. IIII

    Return week number within specified date ranges.

    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...
  6. A

    Can "filter by selected cell's value," be called by a formula?

    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...
  7. M

    Sumproduct with Indirect Sheet Names

    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...
  8. M

    VLOOKUP/INDIRECT Formula

    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...
  9. M

    Count IF Formula Between two dates

    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...
  10. M

    Workday INTL formula

    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...
  11. G

    replace the list of words with selected list of words. and change the time automatically

    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...
  12. S

    Conditional Formatting

    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...
  13. N

    IF function

    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...
  14. J

    How to count SIMILAR DATA from 1 column based on string in 2nd column

    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...
  15. J

    How to count string from 1 column based on string in another column

    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 (...
  16. N

    formula to get data from another sheet excel 2010

    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...
  17. C

    How do I get the number of unique cases used to get the frequency of the other variable using Excel

    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...
  18. H

    Rectified formula neded

    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
  19. B

    Auto Fill Dates

    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...
  20. N

    Based on credit period the the amount should go to respective month

    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.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top