Excelblog.pl Website Review

my experience with excel. about formulas, macros, vba and other excel digits. searching tables in excel - two words in one row (column) andrzej, one of the readers of the blog asked the following question: the task is that if in column 1 is the word maria in column 2 opel, then excel is to search the whole table and check that both words appear in one column (or row, after transposing the table). if so, insert the letter s if, because the attempt to answer this question is combined somewhat (I even decided to use the same sample table) with mine I decided to follow the blow and propose a solution to the problem, and in principle one of the possible solutions. on the left side we have a table in which we will look for expressions. this is exactly the same table that I used in the next table there is a place for entering two wanted words, a column with information whether these words are on one line, and two columns with information about the number of this line (number counted from the beginning of the table) from the beginning of the workbook). at the end of the formula, which I put in the columns i, j and k. all formulas are table formulas entries on the blog will not have problems with understanding formulas. if you have not followed my posts ... well .... it's time 1, we check if two words are on one line. 2. we return the number of this line (counting from the beginning of the table) 3. we return the number of this line (counting from the beginning of the workbook), I have not tested it for too long, but it seems to work as it should. I will add that my as*umption is that the search word pair only appears once in the searched table. for all interested files with an example to do*nload .. search the table and the column header with the found value. today a small exercise that shows how to excel the same effect can be achieved using completely different functions.