| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news  0EEF34B-94BA-46A8-9847-(E-Mail Removed)...> 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? > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message > news 0EEF34B-94BA-46A8-9847-(E-Mail Removed)...> > 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? > > > > > . > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I filter the cells based in Fill color? | Ravi | Microsoft Excel Misc | 2 | 28th Apr 2010 12:47 PM |
| How to change mixed case to upper case in Excel for all cells | =?Utf-8?B?V29yZEFsb25lIE5ldHdvcms=?= | Microsoft Excel Misc | 7 | 30th May 2007 05:53 AM |
| Filter and fill cells based on criteria | =?Utf-8?B?TXJwdXNo?= | Microsoft Excel Programming | 1 | 16th Mar 2007 09:36 PM |
| Filter based on first character of field | =?Utf-8?B?RnJhbmNvcGhvbmU=?= | Microsoft Access | 8 | 18th Jul 2006 08:26 AM |
| Excel auto filter doesn't recoginize case - won't filter AA from A | =?Utf-8?B?TWlrZXk=?= | Microsoft Excel Misc | 1 | 29th Sep 2005 08:18 PM |
