absolute

  1. P

    Excel 2010 formula to look up duplicates so I can contra them off

    Hi, first of all thank you for looking at this post. I have started a new job and am wanting to improve the speedof the month end process. I have to download the information from Excel from thenominal ledger to review (approx. 3000 lines) some of the values are the same butare pluses and...
  2. R

    Button to copy value from one cell to another

    Greetings, Hoping someone can help with a script to make a Button (form control) copy the value from cell D4 and write it into the cell which is referenced as an absolute in cell E4. I'm not sure if I'm using the right button btw. Any help appreciated :-)
  3. muhammad susanto

    Conditional Formatting In Absolute Number, Highlighted Color

    hi all.. how to make CF formula with condition like this : in absolute number (20% as parameter) if C2=>20% - give this cell Red color if C2=>-20% - give this cell Green color <tbody> data expected result (Hightlighted) 25% Red -25% Green </tbody> any help, greatly...
  4. B

    Formula to Pick largest absolute value and return column header

    Hello, Need assistance with a formula to return the largest absolute value in a range and return the column heading in row 1. Found this formula on another forum and it works but it only gives me the largest value, not the largest absolute value...
  5. danhendo888

    Copy paste formulas to new sheet (absolute references)

    https://1drv.ms/x/s!AvjBsEPEq12ngUDMrgxRZFuYzsgm?e=ghaRAa Hi guys, I need to copy/paste cells M1:V14 to Sheet2 but have the absolute references point to the cells from the original sheet Is there a way to do this?
  6. M

    Summing negative numbers to return the Absolute Value

    I have a sheet in which negative numbers are required, however, I need to convert the negatives to the absolute value on another sheet. I have tried =sum(abs(a2:a6)), but the I am only getting the #value ! error. Any suggestions?
  7. B

    Commence macro from current (not absolute) cursor position

    I should know how to do this, but I don't. When I use Record Macro to create some new VBA code, it records the absolute position - row, column, and sheet name - but I often want a macro to work anywhere from the starting position. See the code below. My goal is to select a set of cells in a...
  8. willow1985

    How to always Reference Cell even if row is deleted?

    I am using the below formula but always get a reference error when I delete row 14. I always want it to reference C14 even if the row is deleted. Any idea how to incorporate an absolute or index in this formula? =EOMONTH(C14,0) Thank you to anyone who can answer this!
  9. J

    Change all cells to Absolute $?$

    Hello Is there a way where you can change all the cells to absolute references? I want to select A1:OO100 and change all the formula to $?$ what is the short cut to do this? im using a Mac. Thank you
  10. muhammad susanto

    Conditional Formatting Only Biggest Number And Zero in Absolute Formated

    hi all... how to make in Conditional Formatting highlighted cell e.q. yellow with criteria : 1. Only biggest number choice ; and 2. the number in absolute format (positive or negative number);or 3. the number is zero (0) for criteria 1 and 2, this formula below worked well but for criteria 3...
  11. J

    Row Insert with Marcro

    I have a Macro that I have recorded that is copying columns H and I, inserting two new columns and moving the previous H and I to J and K. In D3, I have the following formula: =SUMIF($H$2:$AAA$2,"Interest",$H$3:AAA3) When I run the macro to insert the new columns, the absolute reference to H2...
  12. M

    Hyperlink Problem

    Hello and thank you in advance if you can help, I am using excel 2019 64 bit on a PC. I have a VBA macro that I have used to create hyperlinks in the past. It has always worked fine, and it "sort of" is working now, but it is not keeping the absolute hyperlink I need, so it will not open the...
  13. W

    Need Named Range Formula to Auto Adjust for Every 5 Rows

    Hi everyone - I am trying to avoid creating hundreds of named range formulas. I have set up an image box to display one of three different images in A2 of Sheet1 if B2 of Sheet1 contains one of three specific values, no image shows if B2 contains the value "0". The formula I use for this named...
  14. M

    Countifs based on 'contains' but references a cell in table

    Hi I have the below formula I basically want to count if the country in my current table appears within text in my country column in table1 Also since I want to absolute reference the PM, I've use $C$2 as I didn't know how to absolute reference the cell in a table if I just clicked on it. It...
  15. J

    Absolute Offset ?

    Is there a way to move an absolute value cell reference,up or down in a worksheet column with an offset formula.....or some other method not using a relative or moderate value...my worksheet is large and the table contents I want to count,keeps changing,skipping rows In the example...
  16. N

    Sumifs absolute

    Hi All, Been trying to make this work with previous similar questions but unable to make it work. When trying to do this on a summary level the absolute is done on the top level and not on the line by line level and then summed, which is what i am looking for For example If i do a cross grid...
  17. M

    Can someone get this formula to work?

    Hello...My name is Nathan, and I am trying to get the following formula to work. I simply want to assign full credit(2 points), partial credit credit(1 point) and no credit(0 points) for the given criteria...
  18. R

    I Need a formula to show full, partial and zero credit results

    Dear Sir or Madam: My name is Robert, and I have just one Excel formula issue. The following formula works perfectly, but I want to add criteria for "0" credit as well. Any assistance you can provide will be greatly appreciated. Sincerely, Robert...
  19. G

    Formula/Statement that is variable and not absolute

    Hi All, Just need some advice, I've done some research and I can't seem to find the right answer, I'm getting to the point where I don't believe there is a way to do what I'd like in excel unless it's manually. I'm looking to compare 2 lists, a customer list (20k records) and a supplier list...
  20. H

    Can I autofill an absolute cell reference down a column?

    I'm trying to link a checkbox, which I have, to an absolute cell reference. The thing is, it's a long list. Is it possible to auto fill the row, or do I have to write in every cell reference one by one? Apparently it's quite a problem in Excel 2010. Thanks for your help, in advance. HizExeLenCy

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top