If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cell value changes
How do I identify when a cell value changes in a long
column of numbers. I have many duplicates in this column and would like to sort the column and then identify the cells when there is a change in value. |
#2
|
|||
|
|||
Chip Pearson has lots of techniques at:
http://www.cpearson.com/excel/duplicat.htm wrote: How do I identify when a cell value changes in a long column of numbers. I have many duplicates in this column and would like to sort the column and then identify the cells when there is a change in value. -- Dave Peterson |
#3
|
|||
|
|||
-----Original Message----- Chip Pearson has lots of techniques at: http://www.cpearson.com/excel/duplicat.htm wrote: How do I identify when a cell value changes in a long column of numbers. I have many duplicates in this column and would like to sort the column and then identify the cells when there is a change in value. -- Many Thanks! Dave Peterson . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I conditionally UNLOCK a cell? | Chris | Worksheet Functions | 1 | August 31st, 2004 07:47 PM |
Looks Like a Pivot Table But Isn't... | MCorrea | Worksheet Functions | 3 | June 9th, 2004 10:47 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |