• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Which formula will work for desired result .. pls do fast

J

jskushawah

New Member
[pre]
Code: 
Name	Jan	Feb	March	April	May
Vikas	120	90	132	138	133
Rohan	140	154	104	166	167
Shohan	135	154	102	147	123
Poonam	111	107	136	162	148
Radha	80	116	148	110	153
Ruchi	92	84	140	101	107
Savita	170	94	106	142	101
Sonam	128	124	156	88	136
Sani	143	125	167	109	102
Sahil	88	159	154	154	127
Ravi	120	139	115	156	106
Rakesh	70	156	96	127	139
Rajesh	67	131	169	165	144
Gaurav	135	106	122	145	88
[/pre]

in the above data, which formula I use so that i found salesman's name who made less than 100 sales in any month ???
 
With your data in A1:F15, enter this in any cell and drag down:


Code: 
=IFERROR(INDEX($A$2:$A$15,SMALL(IF($B$2:$F$15<100,ROW($B$2:$B$15)),ROW(A1))-1,0),"")


Press Ctl+Shift+Enter and drag down.


Regards,
 
Jitendra


Putting "pls do fast" does not help you. Members lead their lives and in their spare time give help to the forum free of charge, also it is a world wide site many members may be at work/inbed/eating ect.ect.


Faseeh you have quick and nimble fingers :)
 
Sir Actually one of my friend is facing interview, and this was his question, so I put pls do fast ,thanks for ur response ...
 
Hi, Jitendra!


It seems as it isn't fair enough using this kind of help. So sorry for the interviewer, it'd be very probable that the new hired resource wouldn't meet the expectations of the position.


Regards!
 
Guys. I think this does the same thing as Faseeh's formula. Can you tell me if this formula could be used as well?


=IF(ISNUMBER(IF($B$2:$F$15<100,ROW($B$2:$B$15))),$A$2:$A$15,0)
 
Hi Montrey,


Is it possible to check 16 * 5 matrix ,and return a 16 * 1.. I dont hope so.. either you need to work with MMULT or you can reduce the matrix to 16 * 1 by.


Code: 
=IF(MIN($B2:$F2)<100,$A2,"")
and to remove "", you need to use Small with Index..


Reards,

Deb
 
@SirJB7

Hi, myself!

So long...

Matrix 16? or even Matrix 5? Hmmm... am I missing something?

I only know 3 Matrix, Matrix, Matrix Reloaded and Matrix Revolution. And Keanu didn't tell me about further versions.

Regards!
 
@ Morpheus..

Is there any post is available in place of NEO.. someone showing his slow_motion_bullet_move in middle of the Trinity club..
 
@Mr.Fishburne!

Hi!

Could you book a couple of places very near and very close to Carrie-Ann Moss? With a friend we'd love to exercise those sweet and smooth movements... with her, I mean, gotcha?

Regards!
 
You must log in or register to reply here.
Back
Top