“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to find a way to remove all non-numbers from a large database

Solved by V. H. in 16 mins

Hello, I have a large spreadsheet of hourly evening temperatures for multiple site (columns) for multiple date (rows). I need a spreadsheet with the max temp, min temp and the difference of max and min for each date (rows) and each site (columns). I can upload an example of a previous document sorted in this way to help clarify what I need.

Solved by C. Y. in 12 mins

i have a really large file and another files and i want to find the same values and wxtract them i a different file but with conditionl formating it is really slow

Solved by F. Y. in 19 mins

i need help with a formula i have a large file

Solved by V. A. in 26 mins

i need an expert cuz i have a problem with a large file

Solved by C. B. in 20 mins

I am trying to excel count unique text that occurrences of a single text event before a unique text event for specific ID's. For example, ID1 has 5 events, the first 4 are Appeared and the final event is No Show. I am trying to find the average number of appearances before a no show for a large group.

Solved by M. Y. in 15 mins

My Department Store runs a reward program to give customers a 10% discount for any purchase large than $1000, 20% discount for any purchase larger than $2000, 30% discount for any purchase larger than $3000 and 40% discount for any purchase more than $4000. What function can I use to calculate the reward.

Solved by D. J. in 24 mins

A survey conducted by the Segal Company of New York found that in a sample of 189 large companies, 40 offered stock options to their board members as part of their non-cash compensation packages. For small- to mid-sized companies, 43 of the 180 surveyed indicated that they offer stock options as part of their noncash compensation packages to their board members.
-Based on the scenario, set up a contingency table.
-If a company is selected at random, what is the probability that the company offered stock options to their board members?
-If a randomly selected company is a large company, what is the probability that it offered stock options to their board members?

Solved by D. Y. in 27 mins

I need help creating a contingency table for this information, and what is the probability that the company offered stock options to their board members?:
A survey conducted by the Segal Company of New York found that in a sample of 189 large companies, 40 offered stock options to their board members as part of their non-cash compensation packages. For small- to mid-sized companies, 43 of the 180 surveyed indicated that they offer stock options as part of their noncash compensation packages to their board members.

Solved by S. W. in 26 mins

I want to have a formula that calculates the average of the two highest %back for each athlete using specific races. I have not been able to find a way to select more than 3 races as it will not work. For example: =(SUM(LARGE(J3,L3,P3,1),LARGE(J3,L3,P3,2)))/2 The second set of data points (J3,L3,P3) will not be selected a second time.

Solved by F. F. in 12 mins