Need Help in a Data Table

[Santosh080]

hello Friends
i have a excel sheet like this.

MY MF.xlsx
	A	B	C	D	E
1	Dates	Debit	Credit	Interest	Balance
2	29-09-2011				100000.00
3	30-09-2011	5000	0	0	105000.00
4	01-10-2011	0	6000	0	99000.00
5	02-10-2011	0	0	0	99000.00
6	03-10-2011	0	0	0	99000.00
7	04-10-2011	0	0	0	99000.00
8	05-10-2011	0	0	0	99000.00
9	06-10-2011	0	0	0	99000.00
10	07-10-2011	0	0	0	99000.00
11	08-10-2011	0	0	0	99000.00
12	09-10-2011	0	0	0	99000.00
13	10-10-2011	0	0	1169	100169.00
14	11-10-2011	0	0	0	100169.00
15	12-10-2011	0	0	0	100169.00
16	13-10-2011	0	0	0	100169.00
17	14-10-2011	15000	0	0	115169.00
18	15-10-2011	0	0	0	115169.00
19	16-10-2011	0	0	0	115169.00
20	17-10-2011	0	0	0	115169.00
21	18-10-2011	0	3000	0	112169.00
22	19-10-2011	0	0	0	112169.00
23	20-10-2011	0	0	0	112169.00
24	21-10-2011	0	0	1547	113716.00
25	22-10-2011	0	0	0	113716.00
26	23-10-2011	0	0	0	113716.00
27	24-10-2011	0	0	0	113716.00
Sheet2

Cell Formulas
Range	Formula
E3:E27	E3	=E2+B3+D3-C3

I want to extract data like below table. Here i want ignore data where Debit,Credit,Interest,Balance all are "0" and extract data where data avaible. Please help me. Thanks

MY MF.xlsx
	I	J	K	L	M
1	Debit	Credit	Interest	Balance	Dates
2	0	0	0	100000.00	29-09-2011
3	0	6000	0	99000.00	01-10-2011
4	0	0	1169	100169.00	10-10-2011
5	15000	0	0	115169.00	14-10-2011
6	0	3000	0	112169.00	18-10-2011
7	0	0	1547	113716.00	21-10-2011
Sheet2

 

[Fluff]

Are the values in cols B:D the result of formulae?

Also if you need this to work in xl2016, why did you say you've upgraded to xl2021?

 

[Santosh080]

Are the values in cols B:D the result of formulae?

Also if you need this to work in xl2016, why did you say you've upgraded to xl2021?

yes in col B:D it extract all data. I am using same formula. It does not work for like yours.

office 2021 at my home. I have installed it recently. If yoy have any alternative solutions for office 2016 it helps me a lot i my office.

 

[Fluff]

Your numbers may not be whole numbers, so you could try

=FILTER(A2:E100,MMULT(--(ROUND(B2:D100,0)<>0),SEQUENCE(COLUMNS(B2:D2),,,0)))

 

[Santosh080]

Your numbers may not be whole numbers, so you could try

=FILTER(A2:E100,MMULT(--(ROUND(B2:D100,0)<>0),SEQUENCE(COLUMNS(B2:D2),,,0)))

thank you very much, now it is working. If you have time can please tell how can i do this in office 2016 (without filter function).

 

[Santosh080]

thank you very much, now it is working. If you have time can please tell how can i do this in office 2016 (without filter function).

Any solution please.