Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
please find the below excel table
now i want create output column
if FCC=DCC if values are matching i want add all the matching vaues sum to output column
for example in FCC column four 7081 values are there
the sum of 7081 value is 7000
now i want add this sum to DCC Column, in DCC Column So many 7081
when ever 7081 is there i wnat add 7000 .
for all the values same logic
for example in FCC column 157602 is there but in DCC Column no 157602 for that i want to show zero values
and also i want to show zero if not matching.
DCC | FCC | State | Amount | Output |
7042 | 157602 | a | 10000 | 0 |
7053 | 7081 | b | 5000 | 0 |
7055 | 157840 | c | 3000 | 0 |
7057 | 7081 | d | -220 | 0 |
7057 | 7081 | e | -1780 | 0 |
7080 | 7081 | f | 4000 | 0 |
7081 | 121083 | g | 1374.6 | 7000 |
7081 | 17407 | h | 1354.2 | 7000 |
7081 | 415878 | u | 739.8 | 7000 |
7081 | 4245 | i | 489.6 | 7000 |
7081 | 37881 | k | 73.2 | 7000 |
7081 | 80529 | l | 604.2 | 7000 |
7081 | 412053 | m | 104.4 | 7000 |
7081 | 424849 | n | 791.4 | 7000 |
7081 | 425549 | f | 468.6 | 7000 |
1