Prev: sumif..
Next: Calculation of weighed average
From: Rarebreeed on 9 Apr 2010 03:32
Hello,

I have a column of user passwords, some in all Uppercases, some in all
smallcases while others in mixed cases; Please how do i filter based on cases?


From: Rick Rothstein on 9 Apr 2010 03:43
Use this formula in a helper column and filter that helper column...

=IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed"))

--
Rick (MVP - Excel)



"Rarebreeed" <Rarebreeed(a)discussions.microsoft.com> wrote in message
news:D0EEF34B-94BA-46A8-9847-9C2194A4096E(a)microsoft.com...
> Hello,
>
> I have a column of user passwords, some in all Uppercases, some in all
> smallcases while others in mixed cases; Please how do i filter based on
> cases?
>
>
From: Rarebreeed on 9 Apr 2010 05:09
Hey Rick,

Exactly what i needed.
Thanks a zillion!
I really appreciate, Thanks.

"Rick Rothstein" wrote:

> Use this formula in a helper column and filter that helper column...
>
> =IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed"))
>
> --
> Rick (MVP - Excel)
>
>
>
> "Rarebreeed" <Rarebreeed(a)discussions.microsoft.com> wrote in message
> news:D0EEF34B-94BA-46A8-9847-9C2194A4096E(a)microsoft.com...
> > Hello,
> >
> > I have a column of user passwords, some in all Uppercases, some in all
> > smallcases while others in mixed cases; Please how do i filter based on
> > cases?
> >
> >
> .
>
 | 
Pages: 1
Prev: sumif..
Next: Calculation of weighed average