Formula Question

[Craig Roberts]

Hi

I am pretty proficient with Excel but found myself stumped in trying to work
this out. I don't use VB - which is just as well as I am trying this in
2008.

I have a 2 columns of data.

Left column contains dates, not all consecutive as it represents a date when
an event actually occurred, so the date does not appear if it did not occur.

Right column contains a number - which is the hour the date occurred.

On most days this event occurred, but on each day it occurred at different
hours of the day and at different times.

I want to show this on a chart, but I would settle for how many per day.

I have looked at LOOKUP and COUNT(A) but can't see how to do a lookup in
array of cells and count the occurrence of a string. Does this need to be
scripted?


Regards
Craig.

 

[Niek Otten]

Hi Craig,

Looked at Data>Subtotals?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
|
| I am pretty proficient with Excel but found myself stumped in trying to work
| this out. I don't use VB - which is just as well as I am trying this in
| 2008.
|
| I have a 2 columns of data.
|
| Left column contains dates, not all consecutive as it represents a date when
| an event actually occurred, so the date does not appear if it did not occur.
|
| Right column contains a number - which is the hour the date occurred.
|
| On most days this event occurred, but on each day it occurred at different
| hours of the day and at different times.
|
| I want to show this on a chart, but I would settle for how many per day.
|
| I have looked at LOOKUP and COUNT(A) but can't see how to do a lookup in
| array of cells and count the occurrence of a string. Does this need to be
| scripted?
|
|
| Regards
| Craig.
|

 

[Carl Witthoft]

That was my thought, or to use COUNTIF. Basically set the conditions
to count the occurrences of the day you choose.