Log In
Register
Home
September 14, 2020
Offline
Hi,
All Forum family and members,
I have one problem. The problem is given below:
I have a workbook and that has 3 sheets, names: Accounts, Customers Entries, General Ledger.
In the General Ledger sheet (Column A3) has a Dropdown Menu from the accounts Sheet.
When I select any Account Name from drop Down menu then extrect Given Data.
Now, I Want that Extrect Data between two Dates also by extrecting with names.
File Attached and Solve the problem please,
Thanks,
Reehan Saeed
August 21, 2019
Offline
Hi,
G3=MIN(C5:C107)
H3=MAX(C5:C107)
September 14, 2020
Offline
Hi,
Chris Yap,
Thanks for Reply, but this is not a correct way.
Kindly understand my Question.
can anyone solve the problem please.
Thanks
Reehan Saeed
Trusted Members
December 20, 2019
Offline
I always wonder when i file is named 1-5 that its homework.....
Anyway, this is not perfect due to the way you are doing the vlookups based on the SR# (i think)
But a helper column at the end to decide if each record is within the dates
=IF(AND(IFERROR(VLOOKUP($A5&"-"&$A$3,Journal[[Helper 1]:[Credit]],2,0),"")>=$G$3,IFERROR(VLOOKUP($A5&"-"&$A$3,Journal[[Helper 1]:[Credit]],2,0),"")<=$H$3),TRUE,FALSE)
then a
=IF(K5=FALSE,"",
In front of every iferror/vlookup-using-dates
Then hide column K
as a side tip - i would avoid merged cells at all costs, nothing good will ever come of them
September 14, 2020
Offline
Hi,
Purfleet,
Thanks for the reply ASAP.
You solve the problem but one problem again showing that when I delete Dates G3 and H3 then does not show any record by zafer or any other account name.
Thanks
1 Guest(s)
