Search results

Not sure what the problem is? Can you elaborate? If you select the whole table, go to Data|Sort, then sort first by Location then by Name, doesn't it get you what you want? If not, why not?

and Prince George :)

Thanks for the assistance Brian, BigAlpha, the actual code is not written by me... it is credited to Harlan Grove and was written in 2002... to be as Brian stated, flexible enough to work with ranges or arrays... I, and many others, use this code frequently for this kind of problem. The basic...

to seek revenge

is the result you are looking for TIME? If so, try: =IF(Sheet2!E3="",REPLACE(RIGHT(B6,4),3,0,":")+0,"") Then format as time to show as you desire. if it is not a TIME and you want a text result, remove the +0 part.

You will need to add a UDF (user defined function). Hit Alt+F11 to get to VBA editor... insert a new module (Insert|Module) and paste the following code in the editor pane... Function aconcat(a As Variant, Optional sep As String = "") As String ' Harlan Grove, Mar 2002 Dim y As Variant If...

try: =IF('MPRN_LevelInformation'!$B$12="","",'MPRN_Level Information'!A$12)

Ok, In column A of Sheet2 enter: =IF('MPRN_LevelInformation!$B$12="","",'MPRN_LevelInformation!A$12) and copy across the 4 columns...

hell broke loose

Can you elaborate with an example or two? That explanation is a little confusing....

I am sure it's possible, but it would be good if we had more details concerning what the conditions are, and how/where to be found in other sheets, etc...

when he was

and doing things

riding the big

own in this

will and power

That's great Galaxiom. I tested it in Excel and it seems to work great... it's a keeper! :D To the OP: It doesn't really work using ranges though.. i.e. like for a lookup. It's meant to compare two cells to each other and give a number...

wanted to start

Thanks for pointing that out to the OP, Brian.

Try googling Fuzzy Lookup or Fuzzy Vlookup... you will need an addin or macro to help you. I have never tried this one, but Contextures has never failed me.... you can test it to see if it meets your needs. http://blog.contextures.com/archives/2011/05/06/fuzzy-lookup-add-in-for-excel-2010/