Listing Missed Details in New Table

[senthilvelan]

Hi Masters,
I need the solution for following situation in the Table-01 contains all the details; Table-02 has missing sum data
Now in the Table-03, I want the list of missing details given date Range in 'E16 + G16.

Thanks In Advance.

<tbody>
[TD="align: center"][/TD]
[TD="align: center"] Table-01 [/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"] Table-02 [/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"] Table-03 [/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]

[TD="class: xl63, align: center"] Date [/TD]
[TD="class: xl63, align: center"] C. Name
[/TD]
[TD="class: xl63, align: center"] Inv No [/TD]
[TD="class: xl63, align: center"] Value [/TD]
[TD="align: center"][/TD]
[TD="class: xl63, align: center"] Date [/TD]
[TD="class: xl63, align: center"] C. Name [/TD]
[TD="class: xl63, align: center"] Inv No [/TD]
[TD="class: xl63, align: center"] Value [/TD]
[TD="align: center"][/TD]
[TD="class: xl63, align: center"] Date [/TD]
[TD="class: xl63, align: center"] C. Name [/TD]
[TD="class: xl63, align: center"] Inv No [/TD]
[TD="class: xl63, align: center"] Value [/TD]

[TD="class: xl64, align: right"]01-Apr[/TD]
[TD="class: xl63"] aab[/TD]
[TD="class: xl63, align: right"]123[/TD]
[TD="class: xl63, align: right"]150[/TD]

[TD="class: xl64, align: right"]01-Apr[/TD]
[TD="class: xl63"] aab[/TD]
[TD="class: xl63, align: right"]123[/TD]
[TD="class: xl63, align: right"]150[/TD]

[TD="class: xl64, align: right"]01-Apr[/TD]
[TD="class: xl63"] abd[/TD]
[TD="class: xl63, align: right"]345[/TD]
[TD="class: xl63, align: right"]250[/TD]

[TD="class: xl64, align: right"]01-Apr[/TD]
[TD="class: xl63"] abd[/TD]
[TD="class: xl63, align: right"]345[/TD]
[TD="class: xl63, align: right"]250[/TD]

[TD="class: xl64, align: right"]01-Apr[/TD]
[TD="class: xl63"] acb[/TD]
[TD="class: xl63, align: right"]654[/TD]
[TD="class: xl63, align: right"]150[/TD]

[TD="class: xl64, align: right"]02-Apr[/TD]
[TD="class: xl63"] abd[/TD]
[TD="class: xl63, align: right"]124[/TD]
[TD="class: xl63, align: right"]1505[/TD]

[TD="class: xl64, align: right"]01-Apr[/TD]
[TD="class: xl63"] acb[/TD]
[TD="class: xl63, align: right"]654[/TD]
[TD="class: xl63, align: right"]150[/TD]

[TD="class: xl64, align: right"]02-Apr[/TD]
[TD="class: xl63"] acb[/TD]
[TD="class: xl63, align: right"]515[/TD]
[TD="class: xl63, align: right"]50[/TD]

[TD="class: xl64, align: right"]03-Apr[/TD]
[TD="class: xl63"] axx[/TD]
[TD="class: xl63, align: right"]554[/TD]
[TD="class: xl63, align: right"]540[/TD]

[TD="class: xl64, align: right"]02-Apr[/TD]
[TD="class: xl63"] abd[/TD]
[TD="class: xl63, align: right"]124[/TD]
[TD="class: xl63, align: right"]1505[/TD]

[TD="class: xl64, align: right"]02-Apr[/TD]
[TD="class: xl63"] axv[/TD]
[TD="class: xl63, align: right"]215[/TD]
[TD="class: xl63, align: right"]154[/TD]

[TD="class: xl64, align: right"]03-Apr[/TD]
[TD="class: xl63"] afv[/TD]
[TD="class: xl63, align: right"]514[/TD]
[TD="class: xl63, align: right"]122[/TD]

[TD="class: xl64, align: right"]02-Apr[/TD]
[TD="class: xl63"] acb[/TD]
[TD="class: xl63, align: right"]515[/TD]
[TD="class: xl63, align: right"]50[/TD]

