| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare value in current cell to previous cell
Hello, I've got an Excel spreadsheet with a single column. The cells
contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare value in current cell to previous cell
see Chip Pearson's site for advice on dealing with duplicates:
http://www.cpearson.com/Excel/Duplicates.aspx "Bob Aloisi" wrote: Hello, I've got an Excel spreadsheet with a single column. The cells contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare value in current cell to previous cell
You could do it with a formula in another column, but a simple
solution is to use conditional formatting: Select cell A2 Select Format/Conditional Formatting... Change condition to Formula Type formula as =a1=a2 Change format (maybe using pattern and making it red would stand out for you) Use the format painter to add that formula to the rest of the values On Jan 24, 2:38 pm, Bob Aloisi wrote: Hello, I've got an Excel spreadsheet with a single column. The cells contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare value in current cell to previous cell
Hi Chip, thanks for your post. I reviewed your website and downloaded the
workbook but I did not find a solution to my problem, am I missing something? "Duke Carey" wrote: see Chip Pearson's site for advice on dealing with duplicates: http://www.cpearson.com/Excel/Duplicates.aspx "Bob Aloisi" wrote: Hello, I've got an Excel spreadsheet with a single column. The cells contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare value in current cell to previous cell
Hi, I'd prefer a formula to be used in a separate column, do you have one?
" wrote: You could do it with a formula in another column, but a simple solution is to use conditional formatting: Select cell A2 Select Format/Conditional Formatting... Change condition to Formula Type formula as =a1=a2 Change format (maybe using pattern and making it red would stand out for you) Use the format painter to add that formula to the rest of the values On Jan 24, 2:38 pm, Bob Aloisi wrote: Hello, I've got an Excel spreadsheet with a single column. The cells contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare value in current cell to previous cell
FYI - I'm not Chip
There is all kinds of information on Chip's site about dealing with duplicates Since you appear to want a formula, put this in B2 and copy it down =if(A1=A2,"Duplicate","Different") "Bob Aloisi" wrote: Hi Chip, thanks for your post. I reviewed your website and downloaded the workbook but I did not find a solution to my problem, am I missing something? "Duke Carey" wrote: see Chip Pearson's site for advice on dealing with duplicates: http://www.cpearson.com/Excel/Duplicates.aspx "Bob Aloisi" wrote: Hello, I've got an Excel spreadsheet with a single column. The cells contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare value in current cell to previous cell
Perfect, thank you.
"Duke Carey" wrote: FYI - I'm not Chip There is all kinds of information on Chip's site about dealing with duplicates Since you appear to want a formula, put this in B2 and copy it down =if(A1=A2,"Duplicate","Different") "Bob Aloisi" wrote: Hi Chip, thanks for your post. I reviewed your website and downloaded the workbook but I did not find a solution to my problem, am I missing something? "Duke Carey" wrote: see Chip Pearson's site for advice on dealing with duplicates: http://www.cpearson.com/Excel/Duplicates.aspx "Bob Aloisi" wrote: Hello, I've got an Excel spreadsheet with a single column. The cells contain a date & time (m/d/yyyy h:mm:ss). I'd like to compare the value in cell A2 to A1, then A3 to A2, A4 to A3, etc. to determine if it's a "duplicate" or "different". Can you help? THANK YOU |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Linear Mode
