Recent content by OddProject

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...