if-formula

  1. V

    Fill a value in the cell according multiple search terms in the other cells of a Column.

    Here i make an example table, and the main task what i want to do. an excel file mix of lawyers and agencies names mixed under a single column. I want fill column D with yes if the Stuff in A is Law agency, (using search terms attys, inc. bar, assn) like this and seprate the agencies from the...
  2. F

    =IF(AND formula over several worksheets

    Dear all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a excel file with over 190 worksheets. I want to make a summary sheet, in which one cell counts the answers over all sheets if in each sheets one cell shows a 1 and another cell shows a two...
  3. J

    All cells containing the same word in a list

    Hi, I'm trying to imitate a kind of filter through means of a formula. I have a list with products and their respective quantities, but now I want to filter all articles with a similar description, f.e. cereals. But some of these cells are abbreviated, so the cell could also contain "cer." Now...
  4. S

    Autofilling values UPWARDS

    Hi! Does anyone have a solution on how to fill a value upwards until a new value appears? (and then repeating the procedure after the new value) I know this can be done downwards with "find -> blanks, entering a formula and then ctrl+enter" but I cant figure out how to make it work upwards...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top