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