I am unable to apply XLOOKUP and OFFSET in one nested formula. Need URGENT help. File Attached!!!

[Nishkarsh31]

I've attached the excel file. I've written the problem there. It's self explanatory

I need to get a return array based on the MAXIF condition, and then get a lookup value to a single cell.
I've tried three approach, MAXIF, OFFSET, XLOOKUP. This just seems to complicated.

[#2]

@Nishkarsh31 May I suggest you add a column F summing the three payment methods. Then you could use this formula to achieve what you want.

=MAX(FILTER(A2:A14,(B2:B14="B")*(F2:F14<>0)))

[#3]

Thank you for the response. I'll give it a try right away and get back to you.
Just out of curiosity is there a way to do the same without summing the three?
My full data sheet is getting too slow.
I'm trying to get rid of as much redundant columns as possible
@Riny_van_Eekelen 

[#4 · Accepted solution]

@Nishkarsh31 This one will work without the extra column:

=MAX(FILTER(A2:A14,(B2:B14="B")*((C2:C14<>"")+(D2:D14<>"")+(E2:E14<>""))))

[#5]

Worked like a charm.
Thank you so much @Riny_van_Eekelen 

and thanks for bringing Filter function to my knowledge.
Without it,I doubt any of my approaches would have made sense. 

[#6]

@Nishkarsh31 Glad I could help!