Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formulae
I have in WB A four cols, (Date,Details,Credits,Debits) which are
constant and rows which are added to every day. In WB B colA I would like a formula which enters the date and in colC either Debit or Credit, provided that certain criteria are met. e.g if the entry under Details (WB A) says Mr Johns then the date of that entry and the Credit amount would appear in WB B, colA being for the date and colC for the amount I hope this makes sense and that someone can help. Regards Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulae | Excel Discussion (Misc queries) | |||
formulae | New Users to Excel | |||
FORMULAE | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Formulae | Excel Discussion (Misc queries) |