equals

  1. K

    Modifying a current index match and making it more dynamic.

    I currently have the following formula: <code>=INDEX('All Other Subsidy'!F10:I32,MATCH('Rate Testing'!C58,'All Other Subsidy'!A10:A32,0),MATCH(input_tier_medical,'All Other Subsidy'!F9:I9,0))</code> What it is doing is based on a zip code input pulling a subsidy rate associated. It currently...
  2. F

    Conditional Statement needed

    Need the COUNTA function to include/address the condition stated below. =COUNTA(G10:G34)is to only count those cells where the posted value equals “R”…if all cells areblank, the recipient cell is to remain blank. Help is greatly appreciated.
  3. B

    VBA for New Column, moving right, saving previous value

    So this I believe is difficult. Difficult just to explain. I'm looking to take a column and make each cell equal to values from throughout the workbook. (C1=worksheet.B1) etc... Then this file will be saved, next week, the sheet is reopened and I want to copy the formulas to a new column...
  4. N

    Conditional formatting

    Hi, I need to format a cell in the following way. In column E (if this equals 'YES') but Column F = blank then the text YES in Column E should be RED. In column E (if this equals 'YES') and Column F = contains text then the text YES in Column E should be GREEN. Hope that makes sense.
  5. B

    VBA For New Column, moving right, saving previous value

    So this I believe is difficult. Difficult just to explain. I'm looking to take a column and make each cell equal to values from throughout the workbook. (C1=worksheet.B1) etc... Then this file will be saved, next week, the sheet is reopened and I want to copy the formulas to a new column...
  6. S

    Multiple If/then Statement Formula

    I need to have a field mark as "Yes" if e6 is =yes, and if not, if f6 is = yes and y6 is = direct, or if z6 = yes, or if aa6 is = yes So, saying if e6 is yes, then yes, otherwise if f6 is yes and the fields y6, either equals direct, or z6 equals yes or aa6 equals yes. Is it possible to write...
  7. B

    Add accumulating numbers in a column vba

    Hi all I have a macro that copies data to columns b and c This can range daily in the number of rows I would like a vba code to input column a Cell a1 the number 1 Cell a2 the number 2 Cell a3 the number 3 And so on until the column b anc c do not contain any data So example if nothing in...
  8. A

    Intersecting dates for 14/14 schedule

    I am a boat captain. I wish to create a worksheet that will calculate the number of daysI have worked based upon a give start date and a given end date. Butwait, it’s not that simple to just subtract the start date form the enddate. I have two columns. One column contains the start date...
  9. detweiler

    Conditional Formatting Not Working

    I'm working with three columns, S ( true / false ), T ( true / false ) and X ( empty or any numerical ). The logic is to format X is any one of the following - if S is true and X equals zero... =AND($S2="true",$X2=0) if T is true and X equals zero... =AND($T2="true",$X2=0) if S is false and...
  10. M

    Help with getting variable outputs from a single input

    Hello, I like to think I'm fairly proficient at Excel, but this has really stumped me. I've tried searching, but I'm not really sure what I'm asking for. Basically I have a sheet with a number of formulae spread across it, with numerous inputs and formulae leading on from each other. What I...
  11. P

    Formula help required!

    Hi All, I work in a call centre environment where we log our calls/emails etc. When I run the stats, I have a column called 'Contact Type' and a column called 'Caller' (as well as 50 other columns). I need a formula to give me the total number of tickets where the Caller equals "Third Party"...
  12. E

    If Formula is less than X show Y in Same Cell

    If I have a formula such as, =B8*0.09 and I want any answer that is under 5.00 to show 5.00 and any answer above 5.00 to show the exact answer to the formula. Is that possible to do in the same cell? If so, what would that formula look like? Thanks!
  13. M

    Row equal to other row

    I have a row in excel that has different names of people and another row next to it full of numbers from 1-2187. I want to make it so that when I type in a persons name, the number in the column next to the persons name comes out. Any help is greatly appreciated! Thanks.
  14. E

    match values two sheets

    Hello people, I been struggling with a function in couple of days now I hope someone can help me. I need a code that loops through sheet "mysheet1" on each row and checks the values in Columns "A" and "B" Example: (mySheet1) Columns:[ A ][ B ] ROW1: SWE...
  15. B

    IF Cell in column C is highlighted, then cell in column D = cell in column C

    Hi all, please help, Column C has rows of values. I want to populate column D as follows: IF Cell in column C is highlighted, then cell in column D = cell in column C, else leave the cell blank. Thank you.
  16. 9

    Identitying duplicates and Delete Lines

    I have a very large document with duplicate information. I have a column of Invoice numbers with matches, a column of material numbers with matches, a column of dollar amounts with matches. The variable is that I have a column with Days On that has a variation in it. I need to match the first...
  17. J

    If equals formula not working as expected

    Newish to VBA and have stumbled into a problem I can't crack myself. What the code should do: I have a series of list box (eTag1) items contained within a cell, which are comma delimited. I use the Split function and then two For loops to run through each of the items in the cell and compare...
  18. J

    If another cell contains just any two characters then make this cell equal...

    Hi, I know this should be easy... TIA... I'm in cell c2… if cell c3 contains just any two characters only (a-z or 0-9) then make this cell equal "." (just a period [or any char I choose]), otherwise just leave cell c2 blank.
  19. A

    equal result zero or blank

    Hi, So when you put a formula in a cell that it is equal to another: let's say in A1 you write =A2 and A2 is blank then in A1 it appears 0 but sometimes, just sometimes, when you equal a cell to a blank cell, the first cell remains blank what determines this behaviour? I need the cells to...
  20. L

    displaying a blank cell when a formula equals 0

    Hi! This seems like a fairly simple question and I imagine that this has been asked before, but I couldn't think of the right way to search for it. I worded it a few differen't ways, but I got no results. I have a document with lots of forumlas, but when the formulas equal 0 I just want them to...

Some videos you may like

This Week's Hot Topics

Top