We help IT Professionals succeed at work.

Excel Formula

HI all,

I need a formula (if statement) to perform the following:

 if employee number (col A) is the same as the one above
 then
the  sal date (col c) of the row above -1
Comment
Watch Question

Most Valuable Expert 2011
Top Expert 2011
Commented:
You didn't specify what to do if it's not the same data in col A, but basically:

=IF(A2=A1,C1-1,"")

Author

Commented:
Thank you!