Microsoft Excel

The TEXTJOIN is a new function introduced in 2019 and available in Microsoft Excel 2019, Excel 2021 and Excel for M365. The TEXTJOIN function combines the text from multiple strings or range separated by delimiter. While we can use TEXTJOIN to combine the texts , the above requirements cannot be achieved alone with TEXTJOIN as we need to combine the data for each user separately. Hence we need to use TEXTJOIN and IF functions together to achieve the desired result.

VLOOKUP is a function in Excel that perform a vertical lookup by searching for a value in the first column of a table and returning for a value in the

As an IT Professional you may have to deal with lots of data every day. I have seen many experienced IT admins spending quite lots of time on the activities