Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (6)

Sign In or Sign Up now to post a comment!

  • Such an easy formula to solve seems like compliated problem!!! how amazing !!!

    1234saiwa 3 months ago

  • @1234saiwa , Yes it is! Mr Excel should get three points for winning this duel!

    ExcelIsFun 3 months ago

  • This one was tough to follow with all the edits after the fact. I agree -- much easier. Thanks guys.

    krn14242 3 months ago

  • @krn14242 , I was asleep and not thinking clear when I made it...

    ExcelIsFun 3 months ago

  • What is excelisfun thinking!?!?! ISNONTEXT, IF, COUNTIF!?!?!? When all that was needed was =A2 not A3!!!

    Point to Mr Excel!

    If data set not sorted maybe: =C2=MAX(IF($A$2:$A$595=A2,$C$2­:$C$595))

    However, Mr Excel's Sort Names, Sort Dates Z to A, Remove Duplicates wins!

    ExcelIsFun 3 months ago

  • o.o

    francismori7 3 months ago

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more