You can use this method when you want to search for candidates that work in particular companies that you have listed. Remember to remove the operator at the end of the string! Because I used SPACE in column B before and after the operator OR, I’ll be able to merge the texts again in column D to build my final string.Īdelajda OR Agata OR Agnieszka OR Agusia OR Aleksandra OR Alicja OR Amanda OR Anastazja OR Aneta OR Ania OR Anka OR Anna OR Apolonia OR Asia OR Barbara OR Basia OR Beata OR Benedykta OR Bernadeta OR Bogdana OR Bogumiła OR Bolesława OR Bożena OR Bożenka OR Bronisława OR Brygida OR Cecylia OR Celestyna OR Czesława OR Dagmara OR Danuta OR Dobrosława OR Dominika OR Dorota OR Dorotka OR Edwarda OR Edyta OR Ela OR Eleonora OR Elżbieta OR Emilia OR Emilka OR Ewa OR Ewelina OR Ewka OR Ewunia OR Franciszka OR Gabriela OR Genowefa OR Gosia OR Grażyna OR Halina OR Hania OR Hanna OR Helena OR Henryka OR Hildegarda OR Honorata OR Iga OR Irena OR Iwana OR Iwona OR Iwonka OR Izabela OR Jadwiga OR Jadzia OR Jagoda OR Janina OR Joanna OR Joasia OR Jolanta OR Jowita OR Judyta OR Julia OR Justyna OR Kamila OR Karolina OR Kasia OR Katarzyna OR Kazimiera OR Klara OR Klaudia OR Klotylda OR Krysia OR Krystyna OR Kumiko OR Kunegunda OR Lena OR Łucja OR Magda OR Magdalena OR Malina OR Małgorzata OR Maria OR Marianna OR Mariola OR Mariolka OR Marta OR Martyna OR Marycha OR Maryla OR Marylka OR Marysia OR Marzena OR Matylda OR Melania OR Michalina OR Monika OR Nadia OR Natalia OR Oliwia OR Patrycja OR Paulina OR Renata OR Roksana OR Róża OR Stanisława OR Stefania OR Sylwia OR Szarlota OR Teresa OR Urszula OR Wanda OR Weronika OR Wiesława OR Wiktoria OR Wioleta OR Zofia OR Zuzanna OR Żaneta OR In column C I enter a function CONCATENATE, which allows me to merge texts that are included in column A and B. Then, in column B, in each row, I put OR (to be specific: space OR space). What I need to do is to clean it – remove rows with single letters.
Without a boolean builder it would take ages to manage. In column A, that includes my data, it goes down and reaches 152 records. Ever since I feel that I can easily sort out large searches and keep order with adequate strings. What I needed is a quickly accessible boolean builder. I thought to myself that there must be a smart way of building a super long string with excel. When I saw it, I imagined myself rewriting names one by one with “OR” operator between each. Let’s look at Wikipedia’s list of Polish female names: Next, I had to create a boolean string from them. To begin with, needed to find a list of most common names in the particular country where the job was. I decided to use the “first name method”. One of the most extended strings I’ve ever used, was when I was trying to find a female candidate for a particular role. Well, I once felt this dread myself, too. If someone is new to sourcing and only learns about boolean from the internet, it might be intimidating to see the length of some boolean strings.
0 kommentar(er)
