forumla

  1. D

    Copy a value x from one workbook and paste it as yes/no if it is x in another workbook

    Using VBA macro, Is there a way to copy the value in a cell from one workbook that has, ex, value is "X" in cell A2 workbook1 sheet 1 and paste that value into another workbook, but the pasted value is a Yes/No in cell A2 in workbook2 sheet1 if that cell is the value X? Example shown below...
  2. S

    I need an exception formula

    This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I...
  3. J

    Cumulative formula - can't figure it out!

    Hi all Unfortunately I can't get my XL2BB to run so apologies in advance for the screenshot. I'm trying to calculate reducing balance depreciation in column M. I have split it out by month in columns O onwards, and I'm happy with how that works. Ideally, I'd like to be able to calculate for...
  4. T

    =IF Help

    Hi, Can someone tell me why my If statement is not working...
  5. F

    Formula with variable references depending on cell value

    Hello! I have an issue writing a formula that I hope has an easy response. I have a dataset with people who have multiple rows of data relating to them. If a certain number of rows meet criteria (eg, are within a certain time period of each other), I would like Value Y on that row to be blank...
  6. S

    Is there a Excel formula range to automatically move month on month?

    I am currently trying to use a formula range to automatically move along a column every month based on values up until the current month. When a new month begins the formula should extend its range to the next new month and extend the sum. Each month ranges up to 4 years worth. the error seems...
  7. E

    COUNTIF formula

    Good morning, I've been given a task at work and am having a little bit of trouble with copying a countif formula. The formula starts off as =COUNTIF($D$2:$D$885,"31/03/2017") When I copy the formula I want the date associated with the formula to increase by one day each time. So the next...
  8. T

    formula for Subtraction for filtered list

    hello kings i want a formula to Subtraction two numbers so when i change my filtered list the forumla can do that automatically Exemple 261544 - 205150 =
  9. Z

    Please help calculate if date falls within a range in Excel?

    <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:10.0pt...
  10. E

    If Column A has duplicates then add the value in column D for the duplicates

    I have a large inventory file I am working with. The data looks like this: <tbody> NSN Part number Condition QTY DESC 1005001950897 11662739 NS 7 MOTOR 1005001950897 11662739 NS 2 MOTOR 1005002676740 368506201 NS 4 HOUSING 1005005013201 5013201 NS 1 SPRING </tbody> Basically...
  11. M

    Row/Index Function

    =IF(ROWS($A$28:A28)>COUNTIF(Utilisation!C62:C68,"Paid Breaks"),"",INDEX(Utilisation!A62:A68,SMALL(IF(Utilisation!C62:C68="Paid Breaks",ROW(Utilisation!C62:C68)-ROW(Utilisation!C62)+2),ROWS($A$28:A28)))) Is there any way to amend this formula so that it searches all of column "C" for the word...
  12. L

    Need help with Index/Match Formula that omits values already populated

    I run a report that has a list of numbers, and only need the numbers below the 0's returned in a column or sheet. Here's what the final product should be: <tbody> Report: Forumla Result: 0 0 0 8005 8005 5364 7163 3667 0 1971 0 5364 4912 4398 0 3667...
  13. D

    SumIF's vs array formula..

    Array forumla = =SUM(IF('Order Sheet'!$C$7:$C$19358>=Summary!B3,IF('Order Sheet'!$C$7:$C$19358<=Summary!C3,'Order Sheet'!$F$7:$F$19358))) SUMIFs = =SUMIFS('Order Sheet'!F7:F19358,'Order Sheet'!C7:C19358, ">=B3",'Order Sheet'!C7:C19358, ">=C3") I have two formula's one array, one a sumif. B3 &...
  14. Z

    Order/Step in a list of actions

    I've got a dataset with the following columns: UniqueID | Date | Action [Ex: U123 | 12/1/16 | purchased widget] I need a formula to put in each row that will tell me what step it is for that unique id. I the example above, if "purchase widget" was the 5th thing U123 did, the formula would...
  15. P

    Offset and averageif question.

    Good afternoon, Hope someone can assist - I have the following formula which works perfectly to average the last 5 results of data in column D. Column D is a productivity rate and just a regular number =AVERAGE(OFFSET(Stats!D3,COUNTA(Stats!D3:D100)-5,0,5.1)) However, column C has one of 4...
  16. J

    Can I reference a sheet name in a formula

    Hi, I'm not overly sure how to explain this. I am creating a spreadsheet which has multiple sheets which has a summary sheet at the front which gathers data from all the different tabs. What is becoming a pain is having to rename the formulas to point to a particular tab, so, my question is...
  17. B

    Excel Formula to Search A Column for String, then if String Matches, Look in another column at the corresponding row with a date to compare to the cur

    I apologize for the long title. Here is what I am try to do. <tbody> Company Name Computer Name Connection Date Prior Activity Date Completed Date Penguins1 lab1 7/24/2017 7/24/2017 7/24/2017 Bears Inc lab2 4/23/2017 4/23/2017 1/18/2017 Bears Inc lab3 7/24/2017 7/24/2017 7/10/2017...
  18. T

    Multiple IF(OR / IF(AND with range and equation

    Okay all the big brains, I have what is probably a simple formula that has been stumping me for two days now. I did not find a specifically related thread so I'm adding this one. Problem: I want a cell to give a value based on two separate cells. The first is a standard number cell. The second...
  19. O

    IF AND Formula

    Hi, Have a formula I think should work but it doesn't seem to be. I basically am trying to sort some top scorers by position. I have a rank sumproduct forumla that works for the ranking, but I then want to display top scorers for each position in another sheet. I have <bdo...
  20. T

    IF AND Statements

    =C13+IF(AND(Input!B17<(Input!B5*(Input!B6/12*(MonthsOpen-1)))),C11>C13,C11-C13,0) This is my first time using excel's IF AND statements. Can anyone tell me what is wrong with this formula without looking at the actual data? Thank you

Watch MrExcel Video

This Week's Hot Topics

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
Top