You are not logged in.
Pages: 1
Bob, any idea sir
Phrontister,
Kindly look my first post. Index, match large used without cse first match come. Then we press cse,first match number it's shows all numbers in single comma separated in one cell without helper column.
Phrontister Sir,
Thank u. Without concatenate, textjoin, only use array formula index match large to get answers in one cell. I need help... First post.
All answers in single comma separated cell in d1 with descending order, without repeat numbers in excel. What formula need that
Need less or equal to 5.answer must be single cell in d1 itself 5,3,2,1.
Array formula need in excel
Sir, first of thank you for your nice help. I simply explain a1 is 2, a2 is 7,a3 is 1, a4 is 3,a5 is 1.b1 is search value is 5 less or equal to, then return all numbers, descending order, in one cell d1 itself single comma separated cell . Answer in d1 3,2,1.
i need excel help.a1:a6 base values of b1:b6.In c1:c3 search values500,400,300.a1 is 300,b1 is 285,a2 is 400,b2 is 350,a3 is 300,b3 is 290,a4 is 500,b4 is 467,a5 is 300,b5 is 285,a6 is 400,b6 is 320.I need display in d1 is 467,like d2 is 350,320.in same cell,d3 ans 290,285.That is number value one time in single cell with commos with descending order.kindly help me sir.
Pages: 1