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

Can you sort this from largest size from the values in column E

I want a formula in cell Q10 that checks for 1. a simple occurrence of a modal value but if one doesn't exist I want 2. the 2nd largest number in a data set Q13:Q1000 provided that this latter value does not equal the value of Q7, in which case 3. I want the 3rd largest number of the Q13:Q1000 values.

Hello The following is my file in which i need to use a database function to find out the smallest, largest and average sales in the central region.

I have three columns; Incident, $Lost, Action; I need to match an Incident from the table, find the largest $Lost, and report the Action.

Hey I need help with VBA. The first functions that you will create are helper functions that can be used by otherfunctions. Function FindMax(valueArray, nameArray) As String This function takes in two arrays; the first array has the numeric values while thesecond array has the names. The function will find the value in the first array that isthe largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is (“House”, “Chair”, “Table”, “Book”). The function will return Chair.

I'm trying to make a VBA function with two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array).

I want to sort a list of numbers into smallest to largest while retaining the numbers original list number value

Freeze the first row on the Fleet Information worksheet. Convert the data to a table, name the table Inventory, and apply the Table Style Medium 19. Remove duplicate records. Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest. Repeat the field names on all pages. Change page breaks so each vehicle make is printed on a separate page. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Click the Sales Information worksheet and convert the data to a table, name the table Sales, and apply the Table Style Dark 11. Type % of sticker in cell E1. Create a formula with structured references to calculate the percentage of the Sticker Price in column E. Format the range E2:E30 with Percent Style Number Format. Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price. AutoFit the width of columns B:E to show the total values. Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data. Select the range E2:E30 and create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sale price. On the First Quarter Sales worksheet, rename the table FirstQuarter. Filter the data to display January, February, and March sales. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Select Landscape orientation for all sheets.

Convert the data to a table, name the table Inventory, and apply the Table Style Medium 19. Remove duplicate records. Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest. Repeat the field names on all pages. Change page breaks so each vehicle make is printed on a separate page.

Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest. Repeat the field names on all pages. Change page breaks so each vehicle make is printed on a separate page. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.