Question: which excel function can i use to select a particular number from a set of data. e.g i have 1000 numbers and want to know

which excel function can i use to select a particular number from a set of data. e.g i have 1000 numbers and want to know how many 40's are in there. kindly explain how the formula works as well. i tried vlook up and countif- didn't work. thanks

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 Mathematics Questions!

Please Help! Write a program in C that follows this outline precisely: Problem Statement Many people like to visit casinos for entertainment. One of the common games available is Blackjack. In order...

I need help in this program. I don't understand how I should start working on this. 2 Machine details and background concepts This section explains many background concepts, while the following one...

Fifty questions. Will give a $10 tip if I get above a 90% Question 1. 1. A histogram with only one peak ________. (Points : 2) does not have a mode value is unimodal is bimodal has a high degree of...

Build a Model Spreadsheet a. Find the FV of $1,000 invested to earn 10% after 5 years. Answer this question by using a math formula and also by using the Excel function wizard. Note: Use a...

The 1D array StudentName[] contains the names of students in a class. The 2D array StudentMark[] contains the mark for each subject, for each student. The position of each student's data in the two...

BUDT733 - Homework 2 Quantitative analysis of credit This Assignment is based on the same data, credit.xlsx, which we used during Class 2. This data file is available in the assignment page on...

bus 345g h3.. : In your opinion, can you be objective concerning a "dead pool" of which retailer will go bankrupt soon, which retail chain would you guess would be the next to fall? Can you please...

Philadelphia Modern housing areas often seek to obtain, or at least convey, low rates of crimes. Homeowners and families like to live in safe areas and presumably are willing to pay a premium for the...

How to get a good answer using data and analysis tools in jmp 1 uses the other variables to predict "passion." passion would need to be aggregated into high/low first, and then you can use logistic...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

A high speed bullet with mass of 200 gr strikes a solid wooden ball of mass 5 kg and 10 cm diameter, suspended from a 3.0 m long 50-kg log which is pivoted at the top by a frictionless pivot. The...

4.11 Two masses are connected by a rope that runs over a pulley, as shown in the diagram. The friction force on the 10 kg mass is 35 N. a) What is the acceleration of each mass? b) What is the...

Which of the following accounts is least likely to be shown on the balance sheet of a debt service fund? a . Bonds payable b . Investments ( at fair value ) c . Cash d . Special assessments receivable

The solution of Propranolol Hydrochloride (Mr = 295.8 g mol^-1) with a concentration of 1.80 g/L was prepared. Predict the theoretical pH of precipitation for this solution. Measurement Record the pH...

Q No 03. a neon sign for a his restaurant from 12 light bulbs. Here is one condition: when a bulb fails, it appears as an infinite resistance and cannot conduct current. You have designed two options...

1. Below is depicted a graph G constructed by joining two opposite vertices of C12. Some authors call this a "theta graph" because it resembles the Greek letter 0. a. What is the total degree of this...

Shaquille operates a drug-running operation and incurred the following expenses: Salaries $200,000 Illegal kickbacks $ 32,000 Bribes to border guards $ 24,000 Cost of goods sold $300,000 Rent $...

Nicholas loaned Lyle (a friend) $30,000 in 2008 with the agreement that the loan would be repaid in two years. In 2009, Lyle filed for bankruptcy and Nicholas learned that he could expect to receive...

Write a program to wish happy birthday to a student. Firstly, take today month and day as an input and secondly take birthday as an input in the form of month and day. If the input day and month...

Analyzing underapplied or overapplied overhead. Pappas Manufacturers uses the direct labor hours method for applying manufacturing overhead. The overhead application rate for 19X7 is $5.49 per hour,...

Identify trends in business organizations and areas that may need to be addressed in the future to manage change more effectively. LO1

Preparing an income statement. For the fiscal year 19X7, the Nagata Machinery Corporation accumulated the following data: Instructions Prepare an income statement for the Nagata Machinery Corporation...