| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
What's the OR for?
It's doing nothing! Nevermind, I see! Biff "Biff" wrote in message ... What's the OR for? It's doing nothing! Biff "Domenic" wrote in message ... Assuming that A1:A10 contains your data, try the following... B1: Leave empty B2, copied down: =IF(OR(COUNTIF($B$1:B1,A1:$A$10)=0),INDEX(A1:$A$10 ,MATCH(0,COUNTIF($B$1:B 1,A1:$A$10),0)),"") ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Peter" wrote: I want to extract the unique records from column A into column B by formula ie: NOT using the Advanced Filter. Any ideas? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modifying a Formula To display only Unique Values | Excel Worksheet Functions | |||
| Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Hybrid Mode
