specific data

  1. S

    Selecting specific data from a table

    Hi, i'm solving the problem. I have source data in a table with many columns, where I need when the same value is in the column LV, and rows with the same value LV, take selected value from the column Name, Adress, Adress - Town and Address - Postcode put this data into one cell the same for...
  2. angeloudaki

    Conditional format duplicates for part of cells only

    Anyone know the conditional formatting formula for highlighting cells where characters before '@' match? These characters before '@' can range from 3 to 6 letters/numbers in length so I can't use the "first 4" formula, and the characters after the '@' also differ so I can't use that as an...
  3. P

    Hiding/Protecting Specific Code in VBAProject

    Hey team -- Long time fan of Mr. Excel, but this is my first post and I hope that you can help me out! The code written helps me to determine if my students are sharing excel templates in order to submit less-than-honorably-produced assignments. I created some code to automatically log the...
  4. T

    Need a formula to keep characters before a dash (-)

    I have a large list of data with the format of xxxx-xxx-xxxxxxx-xxxx (see examples below). I need to pull the data in front (to the left) of the first dash (-) into its own column. The rest of the data (to the right of the first dash) can be deleted. FYI, the data in front of the first dash...
  5. O

    VBA: create macro button to open file directory and import txt data to excel

    Hi all, ive been searching the web for answers over the weekend but to no avail. i have no knowledge on vba codes so go easy on me. i would need help on the following: 1. when i click the button, it opens file directory C:\desktop\ 2. i will proceed to select .txt or .csv file 3. upon...
    • Ouble
    • Thread
    • column import .txt file macro button specific data vba
    • Replies: 7
    • Forum: Excel Questions
  6. mrs night

    Need macro or formula to find & highlight specific numbers in multiple worksheets

    Hi Everyone, I am looking to select a column with numerous 4 digit numbers in it and have any of those numbers in the column be automatically highlighted or font color changed in multiple worksheets. Example: worksheet 1 4 Digits need to found in all other worksheets 5496 4526 9600 1234...
    • mrs night
    • Thread
    • automate excel highlight multiple worksheets numerous sheets specific data
    • Replies: 14
    • Forum: Excel Questions
  7. R

    Select certain rows

    Hello! I have an excel file with over 5000 names. The column headers are (First name, Last name, address, email, so on and so forth) I need to separate this list from the people who have emails and the people who do not. Is there a way to select the "rows" that contain emails. Sorry I'm a...

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