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

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