alphabetic

  1. J

    VBA unique cells

    Have a range of cells F4:F50. I now want to write a VBA code to enter all unique items from the range in cell: C55 and onwards Preferably in alphabetic order..
  2. T

    Formula which looks across Column for and with same value then applies formula

    Hi, I require a function which looks at a ID in a certain column and only compares values across respective rows for that ID: 1) Function looks at cells containing the same ID 2) Looks at which currency is first alphabetically and then if PAY or REC to determine the Buyer Issue I am having is...
  3. F

    Data Validation List Alphabetically

    Title says most of it, I want a drop down list to be sorted alphabetically. Currently I have a Translate Table, in which I have named Column 1 'items' and then a dropdown list using data validation is set to =items. If I add an item to the bottom of the translate table it adds it to the...
    • freya306
    • Thread
    • alphabetic data validation (list) list name manager table
    • Replies: 3
    • Forum: Excel Questions
  4. subrosumon

    If formula

    Hi Bro, I want to help from you to implement if formula e.g. 1. 7060006-56to72USD-Septo Jun16 2. Cost Clg. Reconciliation I want to get for sl. 1. when first digit will numeric it will say "INVOICE" sl. 2. when it says Alphabetic it will say "OTHER" to use if...

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
Back
Top