1. P

    conditional formatting help

    Hi, I need to have rows highlighted that have to meet 3 criteria in a table and was unsure what statement would be best, two have to be a specific text and one has to be above a certain number.
  2. M

    Finding a date in a column

    Hello forum, The title is a bit misleading. The dates I'm looking for are the last days of a month, however, EOMONTH won't work in this instance as the data is financial, so as such the last day of the month could be 29th April for example. I'm trying to find the most efficient way of...
  3. P

    Strings in formulas for cell references

    I am trying to make the following work in Excel, not VBA. =INDEX('[&A2&.xlsm]&B2&'!$B:$G,5,1) I know I am missing string quotations, but am unsure what else is missing. Does anyone have any input here?
  4. J

    Lookup a value in multiple closed workbooks?

    Hi, Unsure of the best way to achieve this Example: this workbook.Sheets("Sheet1").Range("A1") = "OrangeBlue" I have a folder with 12 files and I want to fetch the row of each workbook where "OrangeBlue" is found. I know how to loop through and open/close each file, just unsure of the VBA...
  5. O


    Looking to populate a fourth cell based on the values in three other cells, If A29 is blank and B29 is "green" and C29 is "red" the I would like cell D29 to be "Team B" otherwise I would like cell D29 to be "Team C". I am unsure how to write this formula.
  6. R

    IFS problems

    so I have reference cell say (B49) which has been formatted with a drop down list. The three entries are 1) Need, 2) Want, and 3) is Unsure. Now in F49 is where I want to get the answer to my IFS so if B49 is "Need" the results of F49 should be $10.00 if the results in B49 is "want" results...
  7. N

    Creating Frequencies

    Hi, I'm new here and hopeful this posting follows all guidelines. I tried to search for this but was unsure what I was looking for. I have spreadsheet that is thousands of rows long. Every 7 rows contains: a total; and 6 rows of data that make up that total. I would like to add a column and...
  8. M

    VBA to FireEvent but only if necessary

    Hey, I would like to detect if a webpage element reacts to being clicked, if it doesn't react to being clicked using .click - I'd like to use fireevent to finish the click. I'm unsure how to determine the element has or has not been clicked. Is there a way to do this? Thanks!
  9. M

    Syntax to refer to a range within an array

    I'm doing some things with arrays but stuck on the syntax using the format array(i, 4) can anyone tell me how I would refer to the range array(i,1) to array(i,5) , I'm just trying to set the values to nothing within that range but unsure of the syntax and don't want to set each one separately if...
  10. N

    Find & Replace Line Break

    Hopefully an easy one this. I would like to find and replace all line breaks within each cell in column K of my data, with a space instead. I do this with some other characters, but am unsure how to do this with a line break. I can do this manually using the replace tool and then using either...

Some videos you may like

This Week's Hot Topics