c*********7
发帖数: 56 | 1 type name result
1 Yev Yev
2 com Yev
1 Ign Ign
2 com Ign
3 eq Ign
First two columns are the inputs, the third column is the desired output.
logic: If type>=1, result column will return last upper name corresponding
to type 1.
I saw someone used a really simple If function to realize it. But I can't
figure it out. Please help...............................
Thanks a lot! | t*****z
发帖数: 812 | | e*d
发帖数: 25 | 3 =if(a2=1,b2,c1)
then filter down |
|
