last value in range

  1. J


    Hello, Can someone help me understand this array formula. I found it online. It returns the value in the last occupied cell in a row but I would like to understand how the middle section works. My understanding is that ($T14:$HK14<>"") is FALSE, so what does dividing 1 by FALSE work. If...
  2. M

    Displaying Last Value in a Column

    Hi, So I had the formula <tbody> </tbody> =IF('12'!$D$34="","",(LOOKUP(2,1/ISTEXT('12'!$D$34:$D$76),('12'!$D$34:$D$76)))) before and it was working perfectly. Trouble is that I've changed the values that I used to put in the cells D34:D76. The values there now refer to another cell...
  3. T

    VLookup to return the last value of a row based on criteria

    Hi, I've been researching below issue for couple of days with out any luck of a solution: I am trying to create a formula which return the last value in a row based on a client name example: Column A (client name).......Column B (Data1).......Column C (Data2).............Column D...
  4. Y

    Find Last value in Group With Index Match

    For Each cl2 In Table2 nom1 = Sheets("Date_Step").Cells(Step2_Row, Step2_Clm).Value nom2 = Application.WorksheetFunction.VLookup(nom1, Table11, 2) nom3 = Sheets("Date_Step").Cells(nom_Row, Nom_Clm).Value Total = Application.WorksheetFunction.CountIfs(Table10, nom2...
  5. S

    Choosing last positive values

    Hi all, I am trying to work a formula where I can get the best 5 values out of the last 10 positive values. e.g. <colgroup><col><col span="12"><col><col></colgroup><tbody> A B C D E F G H I J K L M N 1 Positive Positive Positive Positive Positive Null Positive Positive Positive Positive...
  6. J

    Find First Instance of a Value after the Last Instance of Another Value in a Row

    Hi All, I'm responsible for reviewing a long checklist of items for project deliverables at my job. Each time I perform a check, I add a new set of a columns to record my feedback. Pass status is in every other column starting as S for as many checks as it takes to pass all the items. Right...
  7. S

    Lookup the last value in a range and selecting the date

    Hello, I have a worksheet that has ranges of string values that contain a date within the first 5 characters. I am able to locate the date from the cell: =MID(R10,1,5) But I am now having difficulty locating the last cell in a general range with value. I have found macros to assist...

Some videos you may like

This Week's Hot Topics