contained

  1. R

    V Lookup Error

    Why is this formula returning 0 instead of the text that is contained in the cell it refers to? =VLOOKUP($K3,Sheet2!A$1:B$110,2,0) It does not happen in every cell it is in.
  2. M

    Macro to retrieve data and to return in tabular form

    Hello guys, I would like to run a macro that allows me to group some data that is scattered into tabular form. In particular, the information to be retrieved is "anticipated" by a number label contained in the cell immediately to the left of the relevant data to be retrieved. In addition, these...
  3. D

    How to go about

    I'm lost on how to go about taking the follow data from a excel spreadsheet and creating the listing on the bottom. My data looks like this (sheet1) Company Product# A 10 A 11 A 12 A...
  4. P

    Sumproduct Advice please

    Hi All, I have the following formula that i wanted to total up where items in Col E match items in Col F and give me back a total. =SUMPRODUCT(--('Pending Prod Orders'!E:E='Pending Prod Orders'!F:F)) For some reason its counting all the blank cells that are contained in these columns which...
  5. L

    Auto fill date when row changes

    Hello, I am trying to find a way for an automatic date stamp to be populated into a field (Col J) in a row when any other cell contained within the same row is changed or modified. I know this is easy just haven't figured it out
  6. H

    Sorting Data Across Two Columns

    Hi, I'm looking to sort two sets of data so that matching pairs appear in the same rows and gaps appear where there isn't a match. The end result would look something like this: <tbody> 1 1 2 3 3 4 5 </tbody> The columns either side of these (A and D, assuming that the above are...
  7. S

    Macro that search if a range of cell match another range

    Hello i need to know if an item (Column F) in "Table 1" sheet is contained in the "list of products" sheet and return if true or false with the description of this product and its strength(Column E & F)
  8. D

    IF & ELSE IF formula

    Formula for this: If column C= "Y" then amend column A "ABCDE" but what if column ="N" then i want to leave column A with value already contained in that cell
  9. L

    Instr substrings

    Hi all, Is it possible to use multiple substrings with inStr? I want to test if the following characters are contained within mystring /, \, ?, %, *. Many Thanks
  10. A

    Error Message - Run-time error ‘91’: Object Variable or With Block variable not set

    Hello everybody, I'm building a quite complex Excel model - complex at least for me. Objects involved are basically 3: - Worksheet containing data; - Userform1 (UFSchedaNavigazione) where I have the list of data contained in Worksheet; - Userform2 (UFImmagini) where I have a set of pictures...
  11. T

    Searching the Spreadsheet for a Value, then Returning the Contents of the Cell 1 Where the Value is Contained

    I have a google sheet im working on (but I also have it built in Excel). The sheet analyses property values and makes predictions. I have included a link to a sample of the sheet here: https://docs.google.com/spreadsheets/d/1kjMViyfXUYDmMDP5PutoQbgDBP92oCnqWd_CcLQ5kMY/edit?usp=sharing I am...
  12. E

    Formula to find any words from Col A in Col B (on same row) and confirm yes / no in Col C

    Hi, I'm trying to find a formula to check whether any search terms in Col A (which would be separated by spaces), are contained in in Col B (words also separated by spaces), and put a "yes" or "no" in Col C In the example below, Col A is the data to be cleaned up, Col B is the Categories to be...
  13. Nelson78

    If string detected in a cell, clear entire row

    Hello everybody. I'm struggling with this job: for each cell in a column, I have to check if the letter "I" is contained. If yes, clear the entire row. Now, with the following code something is wrong (all rows are cleared, also if "I" is not contained). If InStr(1, cell, “I”) > 0.5 Then...
  14. jefflee

    return the value that the text is contained in a cell

    Hi, I have the data hereunder <tbody>#CACACA[/URL] "] E F G H I J K L M #CACACA[/URL] , align: center"] 101 102 john #CACACA[/URL] , align: center"] 107 108 smith #CACACA[/URL] , align: center"] #CACACA[/URL] , align: center"]17 </tbody> requirment ...
  15. jefflee

    return the value that the text is contained in a cell

    Hi, I have the data hereunder <colgroup><col style="width: 30px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width: 75px;"><col style="width...
  16. S

    Information from files on SharePoint

    Good evening all. I am trying to aggregate data from other workbooks that are contained within file folders on sharepoint. The method that I used previously use to work. PowerQuery would navigate to the sharepoint folder and then would start to aggregate all of the tables from the excel files...
  17. M

    Storing Values in Module?

    Afternoon, I have a simple problem but one which I am not yet experienced / understanding on how to create it. I do alot of calculations in a source workbook, this data then feeds into the Main workbook (where the code is contained). How do I retain each calculated value in the Source workbook...
  18. C

    filter many files with the same table headers

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I need to filter the data of tables, of different files, contained in the same folder "GEONAMES - FILE EXCEL", according to the settings entered in the file setting. the...
  19. C

    COUNTIFS with wildcard and or function

    I'm stuggling with this formula. I need to do a COUNTIF that uses wildcards and also an or function. The below is what I started with but then I realised that any cell that contained the exact contents of A8 isn't picked up in the count. =COUNTIF('Sheet 1'!$Q:$Q,"*"&A8&"*") Say for example...
  20. C

    Variable Referencing cells?

    I'm sorry, really couldn't think of how to phrase this question but here it goes: So we all know you can have a formula reference another cell, so for ex: =c4*d5 But what I really want to accomplish is the following: =c(a1)*d5 to clarify, this would mean that if a1 contained the...

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