Excel 2016 (Windows) 64 bit
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
1 |
Drawer |
Drawee Bank |
Inst. No. |
|
Drawer |
Drawee Bank |
Inst. No.1 |
Inst. No.2 |
Inst. No.3 |
Inst. No.4 |
Inst. No.5 |
Inst. No.6 |
Inst. No.7 |
Inst. No.8 |
Inst. No.9 |
Inst. No.10 |
2 |
AADYASREE ENTERPRISES |
1000001343 |
395448 |
|
AADYASREE ENTERPRISES |
1000001343 |
395448 |
395450 |
|
|
|
|
|
|
|
|
3 |
AADYASREE ENTERPRISES |
1000001343 |
395450 |
|
ADARSHA HOSIERIES - BANGALORE |
1000000331 |
409787 |
409788 |
649474 |
649480 |
649521 |
|
|
|
|
|
4 |
ADARSHA HOSIERIES - BANGALORE |
1000000331 |
409787 |
|
ANJANADRI MARKETING |
1000001458 |
208342 |
208344 |
|
|
|
|
|
|
|
|
5 |
ADARSHA HOSIERIES - BANGALORE |
1000000331 |
409788 |
|
ARIHANT ENTERPRISE - CHENNAI |
1000000416 |
068900 |
|
|
|
|
|
|
|
|
|
6 |
ADARSHA HOSIERIES - BANGALORE |
1000000331 |
649474 |
|
B L TEXTILE |
1000001373 |
042307 |
|
|
|
|
|
|
|
|
|
7 |
ADARSHA HOSIERIES - BANGALORE |
1000000331 |
649480 |
|
B M ENTERPRISES - ERNAKULAM |
1000000380 |
075225 |
075230 |
077624 |
077625 |
|
|
|
|
|
|
8 |
ADARSHA HOSIERIES - BANGALORE |
1000000331 |
649521 |
|
|
|
|
|
|
|
|
|
|
|
|
|
9 |
ANJANADRI MARKETING |
1000001458 |
208342 |
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
ANJANADRI MARKETING |
1000001458 |
208344 |
|
|
|
|
|
|
|
|
|
|
|
|
|
11 |
ARIHANT ENTERPRISE - CHENNAI |
1000000416 |
068900 |
|
|
|
|
|
|
|
|
|
|
|
|
|
12 |
B L TEXTILE |
1000001373 |
042307 |
|
|
|
|
|
|
|
|
|
|
|
|
|
13 |
B M ENTERPRISES - ERNAKULAM |
1000000380 |
075225 |
|
|
|
|
|
|
|
|
|
|
|
|
|
14 |
B M ENTERPRISES - ERNAKULAM |
1000000380 |
075230 |
|
|
|
|
|
|
|
|
|
|
|
|
|
15 |
B M ENTERPRISES - ERNAKULAM |
1000000380 |
077624 |
|
|
|
|
|
|
|
|
|
|
|
|
|
16 |
B M ENTERPRISES - ERNAKULAM |
1000000380 |
077625 |
|
|
|
|
|
|
|
|
|
|
|
|
|
E2
Formula:
=IFERROR(INDEX(A$2:A$16,MATCH(0,INDEX(COUNTIFS(E$1:E1,A$2:A$16),),0)),"")
Copy across F column.
G2
Copy across as far Inst No need
Bookmarks