Dear Expert ,
mujhe excel pe ek formula lagana hai , example di hai mene excel ki , mujhe count walay column mein ek aisa formula lagana hai kay jis se yeh pata chal sake kay CNIC wale column mein jo pehla cnic hai wo same kitne hain , jaise S-No 1 mein jo cnic hai wo poray column mein kitni bar same aye hain , S-No 2 mein jo cnic hai wo kitni bar same aye hain ,, kab se koshish ker raha hon per formula nahi lag para hai , pls koi help ker do ,,

S-No Req Date Name CNIC Count
1 26-Apr M-Irfan 4220102373431 Formula Required
2 27-Apr salman 4220177897818
3 28-Apr suhail 4220177897815
4 29-Apr raheel 4210177858510
5 30-Apr tahir 4220102373551
6 1-May IrfanRufi 4220102373431
7 2-May tahir 4220102373551
8 3-May Irfan 4220102373431
9 4-May salman 4220177897818
10 5-May suhail 4220177897815
11 6-May raheel 4210177858510
12 7-May tahir 4220102373551
13 8-May Irfan 4220102373431
14 9-May tahir 4220102373551
15 10-May Irfan 4220102373431
16 11-May Irfan 4220102373431