View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Help with formula, pls

So....If you have Customers in Col_A and Dates in Row_1, beginning in B1...

What do you need to do?
Highlight a specific customer if it has a number under a specific date?
Highlight/count/sum customer that have a number under a specific date?
Something different?

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"J.Alex." wrote in message
...
I want to display information if the range contains a number (any number).
I
have several columns for different dates, and I want to check if customers
(rows) have occurences on any of those dates.

"Ron Coderre" wrote:

What do you want to do when you find them?

-------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"J.Alex." wrote in message
...
Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a
kind
of
ISNUMBER(A1:A5)?

Thanks,