Search results

BTW this is good for educating about match and INDEX http://chandoo.org/wp/2010/11/09/2way-lookup-formulas/

The problem (I think) you are having is that you have 10 data tables, which I assume are on different sheets. in this case, you need a way to select the table where you looking for the information. one of the best ways to do this is by using the INDIRECT(...) function. e.g...

this might be slightly better site: http://www.vbaexpress.com/kb/getarticle.php?kb_id=837

dvsdasari. you have to do a few tasks before a solution can be made for you. 1 - you need a list of all the unique vendor IDs and the Company names. This is necessary what ever method you do so you might as well go and start colecting that information. 2 - you need to notify us of the path...

In 2007/10, when you set the criteria for conditional formatting you want to select the "use a formula to determine which cells to format" which is similar to the requirement for 2003. Then you need to work out a formula that will drive a TRUE/FALSE answer. in this case, I suggest...

SMC, thank you for posting the VBA you found. It is polite to reference the source of any code or techniques you copy. I also like to insert it into the VBA using the ' e.g. Sub HelpingHands() 'Code partially copied from Chandoo.org insert Code End Sub

If you want to chart it, then you could look at the surface chart type. It is quite good at showing 3 dimentional data, where the Peaks and troughs are the volume. You could try a bubble chart - where the size/colour of the bubble show volume of occurrences, but I think these are harder to...

It's hard to remember exactly, I'm on 2007 at work and 2010 at home, but they should be on the form toolbar. If you show the form toolbar and then you can add any of the controls by "click and click"

Here's a little inspiration for how to deal with the cross over of days in weeks: http://img.chandoo.org/d/2012-calendar-v1.xlsx

So, =MOD(DATE(2012,6,1)-DATE(YEAR($A$1),MONTH($A$1),C$2),21)=0 could be =AND(MOD(DATE(2012,6,1)-DATE(YEAR($A$1),MONTH($A$1),C$2),21)=0,LEFT(TEXT(C$2,"ddd"),1)<>"s") or you could use: =AND(COUNTIF(B$4:B$18,B4)=1,NOT(ISERROR(MATCH(B4,B$19:B$30,0))),LEFT(TEXT(C$2,"ddd"),1)<>"s")

As asa seams to be trying his best to support you, and he's well busy, I thought I would try and pick up where he left off. Conditional formatting. I cannot see which version of excel you are on, but assuming it's 2007 or better then you can have loads of conditional formats. They get...

SMC maybe i can pick up from here. however, i cannot upload spreadsheets from where I am today, and this would easier to explain with an example. forgive me if i'm telling you what you know. I think what asa is trying to do is use the MATCH function to find the key string 'travel' in a...

OK 2007 has your answer, but you're stuck in 2003... workarounds? The ease of using named ranges is so that you don't have to use helper columns. OPTION 1 - set up a helper table in your final sheet. it can be hidden behind the charts OPTION 2 - use the INDIRECT(...) function. here you...

I was asked to do something similar once. However, it couldn't have VBA. We used the RANDBETWEEN(1,20) and countif(range,">"&range)to mixup 20 questions (learnt here on chandoo.org) then we used dynamic data validation to hide all but the relevant question (in this case multiple answers...

You could use mid(...) and Find(...) firstly define name or use this in cell ="A-->B-->C-->D-->E-->F-->G-->H-->I-->J-->K-->L-->M-->N-->O-->P-->Q-->R-->S-->T-->U-->V-->W-->X-->Y-->Z" then...