Pilates Exercises For Bowed Legs

"Often I have to compare more than 500 entries of text (lists of names and surnames). It is important to compare identical columns (uppercase, tildes, etc ...) Is it inevitable to use conditional? Is there a simple formula to solve it? "

In response to both questions: It is not necessary to use conditional and yes there is a very simple formula to solve the problem described. Let's start as always setting an example:

To compare the existing names in Schedule 1 and Schedule 2, we will use two different methods. With the first we compare if the text entered in, for example, cell B4 is the same as the one entered in cell C4, regardless of whether they are written in capitals or not. To do this we place ourselves in cell E4 and type the following formula:

= B4 = C4

The possible outcomes to this type of formulas are TRUE or FALSE. In our case the solution will be true because the text of B4 is the same as that of C4. But if what interests us is to check that if in addition to containing the same text is written in exactly the same way then we must use the SAME . To do this we place ourselves in cell F4 and type:

= EXACT (B4, C4)

The SAME function compares two strings and returns TRUE if they are exactly equal and FALSE if not. This function is case-sensitive but ignores formatting differences. In the next chart you can see various examples of text strings and the result of applying the first and the second method:

Differentiate between upper and lower is a fairly simple (although obviously it is better to automate, especially if the number of entries is high) but not so much difference strings look similar but contain spaces before or after this string (to locate spaces in the middle of a string is also quite simple in principle). To avoid this problem you can use the SPACES. This function removes spaces from text except for the normal space left between words. Note that the B6 and C6 cells are apparently identical. But B6 contains a space after the name. To "cleanse" the space apply the formula SPACES (B6).