Get instant live Excel expert help to learn how to use Large function?

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I have a large list of email addresses, first names, surnames and telephone numbers that I need to match to another list of email addresses.
Solved by K. H. in 25 mins
Hello, Sometime i have copy some text and past into excel file and the text is large formated so how to setting that.
Solved by F. E. in 19 mins
I need to pull large numbers of names, emails and phone numbers from a table that only has one column. The Names are in Bold, and in the cell under the name (in the same cell as each other) are the emails and numbers. Is this possible?
Solved by Z. Q. in 17 mins
How do I set up a script or something else to subtract a set number depending on how large the numbers are in the cells? For example, Id like to subtract 5 from each cell if the number in the cell is less than 50 but greater than 5 also subtract 10 if between 100-50. subtract 15 if greater than 100 but less than 150. Id like to set something up to automatically do these options for me.
Solved by S. H. in 14 mins
I am using solver to solve two columns linearly and it gave an answer to my model. But how do I put constraint that only either cells in one of column will have a value. For example, if the cell in column 1 has a value then cell in column 2 will be zero. This will be carried out in large number of data. Just curious is MAX or IF function is linear?
Solved by Z. Y. in 25 mins
You are the new Director of Operations for Transport for London's (TfL's) 'Santander' Bike Hire Scheme. The docking machines all over London secure bikes that have been returned to the docks by customers, but they are then not in the optimum place at the start of each day for the customers to hire them again. So every night, TfL re-distributes bikes back to the docks where they are needed. The number of bikes hired each day is automatically recorded on each day and you have the data for each day's hires between July 2014 and August 2010. In addition, daily temperature data has been included for each day of the recorded sample. Your job involves analyse this large dataset to address the following taks. You will consider this large dataset that you have been provided with as a population.
Solved by V. Q. in 23 mins
I have put pictures as comments for my rental form so customers can just hover over the item name and see the picture of the item. Then they can enter in the number of items they want. But now the spreadsheet file is too large to send over e-mail. Any way to compress the file?
Solved by Z. Y. in 18 mins
Hello. I have an Excel that I need to determine an Incentive rate (percentage) for selling certain type of products. The rate is based on a few different variables 1) How large is the organization (A: up to 2,399 users, B: Up to 5,999 users, C: Up to 14,99 users, D:15000+ users) 2) The product Category (Core, Tier 2, Tier 1, Azure) 3)If the order is "New "Renew" or "Mid-Term". I have an Excel that I'm trying to add which I can screenshare.
Solved by V. A. in 30 mins
Hi, I have a growth rate model based with a scale from small, medium, large, extra large, plus this is over a 12 month period. I have several companies to predict the number of enrolled users based on this data but where I am stuck is that when I move the launch date of the company how to I get the growth assumptions to know to reference the first month in the growth model but also within the correct moth of launch. for example; M1 M2 M3 M4 M5 Small 12% 25% 37% 49% 61% Medium 8% 17% 24% 39% 50% Large Extra Large Jan Feb Mar Apr May Jun etc... Company A Company b Company c Company d Now if say Company A decides to launch in May, how do I get the formula to know to look at the %'s in the the column for M1 and put the figures starting from May onward?
Solved by V. L. in 29 mins
I have a very large dataset that I'm using to create a pivot table. I need a way to filter through the slicer in a way that is not so cluttered.
Solved by X. H. in 12 mins