[TD="class: xl64, align: right"]03-Apr[/TD]
[TD="class: xl63"] asd[/TD]
[TD="class: xl63, align: right"]976[/TD]
[TD="class: xl63, align: right"]2130[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64, align: right"]02-Apr[/TD]
[TD="class: xl63"] axv[/TD]
[TD="class: xl63, align: right"]215[/TD]
[TD="class: xl63, align: right"]154[/TD]

[TD="class: xl64, align: right"]04-Apr[/TD]
[TD="class: xl63"] acv[/TD]
[TD="class: xl63, align: right"]334[/TD]
[TD="class: xl63, align: right"]554[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64, align: right"]03-Apr[/TD]
[TD="class: xl63"] axx[/TD]
[TD="class: xl63, align: right"]554[/TD]
[TD="class: xl63, align: right"]540[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64, align: right"]03-Apr[/TD]
[TD="class: xl63"] asd[/TD]
[TD="class: xl63, align: right"]976[/TD]
[TD="class: xl63, align: right"]2130[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64, align: right"]03-Apr[/TD]
[TD="class: xl63"] afv[/TD]
[TD="class: xl63, align: right"]514[/TD]
[TD="class: xl63, align: right"]122[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64, align: right"]04-Apr[/TD]
[TD="class: xl63"] acv[/TD]
[TD="class: xl63, align: right"]334[/TD]
[TD="class: xl63, align: right"]554[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="align: right"][/TD]
[TD="class: xl66, align: center"] Date
[/TD]

[TD="class: xl67"] 01-Apr
[/TD]
[TD="class: xl65"] to[/TD]
[TD="class: xl67"] 04-Apr
[/TD]

</tbody>

 

[oldbrewer]

[TABLE="width: 1185"]
<colgroup><col><col><col><col><col><col><col><col span="4"><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Table-01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Table-02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Table-03[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]C. Name[/TD]
[TD]Inv No[/TD]
[TD]Value[/TD]
[TD]concat1[/TD]
[TD]missing[/TD]
[TD][/TD]
[TD]Date[/TD]
[TD]C. Name[/TD]
[TD]Inv No[/TD]
[TD]Value[/TD]
[TD]concat2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Date[/TD]
[TD]C. Name[/TD]
[TD]Inv No[/TD]
[TD]Value[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Apr[/TD]
[TD]aab[/TD]
[TD]123[/TD]
[TD]150[/TD]
[TD]aab12315043191[/TD]
[TD] [/TD]
[TD][/TD]
[TD]43191[/TD]
[TD]aab[/TD]
[TD]123[/TD]
[TD]150[/TD]
[TD]aab12315043191[/TD]
[TD][/TD]
[TD][/TD]
[TD]43191[/TD]
[TD]abd[/TD]
[TD]345[/TD]
[TD]250[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Apr[/TD]
[TD]abd[/TD]
[TD]345[/TD]
[TD]250[/TD]
[TD]abd34525043191[/TD]
[TD]M[/TD]
[TD][/TD]
[TD]43191[/TD]
[TD]acb[/TD]
[TD]654[/TD]
[TD]150[/TD]
[TD]acb65415043191[/TD]
[TD][/TD]
[TD][/TD]
[TD]43192[/TD]
[TD]abd[/TD]
[TD]124[/TD]
[TD]1505[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01-Apr[/TD]
[TD]acb[/TD]
[TD]654[/TD]
[TD]150[/TD]
[TD]acb65415043191[/TD]
[TD] [/TD]
[TD][/TD]
[TD]43192[/TD]
[TD]acb[/TD]
[TD]515[/TD]
[TD]50[/TD]
[TD]acb5155043192[/TD]
[TD][/TD]
[TD][/TD]
[TD]43193[/TD]
[TD]axx[/TD]
[TD]554[/TD]
[TD]540[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02-Apr[/TD]
[TD]abd[/TD]
[TD]124[/TD]
[TD]1505[/TD]
[TD]abd124150543192[/TD]
[TD]M[/TD]
[TD][/TD]
[TD]43192[/TD]
[TD]axv[/TD]
[TD]215[/TD]
[TD]154[/TD]
[TD]axv21515443192[/TD]
[TD][/TD]
[TD][/TD]
[TD]43193[/TD]
[TD]afv[/TD]
[TD]514[/TD]
[TD]122[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02-Apr[/TD]
[TD]acb[/TD]
[TD]515[/TD]
[TD]50[/TD]
[TD]acb5155043192[/TD]
[TD] [/TD]
[TD][/TD]
[TD]43193[/TD]
[TD]asd[/TD]
[TD]976[/TD]
[TD]2130[/TD]
[TD]asd976213043193[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02-Apr[/TD]
[TD]axv[/TD]
[TD]215[/TD]
[TD]154[/TD]
[TD]axv21515443192[/TD]
[TD] [/TD]
[TD][/TD]
[TD]43194[/TD]
[TD]acv[/TD]
[TD]334[/TD]
[TD]554[/TD]
[TD]acv33455443194[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Apr[/TD]
[TD]axx[/TD]
[TD]554[/TD]
[TD]540[/TD]
[TD]axx55454043193[/TD]
[TD]M[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Apr[/TD]
[TD]asd[/TD]
[TD]976[/TD]
[TD]2130[/TD]
[TD]asd976213043193[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Apr[/TD]
[TD]afv[/TD]
[TD]514[/TD]
[TD]122[/TD]
[TD]afv51412243193[/TD]
[TD]M[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04-Apr[/TD]
[TD]acv[/TD]
[TD]334[/TD]
[TD]554[/TD]
[TD]acv33455443194[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]your 4 missing rows are highlighted with an "M"[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]the formula in the cell below "missing" is[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]=IF(ISERROR(OFFSET($L$3,MATCH(E4,$L$4:$L$20,0),1)),"M","")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]the formula for the first concat1 "value" in E4 is[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]=B4&C4&D4&A4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

Since your requirement seems to be dependant on dates falling between the E16 and G16 dates, it would have been a good idea to include some rows where the dates did not already fall in that date range.

In any case, if I have understood correctly, you could do it ...

A) Directly, with the formula shown below in K3 copied across and down (you may need to reformat columns M & N to an appropriate number format after copying the formulas across)

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Table-01					Table-02					Table-03
2	Date	C. Name	Inv No	Value		Date	C. Name	Inv No	Value		Date	C. Name	Inv No	Value
3	1-Apr	aab	123	150		1-Apr	aab	123	150		1-Apr	abd	345	250
4	1-Apr	abd	345	250		1-Apr	acb	654	150		2-Apr	abd	124	1505
5	1-Apr	acb	654	150		2-Apr	acb	515	50		3-Apr	axx	554	540
6	2-Apr	abd	124	1505		2-Apr	axv	215	154		3-Apr	afv	514	122
7	2-Apr	acb	515	50		3-Apr	asd	976	2130
8	2-Apr	axv	215	154		4-Apr	acv	334	554
9	3-Apr	axx	554	540
10	3-Apr	asd	976	2130
11	3-Apr	afv	514	122
12	4-Apr	acv	334	554
13
14
15						Date
16					1-Apr	to	4-Apr
Missing Data 1

B) Using a helper column (for me formula in E3 copied down - leaving E2 empty) and then the simpler formula in K3 copied across and down (again, reformatting M & N may be required)

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Table-01					Table-02					Table-03
2	Date	C. Name	Inv No	Value		Date	C. Name	Inv No	Value		Date	C. Name	Inv No	Value
3	1-Apr	aab	123	150	0	1-Apr	aab	123	150		1-Apr	abd	345	250
4	1-Apr	abd	345	250	1	1-Apr	acb	654	150		2-Apr	abd	124	1505
5	1-Apr	acb	654	150	1	2-Apr	acb	515	50		3-Apr	axx	554	540
6	2-Apr	abd	124	1505	2	2-Apr	axv	215	154		3-Apr	afv	514	122
7	2-Apr	acb	515	50	2	3-Apr	asd	976	2130
8	2-Apr	axv	215	154	2	4-Apr	acv	334	554
9	3-Apr	axx	554	540	3
10	3-Apr	asd	976	2130	3
11	3-Apr	afv	514	122	4
12	4-Apr	acv	334	554	4
13
14
15						Date
16					1-Apr	to	4-Apr
Missing Data 2

 

[senthilvelan]

Thank you for the great help. I'll check this formula & Reply soon.