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
|