Filter data to another sheet by cell value

[bosco_yip]

I need one more help in this sheet, can you please help me again.

as all the things you have told me worked good for me, now what I need is I need to bifurcate more data from this. I attached the file again, updating a Column in Table. Please check and Let me know that can it be more filtered differently

Try.........

1] Set up a unique list for "Ledcode" in AL2:AL65

2] Select C3 >> Data >> Data Validation >>
>> Allow : List
>>Source : =$AL$2:$AL$65

3] In C3, click for dropdown List and select "Ledcode"

4] In H21, formula copied down :

=IF($G21="","",INDEX(DB!$A$1:$A$200,AGGREGATE(15,6,ROW($A$1:$A$200)/(DB!$F$1:$F$200=$C$3),ROWS($1:1))))

5] In L21, formula copied across :

=IF($K21="","",IFERROR(INDEX(DB!$A$1:$A$200,AGGREGATE(15,6,ROW($A$1:$A$200)/(DB!$F$1:$F$200=$C$3),COLUMNS($A:A))),""))

6] See attached file

Regards
Bosco

 

[JAlandhar 201718]

Try.........

1] Set up a unique list for "Ledcode" in AL2:AL65

2] Select C3 >> Data >> Data Validation >>
>> Allow : List
>>Source : =$AL$2:$AL$65

3] In C3, click for dropdown List and select "Ledcode"

4] In H21, formula copied down :

=IF($G21="","",INDEX(DB!$A$1:$A$200,AGGREGATE(15,6,ROW($A$1:$A$200)/(DB!$F$1:$F$200=$C$3),ROWS($1:1))))

5] In L21, formula copied across :

=IF($K21="","",IFERROR(INDEX(DB!$A$1:$A$200,AGGREGATE(15,6,ROW($A$1:$A$200)/(DB!$F$1:$F$200=$C$3),COLUMNS($A:A))),""))

6] See attached file

Regards
Bosco

your process is good sir, but I need to filter data with the sub-ledger values in the table, like if there is a same voucher number for the LED CODE, it must be filtered with the sub ledger value, as shown in excel before.



[[and sir please check the Screenshot for other query we talked about.

I applied the formula from your sheet, but it is not calculating]]

 

[JAlandhar 201718]

Please help me in this file,


PART - 1 , THE NARRATION COLUMN SHOULD BE DEFINED FROM THE
TABLE FROM SHEET "D2K16", AS
VOU NO - 170034, WITH AMOUNT 200 , THE NARRATION SHOULD BE FROM "MONTH R FOLLOWED BY YEAR" AS "APRIL 2016", THE 4 MUST SHOW THE MONTH OF YEAR.
THE LAST DATE AS ON 31/03/17 SHOW 0 AMOUNT, IF THE AMOUNT IS 0 IN THIS COLUMN IT MUST TAKE THE AMOUNT FROM [D2K16!H2:H25] AS FOR EXAMPLE IT SHOWS 4212, SO THE AMOUNT MUST CHANGED FROM 0 TO 4212
THE DATE MUST BE IN SEQUENCE AS VIEWED
CAN THE NARRATION OR NARR1 EDITABLE, AS I JUST NEED ONE "DIVIDENT" IF IT CONTAIN DIVIDENT IN THE LINE