samsung

  1. R

    Separating the string

    I have a column where customer can input the Manufacturer and model number like <tbody> Goodman FGTRD-25418 Phillip HGYTFD25148jnh HYGFN84K YTR5245F Samsung Sonic </tbody> Now I have another two column where I have to put Manufacturer and model number like below How do i do...
  2. R

    Index Formula with IF

    Hi, I'm trying to set up a 1 column table (Table B) that looks up the unique values from another table (Table A). Table A <tbody> Company Contract Apple 123 Google 456 Samsung 789 Apple ABC Samsung DEF Samsung DEF </tbody> Table B <tbody> Select Company Samsung 789 DEF...
  3. U

    Compare 2 columns and delete all junk.

    Hi, my English is not good but I will try. I have a reference column with products and I want to compare it with another column and delete all text that is not related to the control column. Example... LG G6 .................... LG G6 New promotion Samsung C5 .......... Samsung C5 Deal offer...
  4. O

    Data validation, but is it possible?

    Hello, I need a data validation to go in column A which have names of the articles . These names of articles in column A will have the first character capitalized and the very next one should be non-capitalized. The third character is of no importance and hence no data validation require for...
  5. J

    How to split data to multiple sheets by use referenced cell data

    Good day, I have once sheet that has a lot of data of sales and commissions, etc. The data is complied by use of remittances that is received daily and is dependent on when an items is sold. Due to this it means that most of the the information for an item received in June might only be...
  6. R

    Select the output based on multiple column conditions

    <colgroup><col><col><col></colgroup><tbody> Phone Country Approval Date Iphone Singapore 9/1/2016 Iphone Singapore 9/1/2017 Iphone Vietnam 9/15/2017 Iphone China 12/1/2016 Samsung Singapore 12/1/2017 Samsung China 12/15/2017 Samsung Turkey 1/5/2016 Samsung Turkey 1/5/2017...
  7. F

    Formula to skip a certain value and continue on the sequence

    Hi everyone! First time reaching out for help, I have a sequence in column A and would like to pull the data into column B. But the thing is I would like to skip over the cell if it states "All Other" yet continue on the same sequence. I remember writing a formula a while ago for this, had some...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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