Thread
: [Solved]
Matching last in a list
View Single Post
06-08-2016, 12:13 PM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,100
You could try:
=LOOKUP(2;1/(A1:A5="Bill");B1:B5)
xor
View Public Profile
Find all posts by xor