Hi Mr. Excel users,
Is it possible for Curly brackets to produce a Cell Value answer?
Example..
In this case, a:a values are unique numbers, therefore, 1 is the only answer I can get in b:b
={if(a:a=1,b:b)}... now, what formula should I use to get the value align in b:b?
Is it possible for Curly brackets to produce a Cell Value answer?
Example..
In this case, a:a values are unique numbers, therefore, 1 is the only answer I can get in b:b
={if(a:a=1,b:b)}... now, what formula should I use to get the value align in b:b?