Dear Forum,
I need your support for the following situation:
1. The attached worksheet is macro recorded sheet and (kindly enable while you are opening) has 2 sheets.
2. Data set - GA is a master document and GA - Worksheet is a report generation sheet, which generating report from Data set GA sheet with specific criteria.
3. The Data set - GA gives you very clear picture about individuals submitted application for Loan and sanctioned details. "Column J" has conditional formatting option to get to know about the status of loan amount sanctioned. "Blue color indicates application submitted but still loan amount is not sanctioned". "Green color indicates application submitted and loan amount sanctioned".
Now my requirements are in the GA - Worksheet only:
1. 1st requirement is - I have setup count cell in C2 with formula. Currently it gives me entire blank cells from J4:J63. But i want only "count of Blue color"
2. My 2nd requirement is - I need to extract those count numbers individual details from Data set - GA in the structured table. (A5:J5)
Thanks in advance.
Bookmarks