Search results

You can use the SUBSTITUTE function to remove the space for this if I understand correctly e.g. =INDIRECT(SUBSTITUTE(A1," ","")) So if A1 contains Team One, then this function will "virtually" convert that to TeamOne so that you can view a list named TeamOne.

to take pictures

Try using conditional format formula for A1: =COUNTIF($A$26:$Y$50,A1)>0

showed you her

burn your eyes

and his precious

swallowed them all

Hi, Is it possible to allow for .xlsx uploads for sample workbooks in Excel 2007 or later? Currently you allow for only .xls (and .zip... but many people don't pre-zip files and instead convert to .xls). Thanks

Not sure if you are still looking for a suggestion...... Anyway, here's mine. See attached. I have assumed you are using Excel 2007 or later. First, I would set up the result table horizontally so that you can allow for variable rows of each as I have shown. Second, insert a row above the...

Not sure what you mean by "I have to repeat it" Those formulas look pretty good to me, you just need to copy them down... You wanted both formulas combined into one? something like: =IF(ISERROR(FIND("sos",A1)),"No Chart Listed...

Not sure I completely understand. Are the first two lines going to have the hyperlink extracted? They don't seem to have the .sos part? Also, rows have 2 hyperlinks? Which one to extract? What pattern can we look for?

I can try to help. I am Italian-Canadian :) I will PM you my email address.

Does your Vlookup() formula have the 4th parameter, FALSE (or 0) to indicate find an exact match?

Assuming the list of States is in F2:F51, and your first string is in A2, then first add a helper column that extracts everything after last state in your string... in B2...

thumping, I thought

in harmony with

when suddenly John

Are you able to demonstrate this, with sample workbooks or with jpegs?

To bigger and

Have a look at Excel List feature (Excel 2003) http://office.microsoft.com/en-ca/excel-help/about-excel-lists-HP001004433.aspx or Excel Table Feature (Excel 2007+) http://office.microsoft.com/en-ca/excel-help/overview-of-excel-tables-HA010048546.aspx These can be use to "autofill" as you...