View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Adding add columns and not getting duplication

Hi
try something like
=IF(D1=B1,...)

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im Newsbeitrag
...
new dilema

example

Columns A B C D E G H
03/03/04 03/04/04 2 03/04/04 03/06/04 3 4
03/04/04 03/06/04 3 3

I have my first column directing the appropriate days of
payment -- but I have a new dilema - if I put this formula
in my second column for additional service different
place - I duplicate a date by adding them - is there a way
to get my column H to recognize if column B and D have a
duplicated date of service ? This is the only way to get
the total months pay to come out right -

Thank you

Katherine