|
|
#1
05-06-2014, 01:45 PM
|
|||
|
|||
Detect Category Change
I know I've seen this done before somewhere but I'll be darned if I can find it.
I'm trying to detect the change in a column value. I have a list sorted by "Category" (column title) I have helper column that I need help modifying the formula for. Currently it is just =LEFT(B2,1) That works just fine but what I really need to do is wrap it in a statement so that only the first instance is shown. Sample attached. Could some one point me in the right direction for the formula? Thanks! Scott 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Detect in VBA if document has been changed | nsv | Word VBA | 4 | 04-28-2014 05:58 AM |
| How to create a Main category mirrored in Sub category data entry type of solution? | Geza59 | Excel | 0 | 10-19-2012 05:44 AM |
| Detect a cell has un-approved change or not? | LongTTH | Excel Programming | 1 | 05-20-2012 02:22 AM |
| auto-detect display options? | davidt76 | PowerPoint | 0 | 09-30-2011 07:26 AM |
 Rule on Category Change
|
ker09 | Outlook | 1 | 08-29-2011 06:15 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode