Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help in countif formula.
i have this table, wherein i wanted to have output in column3 names of those
who appears in column1 and column2 i.e. name1 name2 jasper aileen rd jasper jp norman aimee jojo cris aimee but as i use this formula - =if(countif(a:a,"=" & b1)0,B1,""), this is what happens, name1 name2 name3 jasper aileen rd jasper jasper jp norman aimee jojo cris aimee aimee is it possible for me to be able to line them properly at the top? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
countif formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
COUNTIF formula problems | Excel Discussion (Misc queries) | |||
Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions |