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

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.

I have a large variable data set..I'd like excel to sort the numbers from lowest to highest. Is this possible?

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

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?

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?

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.

need to extract parts of a cell and input into three different columns - file is too large to upload - will send once connected

my x axis maximum is too large. how do I change maximums and minimums

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?

How can I create PIVOT Table for a large data having merged cell and free spaces, please