Need Formula Help

[Harini1100]

Please help with simple formula,

I need last message date and Message which is nothing but in (06/21/2024 - Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.) in the entire cloumn J & K

Account#	Service Date	Plc of Serv	CPT	Tr#	Amount	Balance	Msg Date	Message
18332/1	1/25/2024​	AA	J0178	1339380​	2100​	2100​
18332/1	1/25/2024​	AA	J0178	1339380​			2/20/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	1/25/2024​	AA	J0178	1339380​			3/29/2024​	DOS 01/25/2024; A corrected claim was submitted to UHC on 03/07/2024. To confirm if the claim has been received by insurance checked in UHC portal found that the claim was processed on 03/13/2024 and is in pending for medical records. Uploaded the medical records through portal. Therefore need to follow-up after 10 days. Claim# 01610800. Ticket# PIQ-47969856. *Need Medical Records*MR/Appeal Uploaded Via Portal*Aging.
18332/1	1/25/2024​	AA	J0178	1339380​			5/3/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	1/25/2024​	AA	J0178	1339380​			5/3/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	1/25/2024​	AA	J0178	1339380​			5/8/2024​	AR UHS denied as Claim/service lacks information or has submission/billing error(s) which is needed for adjudication as upon checking patient eob claim is denied for missing procedure modifier therefore raised a ticket a to office need to followup.TFL 90 days* Coding_Modifier*Escalated*Denials
18332/1	1/25/2024​	AA	J0178	1339380​			5/13/2024​	AR UHC1 denied as required modifier -As per task response from office added JZ modifier for the CPT code J9035 and refiled as a corrected claim TFL 90 days *Coding_Modifier*Billed corrected claim*Denials
18332/1	1/25/2024​	AA	J0178	1339380​			6/4/2024​	The documentation that was received was the incorrect attachment/document.
18332/1	4/4/2024​	AA	J0178	1354614​	2100​	2100​
18332/1	4/4/2024​	AA	J0178	1354614​			6/4/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	4/4/2024​	AA	J0178	1354614​			6/19/2024​	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
18332/1	4/11/2024​	AA	J0178	1356072​	2100​	2100​
18332/1	4/11/2024​	AA	J0178	1356072​			4/30/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	4/11/2024​	AA	J0178	1356072​			4/30/2024​	AR-UHC denied the claim as Coverage/program guidelines were not met for CPT 67028 and J0178 got denied as procedure modifier is missing so added task to office for CPT J0178 and for 67028 if the J code get's paid they will process the CPT code 67028 TFL 90 days*Coding_Modifier*Escalated*Denials
18332/1	4/11/2024​	AA	J0178	1356072​			5/1/2024​	AR-As per task response from added Modifier JZ for CPT J0178 and for CPT 67028 they will process the CPT if the J code get's paid and refiled as corrected claim TFL 90 days from DOS*Coding_Modifier*Billed corrected claim*Others
18332/1	4/11/2024​	AA	J0178	1356072​			5/21/2024​	AR UHS No response so called @ 8006383120 S/w ANA stated that claim is received 05/02/2024 and denied because the procedure code needs auth to get processed therefore raised a task to client need to followup TFL 90 days * Authorization* Escalated* No Response
18332/1	4/11/2024​	AA	J0178	1356072​			5/24/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	4/11/2024​	AA	J0178	1356072​			5/24/2024​	Pre-certification/authorization/notification absent.
18332/1	4/11/2024​	AA	J0178	1356072​			6/19/2024​	AR- DOS-04/11/2024-UHC- claim denied for J0178 67028 CPT codes to get more clarity on denials called UHC @ S/W ALVIN S. rep stated that the corrected claim received on 05/31/2024 and denied on 06/14/2024 stating J0178 need JZ/JW modifier therefore tasking to client for correct modifier T UHC TFL 12 months for In Network and 60 days for Out network. Claim#11765507.call ref#69981497.*Coding_Modifier*Billed corrected claim*Aging
18332/1	4/11/2024​	AA	J0178	1356072​			6/20/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18332/1	4/11/2024​	AA	J0178	1356072​			6/21/2024​	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.

 

[Asbestos_Jen]

Is this what you're looking for?

Book1
	C	D	E	F	G	H	I	J	K
