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

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

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

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

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

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

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