branch code

[msk1972]

Please check the following, if i pick branch code then it must automatically get those entries which is related to branch code and leave the rest, i am facing below mentioned issue, kindly resolve it on urgent basis.

Code Nam De. Account No. Br. Code Amount
1212-1 Sarfaraz C.O 04900035214203 12450 15000
1212-2 Danish C.O 04900035214203 12450 15000
1212-3 Akber P.O 04900035214203 12453 10000
1212-4 Muneer P.O 04900035214203 12453 10000
1212-5 Asim G.O 04900035214203 12454 8000
1212-6 Farhan G.O 04900035214203 12454 8000
1212-7 Nauman G.O 04900035214203 12454 8000
1212-8 Sohail L.O 04900035214203 12455 7000
1212-9 Faraz L.O 04900035214203 12456 7000
1213-1 Saqib F.O 04900035214203 12456 6000
1213-2 Sumair F.O 04900035214203 12456 6000
1213-3 Faizan F.O 04900035214203 12456 6000
1213-4 Imran S.O 04900035214203 12450 5000


Bank : HBL Br. Code: 12454

Code Name De Account Amount
1212-7 Nauman G.O 04900035214203 8000
1212-7 Nauman G.O 04900035214203 8000
1212-7 Nauman G.O 04900035214203 8000
1212-7 Nauman G.O 04900035214203 8000
1212-7 Nauman G.O 04900035214203 8000
1212-7 Nauman G.O 04900035214203 8000

 

[Ruddles]

In what way do you 'pick' the branch code and what do want done with the data which you 'get'?

Have you tried applying a simple filter to the branch code? That would seem to do what you're describing.

Your data isn't very clear - take a look at your post. You might be able to interpret it because you're familiar with it but as far as everyone else is concerned it would be much clearer if you were to place borders around your worksheet cells before pasting them into your message.

 

[anandvarma]

try this

array formulas

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Code	NameDe	AccountNo	BRCode	Amount		UNIQUE LIST	Dropdownlist	12456	4
2	1212-1	Sarfaraz C.O	4900035214203	12450	15000		12450
3	1212-2	Danish C.O	4900035214203	12450	15000		12453		Code	NameDe	AccountNo	BRCode	Amount
4	1212-3	Akber P.O	4900035214203	12453	10000		12454		1212-9	Faraz L.O	4900035214203	12456	7000
5	1212-4	Muneer P.O	4900035214203	12453	10000		12455		1213-1	Saqib F.O	4900035214203	12456	6000
6	1212-5	Asim G.O	4900035214203	12454	8000		12456		1213-2	Sumair F.O	4900035214203	12456	6000
7	1212-6	Farhan G.O	4900035214203	12454	8000				1213-3	Faizan F.O	4900035214203	12456	6000
8	1212-7	Nauman G.O	4900035214203	12454	8000
9	1212-8	Sohail L.O	4900035214203	12455	7000
10	1212-9	Faraz L.O	4900035214203	12456	7000
11	1213-1	Saqib F.O	4900035214203	12456	6000
12	1213-2	Sumair F.O	4900035214203	12456	6000
13	1213-3	Faizan F.O	4900035214203	12456	6000
14	1213-4	Imran S.O	4900035214203	12450	5000
15
16
Sheet1

#VALUE!

</td></tr><tr><td ><a href="http://www.online-excel.de/excel/singsel.php?f=60" style="font-family:Arial; font-size:8pt;font-weight:bold;color:#000080;" target='_blank'>Namen verstehen</a></td></tr></table></td></tr></table> <table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#0000ff;background-color:#ffFCF9; color:#000000; "><tr><td ><b>Data Validation in Spreadsheet</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Allow</td><td >Datas</td><td >Input 1</td><td >Input 2</td></tr><tr><td >I1</td><td >List</td><td > </td><td >=$G$2:$G$6</td><td > </td></tr></table></td></tr></table>

 

[Peter_SSs]

anandvarma

When using Excel jeanie, please use the ‘Analyse range (Forum)’ field near the top left to restrict the number of formulas generated. There is generally no need to display multiple formulas that are basically the same, it just fills up the board and makes your post and the whole thread difficult to read.

 

[anandvarma]

anandvarma

When using Excel jeanie, please use the ‘Analyse range (Forum)’ field near the top left to restrict the number of formulas generated. There is generally no need to display multiple formulas that are basically the same, it just fills up the board and makes your post and the whole thread difficult to read.

Dear Peter_SS
I am very very Sorry for that, from next time onwards i will follow that
kindly bear for this time

regards
anand varma

 

[Peter_SSs]

Dear Peter_SS
I am very very Sorry for that, from next time onwards i will follow that
kindly bear for this time

regards
anand varma

Anand

No problem - it took me a while to discover that field and its use too.