1. S

    IF Formula/ Countif

    I have the below formula I am trying to use to let me know if a person is supposed to be making specific adjustments. Right now every cell is showing "Check Adjustment" and the ones that are allowed to make adjustments are showing their names. I am wanting the cells to be blank if not an "RV"...
  2. M

    Rank issues

    Hi There, My Rank formula isn't working properly and I'm not getting the proper results. I don't mind duplicates which i can fix with some weighted adjustments. I'm getting dupes with different point values which has me baffled. Here's my formula: =IFERROR(RANK(AS3,AS3:AS104,0),"") I'm...
  3. J

    VBA - Find text and replace with value of cell above it

    I'm trying to figure out how I can use Cells.Replace along with Offset to locate and replace the cells that contain the text "Auto Adjustments" and replace it with the value of the cell directly above it. <tbody> 450 Auto Adjustments <--- this Cell is changed to the value of the cell right...
  4. Johnny Thunder

    VBA Help - Rewrite a VBA Formula - COUNTIF

    Hey guys, just need a little help rewriting this formula below, Sub Duplicate_Val() Dim lrow As Long, ws1 As Worksheet Set ws1 = Sheets("Datasource") lrow = ws1.Cells(Rows.Count, "A").End(xlUp).Row 'Adjustments Lastrow Application.Goto ws1.Range("L10") With ws1...
  5. C

    Formula Help

    Hi, I'm trying to determine how to indicate which month an adjustment will post to an invoice. Column A= billing cycle date Column B= Market Column C= Adjustment Approved Date Column D= Adjustment Amount Column E = Which invoice will credit post to: So I'm trying to build a formula in Column E...
  6. H

    Adjusting header picture to match 5x10 cells

    Hello, On my previous thread I asked on how to make the 5 x 10 cells to fit perfectly in a 7x10 inch print area. I add background picture as header and it prints but I like to adjust the picture's features with cells. The picture is a repeated picture of 5x10 cells too. 1- What size should...
  7. L

    *MROUND, Minimums, and Maximums...oh my

    Does anyone know if it's possible to use the mround function subject to certain mins and maxes? Further, is there a way so that the sum of an mround column doesn't exceed a value? See the table below for some details: So can I: a) have the formula be constrained to be strictly less than the...

Some videos you may like

This Week's Hot Topics