hi all,
i hope you can help me, to show/display data based on month criteria, with selected month in cell H2 (as start date) and I2 (as end date)
my expected result start from cell H7, i called "blue area"..
please, see my attached workbook..
any help, thanks in advance & will be appreciated...
john m
cheers.
Baed on Month and Between Month, ok sumonggo hehe....
Cheers
Try this array formula in the cell H7 and drag across and down. Since this is an array formula so you need to confirm it with Ctrl + Shift + Enter instead of just Enter. (i.e. hold down Ctrl + Shift and then press Enter)
For detail see the attached sheet.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
hi sktneer, it's wonderful answer...thanks a lot....
hi Azumi, it's sweet answer...
thank you very much....(matur suwun, mas bro)
hi azumi, can you explain for me what do you mean function "_xlfn.AGGREGATE"...
Glad to help you. Thanks for the feedback and rep.
AGGREGATE is a function that was introduced in Excel 2010.Originally Posted by Jhon Mustofa
If you open a file that contains formulas using that function in Excel versions prior to Excel 2010 then you get that: _xlfn.AGGREGATE
Your profile indicates you're using Excel 2007 so the AGGREGATE function is not available in that version.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
hello Tony, thanks for your explanation....
Now, I understand......
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks