| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
flagging unmatched items!!!
i am having the following data in A1:B22
COL A COL B 1000.00 DR 1000.00 CR 1000.00 DR 1000.00 DR 1000.00 DR 1000.00 DR 1000.00 CR 1000.00 CR 1000.00 DR 1000.00 CR 1000.00 DR 1000.00 CR 1000.00 DR 1000.00 CR 1000.00 CR 1000.00 DR 1000.00 CR 1000.00 DR 1000.00 CR 1000.00 DR 1000.00 CR 1000.00 DR what i want is to flag off the 2 items of 1000 in COL A which are unmatched with ref to COL B, ie) 1000.00 DR 1000.00 DR in COL C using appropriate formulae in C1: C22 hlp pl? -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200607/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Lookup items and have picture appear together. | Excel Worksheet Functions | |||
| Pareto's Law and ABCD ranking of items | Excel Discussion (Misc queries) | |||
| multiple items in database | Excel Worksheet Functions | |||
| Computing totals for tax and non-tax items | Excel Worksheet Functions | |||
Threaded Mode
