Forum Discussion

erictabak's avatar
erictabak
Copper Contributor
Dec 10, 2021

How to find a specific number from 2 columns

Source number Wanted outcome Question: a 1 Number is only from source a I like to know from what source is the number coming from? a 1 Number is from source a and b Is it alone from...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Dec 10, 2021

erictabak 

=CHOOSE(SUM((COUNTIFS($A$2:$A$10,{"a","b"},$B$2:$B$10,B2)>0)*{1,2}),"a","b","a/b")

 

erictabak's avatar
erictabak
Copper Contributor
Dec 11, 2021
this looks like a possible outcome aswell, it is a shorter route. I have to translate the formula in dutch excel, so i can't say if it's working well at this moment. Thank you for helping me.

Resources