last value in range

  1. J

    Explanation

    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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top