logical check

  1. M

    VLookup only if Conditions meet

    Hi All, I am trying to achieve a simple logic. Tried to search over google and forum before asking but couldn't get anyway near. I am currently using below formula which is working fine but need to manually delete extra rows to obtain conditions. (In Table) =IFERROR(VLOOKUP([@[Mobile...
  2. K

    Help needed with a formula that Skip the predefined Value and Ignore the duplicate contents in a row

    Hi, I am creating a spreadsheet with several values (one Text value in each cell) i.e. <tbody> Row1 Col. A Col. B Col. C Col. D Col. E (The Result) Row2 Apple Banana NA Pumpkin NA Row3 Cherry Apple Mango Pineapple NA Row4 Apple Banana NA Pumpkin Apple </tbody> I wish...
  3. S

    Formula stopped working

    So I am pulling out my hair here, trying to figure out why over the last two months, this formula has been working, and now it stopped. I have duplicated my previous work to the letter, I have double, triple, and quadruple checked my data sets. I have named and re-named my ranges to ensure they...
  4. O

    VBA: Help with my logical test to remove spaces

    Hi, I am using a macro to pull data from a PDF sadly for some reason when I pull the lines of data random "." appear in the data. I have a test to run through each line and format the special characters out but sadly It condenses everything down, so now instead of removing all characters I...
  5. B

    Logical operation based on existing data VBA code

    Hi All Im am trying to write VBA code. I have a excel with 2 sheets named Current trades and opening position and third sheet i have added just for example of output. I want to create code based on following codition. Can anyone help me...It would be really kind. I generally can read...
  6. S

    More than 30 logical expressions in AND -- Quandry

    Hello, I have a formula which goes something like this =IF(D7="Yes/No?","Select Yes or No on Instruction sheet", IF((D7="Yes")...
  7. B

    VBA For-Loop Logic not making sense

    Hello All, I'm having a bit of a problem understanding the logic behind For statements in VBA and I was hoping someone could clear it up for me. I was basically trying to recognize if there were any blank textboxes in a userform, and assign different actions accordingly. Here is my code...
  8. J

    Logical Check: ISUPPERCASE

    I'm trying to figure out if there is any way of performing a logical check (possibly by way of a custom function?) to ascertain whether a cell contains a text string (no numbers) and is all in upper case (or lower case, or Proper Case). The reason for this is that I receive approx 10,000 rows...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top