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...

Some videos you may like

This Week's Hot Topics