cell contains

  1. D

    If Cell B = text in col C, input value from col A

    Hello everyone, I wanted to know if there was a formula or macro that I could use which would look up a string of text in column B:B and if found in column D:D return the value which correlates to its row, but the value i want is in column A. Its hard to explain but i am attaching an image...
  2. N

    VBA to find certain text and then delete whole rows containing it in all sheets of a workbook

    Hi, I haven't written/recorded a macro in a very very long time and am struggling to try and do something simple. I need to search all worksheets of a file (containing around 100 tabs) for cells which contain the text "_web.pdf". There is also other text in the cells. Then for all cells which...
  3. J

    How to count if cell contains text from a range

    Hi, I have this formula: =COUNTIFS('RAW DATA'!$H:$H,"="&$A$1, 'RAW DATA'!$E:$E, $A7, 'RAW DATA'!$G:$G, "*U6:U28*") In the last criteria I am trying to count if the cell contains text from a range but the result it is giving me is 0, when I know the output should be 12. And I need it to be a...
  4. J

    Locating a cell in a row with a specific name

    Team, I am trying to use an excel spread sheet copied into a Sheet in excel to input information. Example: Sheet 1 Cell A2(in cell A2 =desired number) I want information to be filled with units sold by Location1. The location information will be in Sheet 3. The difficult thing is the...
  5. B

    IF D2 contains X then divide I2 by 10

    Hi All, Have a major problem with our monthly call billing, we basically have a spreadsheet which shows a number called and the total cost of the call. However our the calls for 0844 & 0845 numbers are 10x the actual cost! Does anyone know how i can run a macro which will find the 0844 &...
  6. K

    VBA - If Cell Contains Email address

    Hi There, I want to get a VBA code for checking if a particular cells has got any email address Suppose Cell A1 = abc then it should give error "Please enter a valid email address" and If Cell A1 = abc@xyz then it should let the user enter that value as it is a valid email address VBA code...
  7. H

    cell contains other cell's text - not a specific text

    Hi all!;) I will appreciate your help. I need to find out if a certain cell contains other cell's text- it's not a specific text.If A1 contains the text in C1.... do you have any idea how to do that?? Another issue if you can figure out is the formulas I've tried so far couldn't identify if...
  8. S

    Formula Question: Return a Value if a Cell Contains a Letter within a Text String

    Hi, I have a cells drawing information from a table. In this table I have model numbers to depict products in one column. In another column I have sales totals for those model numbers. I would like to sum the sales for those model numbers if the model number contains an S. Conveniently...
  9. F

    sum of item. containting different words

    <TABLE style="WIDTH: 159pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=211><COLGROUP><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><TBODY><TR...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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