Extract Result Dates data formula as per date mention

2 views
Skip to first unread message

amar takale

unread,
Apr 27, 2016, 11:24:26 AM4/27/16
to Excel VBA Lab
sheet.xls

Ashish Kumar

unread,
Apr 27, 2016, 2:24:48 PM4/27/16
to Excel...@googlegroups.com
Hi Amar,

Check this.

Clear data from sheet 2 every time before run macro


Note : Visit on group page for downloading the sheet



Regards
Ashish Kumar
Extract Data according to DATES - By ExcelVbaLab.com.xlsm

amartakale

unread,
Apr 28, 2016, 3:36:20 AM4/28/16
to Excel VBA Lab - An Excel VBA Macro help Group
Dear ashish code is not work.And I want formula if possible bcos I unknown VBA code only basic learn.

Ashish Kumar

unread,
Apr 28, 2016, 5:42:12 AM4/28/16
to Excel VBA Lab - An Excel VBA Macro help Group
Hi,

Code is working perfectly. It's tested.


Regards
Ashish Kumar

amar takale

unread,
Apr 28, 2016, 9:48:59 AM4/28/16
to Excel VBA Lab
Dear Ashish

I need formulas,we can do it with formula?.
I can try to solution with countif function helper column.But I thinking it will done in one formula means without helper column.
N5 cell is date cell where I changed date then show that day result date & company name.

Regards
Amar

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab - An Excel VBA Macro help Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
 To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/5ac45640-6220-403a-ac67-3e3189cfdece%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

New Result Calendar.xlsx

amar takale

unread,
Apr 28, 2016, 9:49:38 AM4/28/16
to Excel VBA Lab
red color column is helper column

Vaibhav Joshi

unread,
Apr 28, 2016, 1:40:39 PM4/28/16
to Excel VBA Lab
Dear Amar

Check this, formula will list out all matching values from table.

CHeers!!

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CAMNN7OYwoy0sXiMmSAuDnoRSjGBPenBU_VRe%2BM58Gj%2B%3DWVdirQ%40mail.gmail.com.
sheet.xls

amar takale

unread,
Apr 29, 2016, 12:32:40 AM4/29/16
to Excel VBA Lab
Dear Vabs Sir

Superb! Sir

It perfect formula as per requirement.

Thanks very Much

Amar

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CALu41JBmajcsSG59_hSXWMvHE9V9y40A84TVNSuuZRd6SLPC4Q%40mail.gmail.com.

Ashish Kumar

unread,
May 1, 2016, 9:49:27 AM5/1/16
to Excel VBA Lab - An Excel VBA Macro help Group
Dear Vaibhav Sir,

Excellent solution provided by you Sir, Thanks for sharing this formula.



Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages