Search results

Hi Hui, Thanks, works well, looks like i need to spend some time on OFFSET formula.

Hi, having some problems, my own logic says I should use INDEX and MATCH for this, but it doesn't give me the desired results, so I am either doing something wrong or INDEX MATCH just won't work in this instance ,,,,, explained in the attached file ,,, please reply via here with the corrected...

Hi, I am looking for a way, and i am sure it is easy to do, to have a bar or column chart with only one bar but captures more than on set of data .... see file below. http://rapidshare.com/files/442852509/Data.xls

Hi Hui, seems to work ok now, thanks for the extra time spent on this ,, gonna save me pulling my hair out trying to get it to work, Appreciate the help, if I get any more problems with it, I'll repost. Thanks again.

Hi Hui, returns a NUM error,,,, and I think it may be to do with the 3rd argument ('Raw Data'!$C:$C=Summary!C$4)as data in column C can have 1Q09 multiple times.

Hi Hui, the drop down menu will obviously have more than just 1 once I build the file to encompass all the data .... in fact will go from 1 - 10 as there are 10 different regions to collect data from.

Hi, The solution given by Hui worked ,,,, but what I didn't check was that it worked for other Geo/IOT numbers relevant to the first drop down menu, is there a way to include the first drop down menu with this solution??

Hey Hui, works a treat, didn't think of adding INDEX on the end ,,,, doh!! Thanks again.

http://rapidshare.com/files/442174539/Poser.xls Hi Hui ,,,, the data returned should only be one instance, i.e. no duplicates. I don't want to use a pivot as this will eventually be used by a second file.

Poser ,,,, and really annoying me. I have a table of data consisting of the below Geo/IOT Product Qtr Wk1 Wk2 Wk3 Wk4 1 Crabs 1Q09 1500 2000 2500 3000 1 Crabs 2Q09 2000 2500 3000 3500 This is only a small sample ,,, data goes on for hundreds of row. What I am looking to do is have the same...

Poser ,,,, and really annoying me. I have a table of data consisting of the below Geo/IOT Product Qtr Wk1 Wk2 Wk3 Wk4 1 Crabs 1Q09 1500 2000 2500 3000 1 Crabs 2Q09 2000 2500 3000 3500 This is only a small sample ,,, data goes on for hundreds of row. What I am looking to do is have the same...