1. T

    =IF Help

    Hi, Can someone tell me why my If statement is not working...
  2. 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...
  3. 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...
  4. 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...
  5. 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 =
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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 &...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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
  18. O

    Forumla help - Weighting a range of numbers across 100% (proportionally)

    Hi there. i am looking for a formula to allocate a percentage out of 100%, to a range of values. I am evaluating 6 options (Column A) and they have different costs (Column B). I wish to write a formula in Column C that displays the cost as a %, where 0% is the least cost and 100% is the most...
  19. H

    Excel Gantt Chart

    Hi All, I have a table of data and I'm trying to create a gantt chart, I have looked on numerous websites, even posted on here and I still can't get it to work, can anyone walk me through the process start to finish please? Many thanks Harvey
  20. L

    Simple question about excel.

    Hi there. I'm keeping a simple score for my game guild. I need to know the difference of =A1-B1, =A2-B2 =A3-B3 etc. When I add a new column it goes to =B1-C1, =B2-C2, etc. How do I keep the formula to stay on the new column A? I've attempted to use the $ symbol but it doesn't seem to work...

Some videos you may like

This Week's Hot Topics