1									Latest date & message:
2									06/21/2024 - Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
3
4	Account#	Service Date	Plc of Serv	CPT	Tr#	Amount	Balance	Msg Date	Message
5	18332/1	1/25/2024	AA	J0178	1339380	2100	2100
6	18332/1	1/25/2024	AA	J0178	1339380			20-Feb-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
7	18332/1	1/25/2024	AA	J0178	1339380			29-Mar-24	DOS 01/25/2024; A corrected claim was submitted to UHC on 03/07/2024. To confirm if the claim has been received by insurance checked in UHC portal found that the claim was processed on 03/13/2024 and is in pending for medical records. Uploaded the medical records through portal. Therefore need to follow-up after 10 days. Claim# 01610800. Ticket# PIQ-47969856. *Need Medical Records*MR/Appeal Uploaded Via Portal*Aging.
8	18332/1	1/25/2024	AA	J0178	1339380			3-May-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
9	18332/1	1/25/2024	AA	J0178	1339380			3-May-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
10	18332/1	1/25/2024	AA	J0178	1339380			8-May-24	AR UHS denied as Claim/service lacks information or has submission/billing error(s) which is needed for adjudication as upon checking patient eob claim is denied for missing procedure modifier therefore raised a ticket a to office need to followup.TFL 90 days* Coding_Modifier*Escalated*Denials
11	18332/1	1/25/2024	AA	J0178	1339380			13-May-24	AR UHC1 denied as required modifier -As per task response from office added JZ modifier for the CPT code J9035 and refiled as a corrected claim TFL 90 days *Coding_Modifier*Billed corrected claim*Denials
12	18332/1	1/25/2024	AA	J0178	1339380			4-Jun-24	The documentation that was received was the incorrect attachment/document.
13	18332/1	4/4/2024	AA	J0178	1354614	2100	2100
14	18332/1	4/4/2024	AA	J0178	1354614			4-Jun-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
15	18332/1	4/4/2024	AA	J0178	1354614			19-Jun-24	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
16	18332/1	4/11/2024	AA	J0178	1356072	2100	2100
17	18332/1	4/11/2024	AA	J0178	1356072			30-Apr-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
18	18332/1	4/11/2024	AA	J0178	1356072			30-Apr-24	AR-UHC denied the claim as Coverage/program guidelines were not met for CPT 67028 and J0178 got denied as procedure modifier is missing so added task to office for CPT J0178 and for 67028 if the J code get's paid they will process the CPT code 67028 TFL 90 days*Coding_Modifier*Escalated*Denials
19	18332/1	4/11/2024	AA	J0178	1356072			1-May-24	AR-As per task response from added Modifier JZ for CPT J0178 and for CPT 67028 they will process the CPT if the J code get's paid and refiled as corrected claim TFL 90 days from DOS*Coding_Modifier*Billed corrected claim*Others
20	18332/1	4/11/2024	AA	J0178	1356072			21-May-24	AR UHS No response so called @ 8006383120 S/w ANA stated that claim is received 05/02/2024 and denied because the procedure code needs auth to get processed therefore raised a task to client need to followup TFL 90 days * Authorization* Escalated* No Response
21	18332/1	4/11/2024	AA	J0178	1356072			24-May-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
22	18332/1	4/11/2024	AA	J0178	1356072			24-May-24	Pre-certification/authorization/notification absent.
23	18332/1	4/11/2024	AA	J0178	1356072			19-Jun-24	AR- DOS-04/11/2024-UHC- claim denied for J0178 67028 CPT codes to get more clarity on denials called UHC @ S/W ALVIN S. rep stated that the corrected claim received on 05/31/2024 and denied on 06/14/2024 stating J0178 need JZ/JW modifier therefore tasking to client for correct modifier T UHC TFL 12 months for In Network and 60 days for Out network. Claim#11765507.call ref#69981497.*Coding_Modifier*Billed corrected claim*Aging
24	18332/1	4/11/2024	AA	J0178	1356072			20-Jun-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
25	18332/1	4/11/2024	AA	J0178	1356072			21-Jun-24	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
Sheet1

Cell Formulas
Range	Formula
K2	K2	=TEXT(MAX($J$4:$J$27),"mm/dd/yyy")&" - "&VLOOKUP(MAX($J$4:$J$27),J4:K27,2)

 

[Fluff]

Another option

Fluff.xlsm
	C	D	E	F	G	H	I	J	K
