What formula to be used

[loknathmondal]

Hi,

I have huge data which has lakhs of rows in excel

I want get the reward column to be filled automatically by using formula.

1. If a customer earns 225 points in any Quarter he will get Mango.
2. If a customer earns 450 points (225 points any qrt+ 225 points any qrt) in any 2 Quarter he will get Banana.
3. If a customer earns 700 points (225 points any qrt+ 225 points any qrt + 250 points any qrt) in any 3 Quarter he will get Apple.
4. If a customer earns 850 points (225 points any qrt+ 225 points any qrt + 225 points any qrt +175 points any qrt) in any 4 Quarter he will get Orange.

Data Given below.

[TABLE="width: 604"]
<colgroup><col><col><col span="4"><col></colgroup><tbody>[TR]
[TD]SRNo[/TD]
[TD]Customer Name[/TD]
[TD]Qrt 1 - Point[/TD]
[TD]Qrt 2 - Point[/TD]
[TD]Qrt 3 - Point[/TD]
[TD]Qrt 4 - Point[/TD]
[TD]Reward[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A. Edwin [/TD]
[TD]1023[/TD]
[TD]1988[/TD]
[TD]1731[/TD]
[TD]354[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A.ISMAIL[/TD]
[TD]539[/TD]
[TD]741[/TD]
[TD]624[/TD]
[TD]246[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]A.Koteswararao[/TD]
[TD]595[/TD]
[TD]293[/TD]
[TD]256[/TD]
[TD]305[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]A.Nagaraju[/TD]
[TD]1180[/TD]
[TD]426[/TD]
[TD]5959[/TD]
[TD]5816[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]A.p Srivastav[/TD]
[TD]647[/TD]
[TD]448[/TD]
[TD]1059[/TD]
[TD]189[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]A K DAS[/TD]
[TD]0[/TD]
[TD]305[/TD]
[TD]760[/TD]
[TD]328[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]A Shankar[/TD]
[TD]463[/TD]
[TD]78[/TD]
[TD]882[/TD]
[TD]447[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]A sudhakar[/TD]
[TD]988[/TD]
[TD]309[/TD]
[TD]696[/TD]
[TD]28[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]A TRINATH REDDY[/TD]
[TD]414[/TD]
[TD]268[/TD]
[TD]649[/TD]
[TD]54[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]A.M.Babu[/TD]
[TD]244[/TD]
[TD]705[/TD]
[TD]364[/TD]
[TD]28[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]A.Madhu[/TD]
[TD]576[/TD]
[TD]262[/TD]
[TD]260[/TD]
[TD]27[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]A.RAMA RAO[/TD]
[TD]579[/TD]
[TD]491[/TD]
[TD]460[/TD]
[TD]127[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]A.SAIDULU[/TD]
[TD]827[/TD]
[TD]1048[/TD]
[TD]673[/TD]
[TD]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]A.Venkateswarao[/TD]
[TD]136[/TD]
[TD]254[/TD]
[TD]378[/TD]
[TD]434[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]AVISHEK .[/TD]
[TD]0[/TD]
[TD]1165[/TD]
[TD]2721[/TD]
[TD]380[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]AADHI NARAYAN[/TD]
[TD]81[/TD]
[TD]306[/TD]
[TD]318[/TD]
[TD]569[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]1.SK JALAL UDDIN 1.SK JALAL UDDIN[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]71[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]11.DHARADHAR SARDAR 11.DHARADHAR SARDAR[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]263[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]27.JIKIRIA SK 27.JIKIRIA SK[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]137[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]3.LAXMIRAM MURMU 3.LAXMIRAM MURMU[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]33.SIRAJUDDIN SK 33.SIRAJUDDIN SK[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]283[/TD]
[TD]235[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]4.GHOSTHO GOPAL DAS 4.GHOSTHO GOPAL DAS[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]472[/TD]
[TD]363[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]SUDHOY LOHAR[/TD]
[TD]0[/TD]
[TD]48[/TD]
[TD]350[/TD]
[TD]125[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]Shibu[/TD]
[TD]54[/TD]
[TD]21[/TD]
[TD]28[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]A MALLESWARAN .[/TD]
[TD]230[/TD]
[TD]45[/TD]
[TD]57[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]A MANI A MANI[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]722[/TD]
[TD]145[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]A Manivel[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]54[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]A MIDYA[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]A MONDAL[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]A MONDAL[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]A MURTHY [/TD]
[TD]0[/TD]
[TD]34[/TD]
[TD]93[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]ZASIMUDDIN SEKH[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]206[/TD]
[TD]99[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]ZASIR AHEMAD .[/TD]
[TD]0[/TD]
[TD]61[/TD]
[TD]209[/TD]
[TD]7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]ZATTAR[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]435[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]Zaved bhai[/TD]
[TD]323[/TD]
[TD]724[/TD]
[TD]257[/TD]
[TD]219[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]Zaveri Shah[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1734[/TD]
[TD]356[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]ZAWADUL[/TD]
[TD]834[/TD]
[TD]1173[/TD]
[TD]2101[/TD]
[TD]2682[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]ZAWED[/TD]
[TD]310[/TD]
[TD]328[/TD]
[TD]232[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]ZAWED KHAN[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]156[/TD]
[TD]366[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]ZAYED ALI[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]31[/TD]
[TD]0[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 604"]
<tbody>[TR]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

what formula i can use on this excel sheet
and there is lakhs of rows in the excel sheet.


Regards
Loknath

 

[PCL]

"1. If a customer earns 225 points in any Quarter he will get Mango"
=> it means at least 225 or exactly 225
the same for others

 

[Cornejo]

You could try this:

=IF(SUM(C3:F3)>=850,"Orange",IF(SUM(C3:F3)>=700,"Apple",IF(SUM(C3:F3)>=450,"Banana",IF(C3>=225,"Mango",IF(D3>=225,"Mango",IF(E3>=225,"Mango",IF(F3>=225,"Mango","")))))))

Manipulate the cell references as needed. Then drag or auto-fill to the end of your data.

 

[jtakw]

1. If a customer earns 225 points in any Quarter he will get Mango.
2. If a customer earns 450 points (225 points any qrt+ 225 points any qrt) in any 2 Quarter he will get Banana.
3. If a customer earns 700 points (225 points any qrt+ 225 points any qrt + 250 points any qrt) in any 3 Quarter he will get Apple.
4. If a customer earns 850 points (225 points any qrt+ 225 points any qrt + 225 points any qrt +175 points any qrt) in any 4 Quarter he will get Orange.

Loknath

Hi,

I don't think OP is Just looking for the Total score for the rankings, this is what I believe OP wants according to his description:

Book1
	A	B	C	D	E	F	G
1	SRNo	Customer Name	Qrt 1 - Point	Qrt 2 - Point	Qrt 3 - Point	Qrt 4 - Point	Reward
2	1	A. Edwin	1023	1988	1731	354	Orange
3	2	A.ISMAIL	539	741	624	246	Orange
4	3	A.Koteswararao	595	293	256	305	Orange
5	4	A.Nagaraju	1180	426	5959	5816	Orange
6	5	A.p Srivastav	647	448	1059	189	Orange
7	6	A K DAS	0	305	760	328	Apple
8	7	A Shankar	463	78	882	447	Apple
9	8	A sudhakar	988	309	696	28	Apple
10	9	A TRINATH REDDY	414	268	649	54	Apple
11	10	A.M.Babu	244	705	364	28	Apple
12	11	A.Madhu	576	262	260	27	Apple
13	12	A.RAMA RAO	579	491	460	127	Apple
14	13	A.SAIDULU	827	1048	673	3	Apple
15	14	A.Venkateswarao	136	254	378	434	Apple
16	15	AVISHEK .	0	1165	2721	380	Apple
17	16	AADHI NARAYAN	81	306	318	569	Apple
18	17	1.SK JALAL UDDIN 1.SK JALAL UDDIN	0	0	0	71	Not a Winner
19	18	11.DHARADHAR SARDAR 11.DHARADHAR SARDAR	0	0	263	0	Mango
20	19	27.JIKIRIA SK 27.JIKIRIA SK	0	0	137	0	Not a Winner
21	20	3.LAXMIRAM MURMU 3.LAXMIRAM MURMU	0	0	500	0	Mango
22	21	33.SIRAJUDDIN SK 33.SIRAJUDDIN SK	0	0	283	235	Banana
23	22	4.GHOSTHO GOPAL DAS 4.GHOSTHO GOPAL DAS	0	0	472	363	Banana
24	23	SUDHOY LOHAR	0	48	350	125	Mango
25	24	Shibu	54	21	28	0	Not a Winner
26	25	A MALLESWARAN .	230	45	57	0	Mango
27	26	A MANI A MANI	0	0	722	145	Mango
28	27	A Manivel	0	0	54	0	Not a Winner
29	28	A MIDYA	0	0	2	0	Not a Winner
30	29	A MONDAL	0	1	0	0	Not a Winner
31	30	A MONDAL	0	0	2	0	Not a Winner
32	31	A MURTHY	0	34	93	0	Not a Winner
33	32	ZASIMUDDIN SEKH	0	0	206	99	Not a Winner
34	33	ZASIR AHEMAD .	0	61	209	7	Not a Winner
35	34	ZATTAR	0	0	0	435	Mango
36	35	Zaved bhai	323	724	257	219	Orange
37	36	Zaveri Shah	0	0	1734	356	Banana
38	37	ZAWADUL	834	1173	2101	2682	Orange
39	38	ZAWED	310	328	232	0	Apple
40	39	ZAWED KHAN	0	0	156	366	Mango
41	40	ZAYED ALI	0	0	31	0	Not a Winner
Sheet57

Cell Formulas
Range	Formula
G2	=CHOOSE(IF(AND(COUNTIF(C2:F2,">=225")>=3,MIN(C2:F2)>=175),1,IF(AND(COUNTIF(C2:F2,">=225")>=3,COUNTIF(C2:F2,">=250")>=1),2,IF(COUNTIF(C2:F2,">=225")>=2,3,IF(COUNTIF(C2:F2,">=225")>=1,4,5)))),"Orange","Apple","Banana","Mango","Not a Winner")

G2 formula copied down.

 

[Cornejo]

Ahhhhh, I should've read more into that. Great solution.

 

[loknathmondal]

Hi,

I don't think OP is Just looking for the Total score for the rankings, this is what I believe OP wants according to his description:

	A	B	C	D	E	F	G
SRNo	Customer Name	Qrt 1 - Point	Qrt 2 - Point	Qrt 3 - Point	Qrt 4 - Point	Reward
A. Edwin	Orange
A.ISMAIL	Orange
A.Koteswararao	Orange
A.Nagaraju	Orange
A.p Srivastav	Orange
A K DAS	Apple
A Shankar	Apple
A sudhakar	Apple
A TRINATH REDDY	Apple
A.M.Babu	Apple
A.Madhu	Apple
A.RAMA RAO	Apple
A.SAIDULU	Apple
A.Venkateswarao	Apple
AVISHEK .	Apple
AADHI NARAYAN	Apple
1.SK JALAL UDDIN 1.SK JALAL UDDIN	Not a Winner
11.DHARADHAR SARDAR 11.DHARADHAR SARDAR	Mango
27.JIKIRIA SK 27.JIKIRIA SK	Not a Winner
3.LAXMIRAM MURMU 3.LAXMIRAM MURMU	Mango
33.SIRAJUDDIN SK 33.SIRAJUDDIN SK	Banana
4.GHOSTHO GOPAL DAS 4.GHOSTHO GOPAL DAS	Banana
SUDHOY LOHAR	Mango
Shibu	Not a Winner
A MALLESWARAN .	Mango
A MANI A MANI	Mango
A Manivel	Not a Winner
A MIDYA	Not a Winner
A MONDAL	Not a Winner
A MONDAL	Not a Winner
A MURTHY	Not a Winner
ZASIMUDDIN SEKH	Not a Winner
ZASIR AHEMAD .	Not a Winner
ZATTAR	Mango
Zaved bhai	Orange
Zaveri Shah	Banana
ZAWADUL	Orange
ZAWED	Apple
ZAWED KHAN	Mango
ZAYED ALI	Not a Winner

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1023[/TD]
[TD="align: right"]1988[/TD]
[TD="align: right"]1731[/TD]
[TD="align: right"]354[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]539[/TD]
[TD="align: right"]741[/TD]
[TD="align: right"]624[/TD]
[TD="align: right"]246[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]595[/TD]
[TD="align: right"]293[/TD]
[TD="align: right"]256[/TD]
[TD="align: right"]305[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]1180[/TD]
[TD="align: right"]426[/TD]
[TD="align: right"]5959[/TD]
[TD="align: right"]5816[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]5[/TD]

[TD="align: right"]647[/TD]
[TD="align: right"]448[/TD]
[TD="align: right"]1059[/TD]
[TD="align: right"]189[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]305[/TD]
[TD="align: right"]760[/TD]
[TD="align: right"]328[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]7[/TD]

[TD="align: right"]463[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]882[/TD]
[TD="align: right"]447[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]8[/TD]

[TD="align: right"]988[/TD]
[TD="align: right"]309[/TD]
[TD="align: right"]696[/TD]
[TD="align: right"]28[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]9[/TD]

[TD="align: right"]414[/TD]
[TD="align: right"]268[/TD]
[TD="align: right"]649[/TD]
[TD="align: right"]54[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]244[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]364[/TD]
[TD="align: right"]28[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]11[/TD]

[TD="align: right"]576[/TD]
[TD="align: right"]262[/TD]
[TD="align: right"]260[/TD]
[TD="align: right"]27[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]12[/TD]

[TD="align: right"]579[/TD]
[TD="align: right"]491[/TD]
[TD="align: right"]460[/TD]
[TD="align: right"]127[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]13[/TD]

[TD="align: right"]827[/TD]
[TD="align: right"]1048[/TD]
[TD="align: right"]673[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]14[/TD]

[TD="align: right"]136[/TD]
[TD="align: right"]254[/TD]
[TD="align: right"]378[/TD]
[TD="align: right"]434[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]15[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1165[/TD]
[TD="align: right"]2721[/TD]
[TD="align: right"]380[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]16[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]306[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]569[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]17[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]71[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]18[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]263[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]137[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]20[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]21[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]283[/TD]
[TD="align: right"]235[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]22[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]472[/TD]
[TD="align: right"]363[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]23[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]125[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]24[/TD]

[TD="align: right"]54[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]25[/TD]

[TD="align: right"]230[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]26[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]722[/TD]
[TD="align: right"]145[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]27[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]28[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]29[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]30[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]31[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]32[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]206[/TD]
[TD="align: right"]99[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]33[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]209[/TD]
[TD="align: right"]7[/TD]

[TD="align: center"]35[/TD]
[TD="align: right"]34[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]435[/TD]

[TD="align: center"]36[/TD]
[TD="align: right"]35[/TD]

[TD="align: right"]323[/TD]
[TD="align: right"]724[/TD]
[TD="align: right"]257[/TD]
[TD="align: right"]219[/TD]

[TD="align: center"]37[/TD]
[TD="align: right"]36[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1734[/TD]
[TD="align: right"]356[/TD]

[TD="align: center"]38[/TD]
[TD="align: right"]37[/TD]

[TD="align: right"]834[/TD]
[TD="align: right"]1173[/TD]
[TD="align: right"]2101[/TD]
[TD="align: right"]2682[/TD]

[TD="align: center"]39[/TD]
[TD="align: right"]38[/TD]

[TD="align: right"]310[/TD]
[TD="align: right"]328[/TD]
[TD="align: right"]232[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]40[/TD]
[TD="align: right"]39[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]366[/TD]

[TD="align: center"]41[/TD]
[TD="align: right"]40[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]0[/TD]

</tbody>

Sheet57​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G2[/TH]
[TD="align: left"]=CHOOSE(IF(AND(COUNTIF(C2:F2,">=225")>=3,MIN(C2:F2)>=175),1,IF(AND(COUNTIF(C2:F2,">=225")>=3,COUNTIF(C2:F2,">=250")>=1),2,IF(COUNTIF(C2:F2,">=225")>=2,3,IF(COUNTIF(C2:F2,">=225")>=1,4,5)))),"Orange","Apple","Banana","Mango","Not a Winner")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



G2 formula copied down.

Thanks a lot.

Really appreciated.


Regards
Loknath

 

[jtakw]

You're welcome.