| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up if a value from an array "A" is in either array "B" or
Welcome, glad it got you going there
-- Max Singapore "Francisco Rodriguez" wrote in message ... Thanks Max! The COUNTIF function was very helpful. I used on two new columns that checked each whether the items on file "C" were on file "A" or "B" respectively. Then I created another column with an IF contaistatement that returns an "x" for items that were NOT on "A" AND "B". Filtering for the "x" gives me my desired list. Thanks again! Francisco |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
