I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...
I run into this a lot so any tip would be appreciated. Is there a formula I can use that strips addresses (that change in length and are unique in each cell) from a cell that contains valuable text ...
I am tracking several stocks, and saving their chart data in separate spreadsheets titled by their ticker symbol (i.e. aapl.xlsx, goog.xlsx, etc...). I want to have a single spreadsheet that I can ...
I'm trying to construct a hyperlink from a URL and a name in different cells. a1 = http://www.example.com/ b1 = example c1 = <a href="http://www.example.com/">example</a> What I want ...
I'm wondering if these is a way of using a formula to find a superscript letter, rather than just the last letter of a word. I have lots of tabs, with nearly matching tables on each one showing up to ...