excel code help for prices...

[dooze1]

Hi
Can anyone help me get some code excel or vba, or macro. not sure which is required
for the question posted on the chart attached. thanks for any help..mike

http://img828.imageshack.us/img828/5...lcodehelp2.jpg

[eddiekruger]

Try this in M4:

=countif(k4,">h4")

[dooze1]

hi eddiekrugger
That code doesn't seem to work..

What i'm trying to do is see if
K18 is >< than D18,
K17 is >< D18
K16 is >< D18
K15 is >< D18

etc, etc....

thanks for help

[eddiekruger]

hi eddiekrugger
That code doesn't seem to work..

What i'm trying to do is see if
K18 is >< than D18,
K17 is >< D18
K16 is >< D18
K15 is >< D18

etc, etc....

thanks for help

It made sense in theory, but I'm not with excel now so I'll have to get back to you.

[DGagnon]

i am unable to view your image could you attach it instead of linking it?

[dooze1]

hi dgagnon,

sorry but unable to attach image to post..

[TAMILARASAN]

Hi can you attach an sample excel sheet & need a bit explanation on your requirement.

[tkowal]

Try this in M4 and copy down:

=if(k4 > $D$18, 1, 0)