Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding add columns and not getting duplication
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding two Columns together | Excel Discussion (Misc queries) | |||
Adding two Columns | Excel Discussion (Misc queries) | |||
Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
adding columns | Excel Worksheet Functions | |||
Adding columns | Excel Discussion (Misc queries) |