How to find URL from a value which contains in URL somewhere in Excel?
I have some unique value in column A (jnyiuusuxpnce0zcugto) and in Column B I have URL like (https://mykldexportsprod.blob.core.windows.net/userreports/imports/classic/jnyiuusuxpnce0zcugto_3771af52de.pdf)
there are 20000 record in column B and 42000 in Column
I want to take Id from Column A and find That and get the correct URL from Column B and paste it in column A
Count the number of common value within an excel table
I have a list of people and their ID.
I have a list of access they have, link to their ID and I can know which access they have( not the same number for each person).
Each people is in a team.
I would like to know the number of access that is common Inside a team.
The two tables are in two different sheets
How to highlight a unique value from several cells
I have a list of cells with data inside, separated by a ,
I would like to extract all the value that are common to each cells.
It works, I stole it from internet, I don’t understand it but it just works