1	Account#	Service Date	Plc of Serv	CPT	Tr#	Amount	Balance	Msg Date	Message
2	18332/1	########	AA	J0178	1339380	2100	2100
3	18332/1	########	AA	J0178	1339380			20/02/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
4	18332/1	########	AA	J0178	1339380			29/03/2024	DOS 01/25/2024; A corrected claim was submitted to UHC on 03/07/2024. To confirm if the claim has been received by insurance checked in UHC portal found that the claim was processed on 03/13/2024 and is in pending for medical records. Uploaded the medical records through portal. Therefore need to follow-up after 10 days. Claim# 01610800. Ticket# PIQ-47969856. *Need Medical Records*MR/Appeal Uploaded Via Portal*Aging.
5	18332/1	########	AA	J0178	1339380			03/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
6	18332/1	########	AA	J0178	1339380			03/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
7	18332/1	########	AA	J0178	1339380			08/05/2024	AR UHS denied as Claim/service lacks information or has submission/billing error(s) which is needed for adjudication as upon checking patient eob claim is denied for missing procedure modifier therefore raised a ticket a to office need to followup.TFL 90 days* Coding_Modifier*Escalated*Denials
8	18332/1	########	AA	J0178	1339380			13/05/2024	AR UHC1 denied as required modifier -As per task response from office added JZ modifier for the CPT code J9035 and refiled as a corrected claim TFL 90 days *Coding_Modifier*Billed corrected claim*Denials
9	18332/1	########	AA	J0178	1339380			04/06/2024	The documentation that was received was the incorrect attachment/document.
10	18332/1	########	AA	J0178	1354614	2100	2100
11	18332/1	########	AA	J0178	1354614			04/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
12	18332/1	########	AA	J0178	1354614			19/06/2024	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
13	18332/1	########	AA	J0178	1356072	2100	2100
14	18332/1	########	AA	J0178	1356072			30/04/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
15	18332/1	########	AA	J0178	1356072			30/04/2024	AR-UHC denied the claim as Coverage/program guidelines were not met for CPT 67028 and J0178 got denied as procedure modifier is missing so added task to office for CPT J0178 and for 67028 if the J code get's paid they will process the CPT code 67028 TFL 90 days*Coding_Modifier*Escalated*Denials
16	18332/1	########	AA	J0178	1356072			01/05/2024	AR-As per task response from added Modifier JZ for CPT J0178 and for CPT 67028 they will process the CPT if the J code get's paid and refiled as corrected claim TFL 90 days from DOS*Coding_Modifier*Billed corrected claim*Others
17	18332/1	########	AA	J0178	1356072			21/05/2024	AR UHS No response so called @ 8006383120 S/w ANA stated that claim is received 05/02/2024 and denied because the procedure code needs auth to get processed therefore raised a task to client need to followup TFL 90 days * Authorization* Escalated* No Response
18	18332/1	########	AA	J0178	1356072			24/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
19	18332/1	########	AA	J0178	1356072			24/05/2024	Pre-certification/authorization/notification absent.
20	18332/1	########	AA	J0178	1356072			19/06/2024	AR- DOS-04/11/2024-UHC- claim denied for J0178 67028 CPT codes to get more clarity on denials called UHC @ S/W ALVIN S. rep stated that the corrected claim received on 05/31/2024 and denied on 06/14/2024 stating J0178 need JZ/JW modifier therefore tasking to client for correct modifier T UHC TFL 12 months for In Network and 60 days for Out network. Claim#11765507.call ref#69981497.*Coding_Modifier*Billed corrected claim*Aging
21	18332/1	########	AA	J0178	1356072			20/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
22	18332/1	########	AA	J0178	1356072			21/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
23
24
25
26
27
28
29
30
31								21/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
Sheet5

Cell Formulas
Range	Formula
J31:K31	J31	=TAKE(FILTER(J2:K30,J2:J30<>""),-1)
Dynamic array formulas.

 

[Cubist]

Try

=XLOOKUP(TRUE,J2:J30<>"",J2:K30,,,-1)

 

[Harini1100]

This formula is works perfectly fine, one small change required, This is not working for the entire report which contains multiple accounts. Any suggestion?

Cell Formulas
Range	Formula
J31:K31	J31	=TAKE(FILTER(J2:K30,J2:J30<>""),-1)

 

[Asbestos_Jen]

Are you looking for the last date in the list (by cell address) or the last date chronologically? If chronologically and the account numbers vary in column C, this might work:

