Question: Which formula do I use? DCOUNTA? i would appreciate the help. Record a macro, which will ask the user for the STATE (using InputBox function)

Which formula do I use? DCOUNTA? i would appreciate the help. Record a macro, which will ask the user for the

STATE (using InputBox function) and then calculate number of our customers that meets that criteria (i.e. counters number of customers that lives in the STATE typed in that inputbox)?

Create macro button called Question1 on Customers sheet so that we can replay this macro.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

You participated in a brainstorm to gather information for an update to your CIO. Consider your findings of vendor options and the process for a health care information system as you begin your...

T Problem: This program will read in a large US Coast Guard database of ship position information from the Automatic Identification System (AIS)1. The student provided functions will: Prompt the user...

I am so confused , can I get some help with this question Record a macro, QUESTION14 , that will ask the user to input the hiring/start date (using inputbox function) and then calculate number of...

Record a macro, QUESTION2, that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will input...

2. Record a macro, QUESTION2 , that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will...

2 . Record a macro, QUESTION 2 , that will ask the user to input the hiring date ( using inputbox function ) and then calculate number of employees hired on or after that hiring date ( e . g . , user...

C++, I need help plz /*********************** Assignment 1 ***********************/ // Include libraries #include #include #include #include #include #include using namespace std; // Structure to...

I have attached 2 screen shots , this is an excel file and the three sheets are customers , products and then queries. I need help with this question, can I get a step by step explanation please? I...

Data for this code 367430850,2019-01-01T00:00:05,30.40366,-88.85801,0.0,126.3,511.0,MISS NIZ,IMO8987539,WDF2697,31,0,22,8,2.4,52,B...

Can you please help me struct void readFile,bool getNextField, and bool getNextField? Data for this code 367430850,2019-01-01T00:00:05,30.40366,-88.85801,0.0,126.3,511.0,MISS...

i need your help please YO19_Excel_Ch06_Prepare_PartA_Golf_Data Project Description: Barry Cheney, manager of the Red Bluff Golf Course and Pro Shop, would like to develop a marketing strategy f olf...

Your check register shows a balance of $50 Your last bank statement shows an ending balance of $615. All transactions match except for two outstanding checks for $200 and $40. Does your register...

Suppose that X1, . . . , Xn form a random sample from a distribution with the following p.d.f.: where and are unknown ( > 0, otherwise,

Cost behavior: refers to how a cost will change as activity level changes categorizes costs as fived, mined and yorishle Is a detailed analysis technique used to determine whether costs are fixed or...

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...