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

Top