E28=LET(MDact,MAXIFS(J4:J25,C4:C25,D28),TEXT(MDact,"mm/dd/yyyy")&" - "&VLOOKUP(MDact,$J$4:$K$25,2))

D27=UNIQUE(C4:C25)

 

[Fluff]

How about

Fluff.xlsm
	C	D	E	F	G	H	I	J	K
1	Account#	Service Date	Plc of Serv	CPT	Tr#	Amount	Balance	Msg Date	Message
2	18332/1	########	AA	J0178	1339380	2100	2100
3	18332/1	########	AA	J0178	1339380			20/02/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
4	18332/1	########	AA	J0178	1339380			29/03/2024	DOS 01/25/2024; A corrected claim was submitted to UHC on 03/07/2024. To confirm if the claim has been received by insurance checked in UHC portal found that the claim was processed on 03/13/2024 and is in pending for medical records. Uploaded the medical records through portal. Therefore need to follow-up after 10 days. Claim# 01610800. Ticket# PIQ-47969856. *Need Medical Records*MR/Appeal Uploaded Via Portal*Aging.
5	18332/1	########	AA	J0178	1339380			03/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
6	18332/1	########	AA	J0178	1339380			03/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
7	18332/1	########	AA	J0178	1339380			08/05/2024	AR UHS denied as Claim/service lacks information or has submission/billing error(s) which is needed for adjudication as upon checking patient eob claim is denied for missing procedure modifier therefore raised a ticket a to office need to followup.TFL 90 days* Coding_Modifier*Escalated*Denials
8	18332/1	########	AA	J0178	1339380			13/05/2024	AR UHC1 denied as required modifier -As per task response from office added JZ modifier for the CPT code J9035 and refiled as a corrected claim TFL 90 days *Coding_Modifier*Billed corrected claim*Denials
9	18332/1	########	AA	J0178	1339380			04/06/2024	The documentation that was received was the incorrect attachment/document.
10	18332/1	########	AA	J0178	1354614	2100	2100
11	18332/1	########	AA	J0178	1354614			04/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
12	18332/1	########	AA	J0178	1354614			19/06/2024	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
13	18332/1	########	AA	J0178	1356072	2100	2100
14	28332/1	########	AA	J0178	1356072			30/04/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
15	28332/1	########	AA	J0178	1356072			30/04/2024	AR-UHC denied the claim as Coverage/program guidelines were not met for CPT 67028 and J0178 got denied as procedure modifier is missing so added task to office for CPT J0178 and for 67028 if the J code get's paid they will process the CPT code 67028 TFL 90 days*Coding_Modifier*Escalated*Denials
16	28332/1	########	AA	J0178	1356072			01/05/2024	AR-As per task response from added Modifier JZ for CPT J0178 and for CPT 67028 they will process the CPT if the J code get's paid and refiled as corrected claim TFL 90 days from DOS*Coding_Modifier*Billed corrected claim*Others
17	28332/1	########	AA	J0178	1356072			21/05/2024	AR UHS No response so called @ 8006383120 S/w ANA stated that claim is received 05/02/2024 and denied because the procedure code needs auth to get processed therefore raised a task to client need to followup TFL 90 days * Authorization* Escalated* No Response
18	28332/1	########	AA	J0178	1356072			24/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
19	28332/1	########	AA	J0178	1356072			24/05/2024	Pre-certification/authorization/notification absent.
20	28332/1	########	AA	J0178	1356072			19/06/2024	AR- DOS-04/11/2024-UHC- claim denied for J0178 67028 CPT codes to get more clarity on denials called UHC @ S/W ALVIN S. rep stated that the corrected claim received on 05/31/2024 and denied on 06/14/2024 stating J0178 need JZ/JW modifier therefore tasking to client for correct modifier T UHC TFL 12 months for In Network and 60 days for Out network. Claim#11765507.call ref#69981497.*Coding_Modifier*Billed corrected claim*Aging
21	28332/1	########	AA	J0178	1356072			20/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
22	28332/1	########	AA	J0178	1356072			21/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
23
24
25
26
27
28
29
30
31							18332/1	19/06/2024	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
32							28332/1	21/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
Sheet5

Cell Formulas
Range	Formula
I31:I32	I31	=UNIQUE(FILTER(C2:C30,C2:C30<>""))
J31:K32	J31	=TAKE(FILTER($J$2:$K$30,($J$2:$J$30<>"")*($C$2:$C$30=I31)),-1)
Dynamic array formulas.

 

