# 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

I have a large file of names and addresses, i need to scrub the list and if duplicates exists remove them, how would i do this.
Solved by S. J. in 20 mins
I have a large variable data set..I'd like excel to sort the numbers from lowest to highest. Is this possible?
Solved by X. W. in 28 mins
I have a large variable data set..I'd like excel to sort the numbers from lowest to highest 'd like to have a separate column(s) that list the numbers in the blue font (rows 6,9,12,15..etc) in order from lowest to highest and be able to reference the column and row number so that the numbers position is easier to locate. Example: if 24.887569 appears in the list next to it there will be a reference saying Row 6, column S The first number is always "0" and the last number is less than 1200
Solved by O. C. in 17 mins
Hello! I need help with a formula. I have two Sheets - Sheet 1 (Product Info) & Sheet 2 (Order Calculations). In Sheet 1, there is a range for the Products (e.g. A1-20), as well as the prices by product and size (e.g. for Small prices S1-20, for Medium prices, M1-20, for Large prices L1-20). In Sheet 2, I have a few drop down options: For example, "Product Type" with a dropdown of all A1-20 items. Then I have a field with the Size options, so the dropdown has "S", "M" and "L". If I want a formula in Sheet 2, depending on the dropdown of "Product Type" (A1-20) & "Size" (S/M/L), how do I make it take the correct information from Sheet 1?
Solved by I. E. in 20 mins
Hello, I am trying to sort through a large amount of data. Basically, I have a daily settlement report for each day of 2017. I am trying to find the easiest way to do the following: 1. Find electric generator names out of a column with a header of "settlement location" that match a set of electric generators from a specific list of names. 2. take the data from a column with a header of "interval" for each of the generators collected from the list above. 3. Each daily sheet is a CSV. I am trying to gather revenue data for generators in only two states out of many. Sum the revenue data for each of the two states. Any suggestions?
Solved by B. J. in 30 mins
I need a formula in column T on the fy19 budget tab that matches data from columns H, M and O on fy 19 budget tab with columns A,B and C on the AAR_Detail tab and returns the value in column AE from AAR_Detail to FY19 budget column T. I will forward spreadsheet in chat - too large to upload.
Solved by D. L. in 25 mins
need to extract parts of a cell and input into three different columns - file is too large to upload - will send once connected
Solved by G. H. in 18 mins
my x axis maximum is too large. how do I change maximums and minimums
Solved by V. J. in 11 mins
I am trying to perform a vlookup or index match for a large data set. Normally I rely on vlookup but it is giving me data from the wrong column whatever I do. I have tried to move to vlookup and it is doing exactly the same thing. Do you have any tips?
Solved by O. W. in 16 mins
How can I create PIVOT Table for a large data having merged cell and free spaces, please
Solved by Z. L. in 16 mins