• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlight Latest Entry

S

sambit

Member
Sir,

Please help to highlight the latest entry of the name list.

Example attached for your reference.


NAME LIST
ABC PVT LTD
XYZ ENTERPRISES
BDC & CO
CAT LIMITED
ZBC PVT LTD
BDC & CO
ABC PVT LTD
ABC PVT LTD
CAT LIMITED
XYZ ENTERPRISES
ZBC PVT LTD
XYZ ENTERPRISES
CAT LIMITED
XYZ ENTERPRISES
XYZ ENTERPRISES


attached example file
 

Attachments

  • Example data.xlsx
    9.8 KB · Views: 10
See G7:G21 conditional formattng in the attached.
 

Attachments

  • Chandoo55728Example data.xlsx
    10.5 KB · Views: 11
Just playing!
I used a Lambda function to determine whether a cell is to be highlighted or not.

1704228755962.png

LatestEntryλ is defined to be
Code: 
= LAMBDA(cell,
    ISTEXT(cell XLOOKUP(cell, list, list, , , -1))
  )
That is, look up the current cell in the list and return the last match as a range reference. Intersect the range returned with the current cell. If they intersect, format the cell; if #NULL! is returned do no format the cell.

Mind you, conditional formatting is so antiquated that I may well be accused of applying 'lipstick to a pig'!
 
You must log in or register to reply here.
Back
Top