Log In
Register
Home
September 14, 2020
Offline
Hi,
All Forum family members,
I have one problem. The problem is Given Below:
I have a worksheet that has a Ledger Sheet.
In the Ledger Sheet, when I extract Data between two Dates then records are extracted but I want
"The record was found --- Let him come up"
The file is attached, Kindly Check it, Pease.
Thanks,
Reehan Saeed
Trusted Members
December 20, 2019
Offline
Sorry, not understanding what you are after. Can you clarify
September 14, 2020
Offline
Hi,
Purfleet,
I attached JPEG examples,
I think now you can understand my problem,,,
Thanks
Reehan
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Is there any reason to why you do not use a Pivot Table? Attached is an example.
Br,
Anders
September 14, 2020
Offline
I wanna do this by the formula.
Kindly resolve my problem.
Thanks,
July 16, 2010
Offline
It is a mistake to use formulas for this. You are playing with fire because the chances of formula errors are high. I recommend using PivotTables as Anders suggested.
Mynda
September 14, 2020
Offline
I understand that what are you saying, But you can tell me a formula also,
Kindly please, Suggest me a formula also,,
Thanks
September 9, 2020
Offline
Hi Reehan Saeed,
I also think that the Pivot Table is the best solution. Using formulas of this type is - sooner or later - going to have problems; resources are already available...
But, to amuse the gallery, here are some matrix formulas. You really have to examine them closely to understand them.
BR,
1 Guest(s)
