ralph

  1. E

    Formula to lookup multiple Criteria

    Hi all I am looking for a Formula that would solve a problem like this: =IF(BASE!BI:BI,1,LOOKUP(DAILY!G2,BASE!D:D,BASE!AV:AV So I want to search for the value in DAILY!G2 in BASE!D:D and if found return the appropriate value from BASE!AV:AV to CELL BJ2 in DAILY! ie If the IF requirement is...
  2. Z

    listbox value

    I've been looking for a way in vba to look at value(s) of a list box and find if a certain one exists, NOT selected item. but rather if it is in the list box? Any suggestions as this one seems to be a not well traveled road? Ralph
  3. I

    Creating Column from non-blanks in table

    I have a table structured as below with names in some of the cells and blanks in others and I need to create a results column that shows only the non-blank values. The actual data set is 10+ columns wide and 100 long. Also, it's important to first list all the data from column 1, then column 2...

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