Search results for query: *

my response is below: General comments: 1: You ought to be using REAL DATES. Rather, you are using LABLES 'Nov-07, which in many cases are virtually useless except for lables. They will not sort correctly, let alone be able to be used in calculations. Ans: Well the raw data i download...

oops sorry, I do have a solution for the query, but its long winding. the formula that you see in the cells, E24-K34 of the Display.xls file does the calculation and is the fix. What am trying to do is to find an easier, less cumbersome formula to get the same result. to be clearer, am...

here ya go. k, now display is where I want the data displayed. The count of the 10's, 9's should be displayed against the list with colour coding (10-0) This is based on a monthly cycle (the month is displayed in E8 - K8) And the count displayed, depends on the drop down menu in B6. I do...

oopsss... the mail failed to deliver. Am attaching the link here http://www.mediafire.com/file/myn40nz1zln/Display.xls http://www.mediafire.com/file/qzm3mwmjzmz/Raw D.xls Thanks again. Please let know if you have issue viewing the file.

Mailing you the file,Skip you are kind and I really appreciate your help. IOU

Thanks Skip, your hint has sparked another idea, anyway, am attaching the files, Raw D.xls is the raw data file (I have deleted many of the fields and have just kept a few so that you would get an Idea) The other File is Display.xls where I plan to display the results. have attached a copy as...

dang! that worked like a charm. Thanks a TON!!!! well, probably i should start a new thread, but since the question is related to the previous formula, I am hoping that you can provide a better, easier and less complex formula. So here goes : I have two files, one which contains the Raw...

can someone tell me if this is a wrong usage? =IF(B6="EM";SUMPRODUCT(--(E8='[Raw Data.xls]Sheet1'!$I:$I)+('[Raw Data.xls]Sheet1'!$CX:$CX="10"));SUMPRODUCT(--(B6='[Raw Data.xls]Sheet1'!$L:$L)*--(E8='[Raw Data.xls]Sheet1'!$I:$I)*--('[Raw Data.xls]Sheet1'!$CX:$CX="10"))) It returns a #num! value...