Appreciate the feed-back.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"WYN" <WYN@discussions.microsoft.com> wrote in message
news:C3221DFF-6CF4-4C5A-BEA7-3BB888E4EDE3@microsoft.com...
i entered the name manually and it works.thank you. wynb

"Ragdyer" wrote:

> Because "steve" in your list and "steve" in your lookup cell or formula is
> *not* the same.
>
> Type the name in manually in both places, and you'll see what I mean.
>
> There may be leading or trailing spaces or some other invisible characters
> present in one or the other.
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "WYN" <WYN@discussions.microsoft.com> wrote in message
> news:B624B023-C416-4764-90C5-D2C0A6571B67@microsoft.com...
> > i have employee names in column m2:m16.i am using the countif to count
the
> > number of times an employee shows up in the list.for some strange reason
> > countif will not work with the name steve!! any suggestions?
> > thx wynb
> > --
> > wynb
>
>