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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top