LinkBack URL
About LinkBacks
Hello Everyone,
I want to add one more condition to filter in Cash Flow Variance tab with D6 cell (Bank) which is located also at D7:JU7 in Planned Cash Flow and Actual Cash Flow tabs. So can anyone please help me out?
Regards,
Neilesh
Hello Everyone,
I want to add one more condition to filter in Cash Flow Variance tab with D6 cell (Bank) which is located also at D7:JU7 in Planned Cash Flow and Actual Cash Flow tabs. So can anyone please help me out?
Regards,
Neilesh
Neilesh,
You say you want to add one more condition to filter? It looks like it is just a custom list right now... can you explain exactly what you actually need?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Sir,
Based on the Bank name i want to get filter all the informations for the particular Planned Vs. Actual week. Request to you kindly provide the formula for the same.
Regards,
Neilesh
Sorry but these formulas are not my strong suit and I don't have the time to work them out today. I think you need a combination of index and match in an array formula, but hopefully one of the people on this forum who use them more frequently can help you out with this.
Hi,
Can anyone please help me out on this thread. Please it is very urgent for me.
Regards,
Neilesh
Hi Guys,
Please help on my thread. Its quite urgent.
Regards,
Neilesh
Hi Guys,
Can anyone please help on my thread. I want to add one more filter in the Cash Flow Variance tab. Based on the Bank name i want to get filter all the informations for the particular Planned Vs. Actual week. Request to you kindly provide the formula for the same.
Regards,
Neilesh
Hello Neilesh,
I'm having a hard time following you actually. Can you elaborate on how exactly do you want to "add one more" "filter" ?
I see a drop-down list in D6, do you mean you wanna generate this list everytime you update your row 7 in the other 2 sheet or something similar?
Or did you mean you want to add one more condition to your formula, which is
=IF($D$4="Actual",SUMIFS('Actual Cash Flow'!D8:JU8,'Actual Cash Flow'!$D$6:$JU$6,$D$7&$D$6,'Actual Cash Flow'!$D$5:$JU$5,$D$4),SUMIFS('Planned Cash Flow'!D8:JU8,'Planned Cash Flow'!$D$6:$JU$6,$D$7,'Planned Cash Flow'!$D$5:$JU$5,$D$4&$D$6))
Found on D9 for example?
Just exactly what condition, where and how do you wanna add it
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
Hi Lemice,
Thanks a lot for your precious support and valuable phase. We do have 4 Banks for Cash Inflow and Outflow so accordingly for each week in Planned and Actual tab i have created 4 separate columns for each week. In Cash Flow Variance tab at D6 (Bank) filter which i also want to add condition based on Actual and Planned Cash Flow.
Can you please provide the formula for the same.
Regards,
Neilesh
Hi Lemice,
I wanna add from D9 to D67 for Planned and Actual Cash columns in Cash Flow Variance tab.
Week filter is working fine but if i will select Bank 01 at cell D6 then in Cash Flow Variance should reflect for the particular week and for particular bank transaction.
Hi Guys,
Is there no one in the forum who can help me out on this thread?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks