Sunday, April 9, 2017

How to find things in Excel

Search the range A1 to A10 for the first cell which contains text, and show that text
=hlookup("*",A1:A10,1,false)



No comments:

Post a Comment

Popular Posts