group data

Hi All, I am looking to get a rank column as shown below using some rank functions. We have to group all same locations and rank within the group. Then, the lowest sales should get the first rank. If the sales are same, the rank should be given based on the second Column Amount. For example...

Hello All, I am working on a project that will Group/Ungroup specific columns based on a loop. for ease of maintenance I have created Named Ranges for the groupings to Expand or collapse the groupings based on a variable in a list. Here is the list Excel WorkbookABC1DivisionsNamed...

Hello, Thank you for tacking your time to help me out. I have in one sheet a list of hardware (Bolts, washers, Nuts, Rods, etc.) and I want to make kits in other sheet. For example: I have in one sheet 10 1" x 2 1/1" Bolt, 10 1"Flat Wahers & 10 1"Nut and I want to chane it to 10 1" x 2 1/1"...

Sort data by one column then total by using sub totals in that colomnHere is my data: Description Seller Number Buyer Number Sale Price Commission Sales Tax Buyers Preimum Total Brown Riding Plush Horse 100 342 30.5 6.1 1.83 4.58 36.91 Blue Boys Mongoose bike 20" 200 200 55 9.9 Queen Purple...

Hello, Is it possible to have a drop down list that if, for example, you select option A it generates a group of X lines beneath it but if you then change to option B it modifies the grouped lines to more or less, depending on what you need, and if you remove the option (or choose the empty...

I have a table that lists States and Cities. I need a measure that counts how many distinct cities exist for each state. As an example. Say there are 500 cities in CA and 10 Cities in NV. My result should look like Los Angeles 500 San Diego 500 Las Vegas 10 Reno 10...

I have a "volume" column that is based on total sales and is split up into 4 catagories in an Excel PivotTable. However, I want to subdivide each of these 4 volume levels by the top 50% and a bottom 50% in each of the 4 catagories, with a subtotal for each of these top and bottom "groups" in...