unsorted

  1. albertc30

    comboBox to display data in alphabetical order...

    Hi all. I am trying to show combboxes on userform to display the data, say customers, in alphabetical order. I have found the code bellow on MrExcel but it's not working. I am getting run time error 13, type mismatch. Private Sub UserForm_Initialize() ufcbbname.SetFocus allowed.Text...
  2. C

    Get max value on unsorted row with 3 different number groups.

    The table in Excel 2010 is used to regeister all details for 3 different types of invoices each in a column and each ID is a sequence within each group. I want to use a formula to solve this. The groups of invoice ID's : Type1 range 20000-30000 Type2 range 4000-10000 Type3 range 50000-60000...
  3. L

    Rank within an unsorted list

    I have a large set of data. Entries are put into categories (e.g. 1 and 2 in table below) and what I am looking to do is to rank entries according to their sales within the category. An illustrative example below, but my dataset is quite a bit more complicated not additional sorting etc can be...
  4. F

    Transpose unsorted items

    So lets say that I have a table like this.. <tbody> TID Person Type Name 1 Andy F Orange 2 Andy M Beef 3 Andy V Carrot 4 Andy V Spinach 5 Bobby M Ham 6 Bobby F Apple 7 Bobby V Carrot </tbody> I want to transpose it so that it will be sorted according to the Type, I want it to...
  5. C

    maybe a complex lookup ?

    Hi. I want to create a sort of lookup by joining multiple ranges like in the table below: <tbody> A B C D E F G H 1 <tbody> product_name </tbody> <tbody> sku_code </tbody> <tbody> sku_code </tbody> <tbody> qty </tbody> 2 <tbody> apples </tbody> <tbody> c1 </tbody>...
  6. N

    Count specific values in an unsorted, random data base

    How does one count the number of x and y values (occurring in same row) in this array? Time1 x a b c d Time2 b c x y a Time3 x a y d b Time4 a b c d e Time5 y d a x d Time6 c y a d b Note all of the variables above are positive numbers. The answer should be 3. Thank you,
  7. L

    lookup item number with operation

    Hi, Ive seen similar posts but cant find what i need to do: i have a database with many fields, "item number" is in column A and "amount in stock" is column N. item numbers are repeated often in column A and are unsorted. for each item appearance, i need to deduct -1 into "amount in stock"...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top