Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.
If you need to post an image post it in the *.jpg format.
Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks for the tip. Adjusted PNG to JPG and re-uploaded and edited OP.
Try this...
Data Range
This formula entered in L2 and copied down:
=LOOKUP(1E100,K$1:K2)
This solution also works nicely. Rep added to both answers and thread marked as Solved. Thank you all.Originally Posted by Tony Valko
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks