Search results

Try then: =IF(ISNUMBER(LOOKUP(10^10,SEARCH('Sheet2'!$A$2:$A$10,A2))),"I","") where Sheet2 A2:A10 contains the array of Race Names.

reaching my beloved

write when he

Assuming the lookup track array is in another sheet, say Sheet2, in column A, then try a formula like: =IF(ISNUMBER(MATCH(A2,'Sheet2'!A:A,0)),"I","") copied down.

in collaboration with

the big red

or even Excel :p

I would list them in a table format like the original, So, first add a helper column that finds and counts the matches. In G5 enter formula: =IF(OR(A5=$J$3,E5=$J$3),COUNT(G$4:G4)+1,"") copied down. Then, say in K6 enter formula: =IFERROR(INDEX(A:A,MATCH(ROWS($K$6:$K6),$G:$G,0)),"") copied...

Can you zip it here? Or use another free uploading site, like SkyDrive, or MediaFire, etc.

I don't have Exel 2010 for Mac available to me. Anyway you can post the workbook here our upload to dropbox? I can check if it works with PC excel.

next to the

Please see your other thread with that new question http://www.access-programmers.co.uk/forums/showthread.php?t=257506

1. Double check that the Named Range is actually working, by going to Formulas|Name Manager, select the Name and then click in the Refers To field where your formula is, and make sure it actually highlights the desired area. 2. While you are there, make sure the Scope is Workbook, so that it...

Fur and tongues

You can also convert your source range to a Dynamic Named Range, and then reference that Name for your Pivot Table source. So that when you add/remove rows and refresh the Pivot Table, you should have all the info. Here is how to create Dynamic Named Range...

You should never use whole column references with Array Formulas... it's way too expensive. Try to use the minimum number of rows you think you need, or create a Dynamic Named Range. Also, if add a helper column, say in BD with formula like: =MAX(H2:BC2) copied down, then you can use...

on the inside

has it for

her big machete

until she cries