Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to select an invoice entry ?
Hi,
Let's consider the table below: A B C 1 Invoice Line code Selection 2 2010030101 18 A 3 2010030101 2 A 4 2010030102 3 B 5 2010030102 3 B 6 2010030103 18 A 7 2010030103 6 A 8 2010030104 4 B 9 2010030104 6 B 10 2010030105 5 B 11 2010030105 2 B 12 2010030106 1 A 13 2010030106 1 A 14 2010030106 18 A 15 2010030106 2 A May I know the formula to input at cell C2 in order to label each invoice batch as "A" when one of its line codes is "18" ? Otherwise label it as "B". Thanks Low |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to look up for the last entry ? | Excel Discussion (Misc queries) | |||
Excel 2002 date entry: Cannot get away from d-m-yy entry format | Excel Discussion (Misc queries) | |||
Excel 2002 : Can auto cell entry function more than once ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Is there any active row bar to aid data entry ? | Excel Discussion (Misc queries) | |||
error 1706 while tring to install "Sales Invoice" on Excel 2002 P | Charts and Charting in Excel |