Example:
Source Table Array as per below:
|
Employee
Name
|
Basic
|
DA
|
Trans
|
PF
|
Total
|
|
Joseph
|
5000
|
2500
|
1000
|
600
|
9100
|
|
McCulum
|
7000
|
3500
|
1000
|
840
|
12340
|
|
Denial
|
9000
|
4500
|
1000
|
1080
|
15580
|
|
Desosa
|
12000
|
6000
|
1000
|
1440
|
20440
|
|
Rechard
|
15000
|
7500
|
1000
|
1800
|
25300
|
Now same formula add in every cell only column no. change as per required data
See Above formula in formula bar I have using multiple value comparison and given Total
