Help with find Same date

[Jagat Pavasia]

Dear sir, I have data from A2 to F11.

I want that from A2:A11,C2:C11,E2:E11 find date and it is automatically put in H2.
next coming date from the same data are and put in to J2,
Next date put in L2...same repeat.....in N2, P2, R2, T2.

(Do not repeat Same date)

Image 1 is blank and Image 2 have answer I typed Manually.
so which Formula can I put in H2, J2, L2, N2, P2, R2, T2 ??


Please help

 

[Peter_SSs]

Try copying this H2 formula to J2, L2, etc

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. You will get more potential helpers and faster responses.

24 08 15.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Date	pay 1	Date	pay 2	Date	pay 3		Date 1	Amount 1	Date 2	Amount 2	Date 3	Amount 3	Date 4	Amount 4	Date 5	Amount 5	Date 6	Amount 6	Date 7	Amount 7
2	15/08/2024	25	17/08/2024	30	17/08/2024	35		15/08/2024		17/08/2024		20/08/2024		23/08/2024		26/08/2024		27/08/2024
3	17/08/2024	5	20/08/2024	35
4	23/08/2024	5	26/08/2024	8
5	27/08/2024	10
6
7
8
9
10
11
Dates

Cell Formulas
Range	Formula
H2,T2,R2,P2,N2,L2,J2	H2	=IFERROR(INDEX(UNIQUE(SORT(FILTERXML("<p><c>"&TEXTJOIN("</c><c>",1,IF($A$1:$F$1="Date",$A$2:$F$11,""))&"</c></p>","//c[.>0]"))),COUNTIF($H$1:H$1,"D*")),"")

 

[Jagat Pavasia]

Try copying this H2 formula to J2, L2, etc

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. You will get more potential helpers and faster responses.

24 08 15.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Date	pay 1	Date	pay 2	Date	pay 3		Date 1	Amount 1	Date 2	Amount 2	Date 3	Amount 3	Date 4	Amount 4	Date 5	Amount 5	Date 6	Amount 6	Date 7	Amount 7
2	15/08/2024	25	17/08/2024	30	17/08/2024	35		15/08/2024		17/08/2024		20/08/2024		23/08/2024		26/08/2024		27/08/2024
3	17/08/2024	5	20/08/2024	35
4	23/08/2024	5	26/08/2024	8
5	27/08/2024	10
6
7
8
9
10
11
Dates

Cell Formulas
Range	Formula
H2,T2,R2,P2,N2,L2,J2	H2	=IFERROR(INDEX(UNIQUE(SORT(FILTERXML("<p><c>"&TEXTJOIN("</c><c>",1,IF($A$1:$F$1="Date",$A$2:$F$11,""))&"</c></p>","//c[.>0]"))),COUNTIF($H$1:H$1,"D*")),"")

yes, This is Working as I want....

But I want to add 1 more thing

I want that if I type invoice number like A21 in I2 than search it from A2:A11 and then our past formula work.
In short I want one condition in formula.


please help ...

 

[Peter_SSs]

I want that if I type invoice number like A21 in I2 than search it from A2:A11 and then our past formula work.
In short I want one condition in formula.

Try

Jagat Pavasia.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Invoice	Date	pay 1	Date	pay 2	Date	pay 3		Inv		Date 1	Amount 1	Date 2	Amount 2	Date 3	Amount 3	Date 4	Amount 4	Date 5	Amount 5	Date 6	Amount 6	Date 7	Amount 7
2	A21	15/08/2024	25	17/08/2024	30	17/08/2024	35		A21		15/08/2024		17/08/2024		20/08/2024
3	A21	17/08/2024	5	20/08/2024	35
4	B22	23/08/2024	5	26/08/2024	8
5	B21	27/08/2024	10
6	B23
7	B23
8	A21
9	B22			30/08/2024
10	C22
11	C23
Dates

Cell Formulas
Range	Formula
K2,W2,U2,S2,Q2,O2,M2	K2	=IFERROR(INDEX(UNIQUE(SORT(FILTERXML("<p><c>"&TEXTJOIN("</c><c>",1,IF($B$1:$G$1="Date",IF($I$2="",$B$2:$G$11,IF($A$2:$A$11=$I$2,$B$2:$G$11,"")),""))&"</c></p>","//c[.>0]"))),COUNTIF($K$1:K$1,"D*")),"")

 

[Jagat Pavasia]

Try

Jagat Pavasia.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Invoice	Date	pay 1	Date	pay 2	Date	pay 3		Inv		Date 1	Amount 1	Date 2	Amount 2	Date 3	Amount 3	Date 4	Amount 4	Date 5	Amount 5	Date 6	Amount 6	Date 7	Amount 7
2	A21	15/08/2024	25	17/08/2024	30	17/08/2024	35		A21		15/08/2024		17/08/2024		20/08/2024
3	A21	17/08/2024	5	20/08/2024	35
4	B22	23/08/2024	5	26/08/2024	8
5	B21	27/08/2024	10
6	B23
7	B23
8	A21
9	B22			30/08/2024
10	C22
11	C23
Dates

Cell Formulas
Range	Formula
K2,W2,U2,S2,Q2,O2,M2	K2	=IFERROR(INDEX(UNIQUE(SORT(FILTERXML("<p><c>"&TEXTJOIN("</c><c>",1,IF($B$1:$G$1="Date",IF($I$2="",$B$2:$G$11,IF($A$2:$A$11=$I$2,$B$2:$G$11,"")),""))&"</c></p>","//c[.>0]"))),COUNTIF($K$1:K$1,"D*")),"")

THANK YOU VERY MUCH PETER....................THANK YOU SO MUCH AGAIN...
IT IS WORKING AS I SHOULD PERFECTLY.....THANKS AGAIN

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.