Search results

Thanks for the reply, but I have tried that. Copied and pasted the values in a different work book, removed the data validation, applied the data validation and selected the data (same as all the other worksheets) in the source and pasted the values back in. No drop down (before and after I...

Anyone able to help with this? Its more of an annoyance than a problem, just dont understand why the drop down deosn't work, when it works on other identical worksheets.

Every worksheet is identical, just holds different data for different customers. The source and data is all in the same place and is exactly the same on every worksheet. F4 doesn't do anything except asks me to save... But if I hold Alt + Down arrow the list appears, but it holds other bits of...

Mornin'! I have a slight problem (more of an annoyance). I have a workbook with countless worksheets. On each worksheet I have data vailidation employed, all the drop downs work fine on every sheet but one. The drop down will not work, but if I hold Alt + Down arrow the list appears (But...

Brilliant mate, exactly what I need. Thank you muchly! OddPro

thanks for the reply, but im not too sure if I understand... Could you chuck an example into a spreedsheet? P.s Did you look at the sample data I provided? All I need is a count per month. Thanks again, OddPro

P.s The format of the dates are not important, I need summarised monthly data but I have also tried Aug, Sept etc... Aug-09, Sept-09 etc... 01/08/09, 14/09/2009, etc... And now month numbers 8, 9, etc...

Here is the Example

Hi Brian thanks for the help, I have tried various methods, but when I use "=sumproduct(--(G2:G133=8)*(c2:c133="Blue"))" I always end up with the value of '0'... I'll even attach my spreedsheet, I have no idea why this is happening. thanks again, OddPro

Here's some mock data to help support my request. I hope you get the idea :)

Here's some mock data to help support my request. I hope you get the idea :)

Here's some mock data to help support my request. I hope you get the idea :)

I also want to keep my dates (Without having to change 13/08/2009 to "Aug"). So i'll need a nested: Count "Blue" in column C2:C134 Where B2:B134 >=01/08/2009 and <=30/08/2009 which hopefully results in 9 entries found.

I tried: =SUMPRODUCT((C2:C133="Blue")*(B2:B133="Aug")) but results in 0... Which is impossible. Could you please provide an example. Thanks

Hi guys, easy one for you. I have 4 colums: the 1st I have a unique code. the 2nd i have the date log 3rd a colum with 4 types (red, blue, green etc) for example. 4th just a title. I need to count the number of colours in colum 3 in each month (Aug, sept, oct, Nov, Dec, Jan and Feb...

Nice one Brian, exactly what I needed :) Many thanks! OddPro

Any chance of a response/solution please?

Thanks for the reply, It's all starting to sound very complicated... to me this sounded simple (in my head) but just couldn't find a way of implementing it. If you could throw up a sample xls that would be sweet. Thanks again.

K, this is what I need for further analysis. I just cant seem to do it myself so Im kinda relying on you guys. Again sorry for my posts yesturday, you guys help me out alot on here and I should show my appreciation. Many thanks, OddPro

Sorry for being impatient, it was doing my nut trying to work out a simple way of breaking the date ranges down into network days by month. I've never used code in excel either, so I wouldn't have searched for it. Thanks, the solution provided after yours was pretty much what I was after, but...