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 |