if-formula

I have a spreadsheet in which the user enters the answer to several yes / no questions and based on these answers I want to decide whether a certain row contains a "Vesentlig anvendelse". The flow to decide whether it does follows this chart, where "ja" = "yes" and "nei" = "no": The table...

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...

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...

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...

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...