| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
listing unmatched items!
hi! i am having the following data in A1:B22 1000 DR 1000 CR 1500 DR 1000 DR 2000 DR 1000 DR 1500 CR 2000 CR 1000 DR 1000 CR 1000 DR 2000 CR 2000 DR 1500 CR 1000 CR 3000 DR 1000 CR 4000 DR 3000 CR 2000 DR 2000 CR 1500 DR here in the list 1000 DR - 5 rec 1000 CR - 4 rec 1500 DR - 2 rec 1500 CR - 2 rec 2000 DR - 2 rec 2000 CR - 3 rec 3000 DR - 2 rec 3000 CR - 1 rec 4000 DR - 1 rec 4000 CR - nil what i want is to shortlist the records 1000 DR 2000 CR 3000 DR 4000 DR using worksheet function in COL C to mark some flag like "matched", "unmatched" hopes that explained the things better!! -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=561822 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| flagging unmatched items!!! | Excel Worksheet Functions | |||
| Listing all items only once | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