[Harini1100]

How about

Fluff.xlsm
	C	D	E	F	G	H	I	J	K
1	Account#	Service Date	Plc of Serv	CPT	Tr#	Amount	Balance	Msg Date	Message
2	18332/1	########	AA	J0178	1339380	2100	2100
3	18332/1	########	AA	J0178	1339380			20/02/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
4	18332/1	########	AA	J0178	1339380			29/03/2024	DOS 01/25/2024; A corrected claim was submitted to UHC on 03/07/2024. To confirm if the claim has been received by insurance checked in UHC portal found that the claim was processed on 03/13/2024 and is in pending for medical records. Uploaded the medical records through portal. Therefore need to follow-up after 10 days. Claim# 01610800. Ticket# PIQ-47969856. *Need Medical Records*MR/Appeal Uploaded Via Portal*Aging.
5	18332/1	########	AA	J0178	1339380			03/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
6	18332/1	########	AA	J0178	1339380			03/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
7	18332/1	########	AA	J0178	1339380			08/05/2024	AR UHS denied as Claim/service lacks information or has submission/billing error(s) which is needed for adjudication as upon checking patient eob claim is denied for missing procedure modifier therefore raised a ticket a to office need to followup.TFL 90 days* Coding_Modifier*Escalated*Denials
8	18332/1	########	AA	J0178	1339380			13/05/2024	AR UHC1 denied as required modifier -As per task response from office added JZ modifier for the CPT code J9035 and refiled as a corrected claim TFL 90 days *Coding_Modifier*Billed corrected claim*Denials
9	18332/1	########	AA	J0178	1339380			04/06/2024	The documentation that was received was the incorrect attachment/document.
10	18332/1	########	AA	J0178	1354614	2100	2100
11	18332/1	########	AA	J0178	1354614			04/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
12	18332/1	########	AA	J0178	1354614			19/06/2024	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
13	18332/1	########	AA	J0178	1356072	2100	2100
14	28332/1	########	AA	J0178	1356072			30/04/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
15	28332/1	########	AA	J0178	1356072			30/04/2024	AR-UHC denied the claim as Coverage/program guidelines were not met for CPT 67028 and J0178 got denied as procedure modifier is missing so added task to office for CPT J0178 and for 67028 if the J code get's paid they will process the CPT code 67028 TFL 90 days*Coding_Modifier*Escalated*Denials
16	28332/1	########	AA	J0178	1356072			01/05/2024	AR-As per task response from added Modifier JZ for CPT J0178 and for CPT 67028 they will process the CPT if the J code get's paid and refiled as corrected claim TFL 90 days from DOS*Coding_Modifier*Billed corrected claim*Others
17	28332/1	########	AA	J0178	1356072			21/05/2024	AR UHS No response so called @ 8006383120 S/w ANA stated that claim is received 05/02/2024 and denied because the procedure code needs auth to get processed therefore raised a task to client need to followup TFL 90 days * Authorization* Escalated* No Response
18	28332/1	########	AA	J0178	1356072			24/05/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
19	28332/1	########	AA	J0178	1356072			24/05/2024	Pre-certification/authorization/notification absent.
20	28332/1	########	AA	J0178	1356072			19/06/2024	AR- DOS-04/11/2024-UHC- claim denied for J0178 67028 CPT codes to get more clarity on denials called UHC @ S/W ALVIN S. rep stated that the corrected claim received on 05/31/2024 and denied on 06/14/2024 stating J0178 need JZ/JW modifier therefore tasking to client for correct modifier T UHC TFL 12 months for In Network and 60 days for Out network. Claim#11765507.call ref#69981497.*Coding_Modifier*Billed corrected claim*Aging
21	28332/1	########	AA	J0178	1356072			20/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
22	28332/1	########	AA	J0178	1356072			21/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
23
24
25
26
27
28
29
30
31							18332/1	19/06/2024	AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging
32							28332/1	21/06/2024	Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.
Sheet5

Cell Formulas
Range	Formula
I31:I32	I31	=UNIQUE(FILTER(C2:C30,C2:C30<>""))
J31:K32	J31	=TAKE(FILTER($J$2:$K$30,($J$2:$J$30<>"")*($C$2:$C$30=I31)),-1)
Dynamic array formulas.

This one is works like a charm!! You are a life saver! Multitude Thanks....☺☺☺

 

[Fluff]

Glad we could help & thanks for the feedback.