Man you are Genius, thank you very much!!

Really sunple and great idea..thanks..🎁🎁

Great stuff

great help

thanks

Sir please, any alternative function for TEXTJOIN ?

Do you have any idea how to update the attendance sheet which has multiple values for a single match

I want to make multiple entries of horizontally in one cell is there any formula? I made one month date sheet if enter value in any date it should be come in one cell.

very nice

@ExcelBasement

2 жыл бұрын

Thanks

Bro, when i select card id i need 1st cell number, after i select another card i need another relavant cell number, after i select previous card no, i need 2nd cell number, is it possible...?

What if we have sentences in column B, I tried it’s only pulling first word that’s it not complete sentence

So close to what I need, is there anyway to do this without copying the formula down? E.G. would be good to have something similar to E3#

@stevereed5776

2 жыл бұрын

I'm actually trying to do a count. In your example, the count of numbers per card ID

I was looking for such solutions for long time, great work, thanks, is it possible to get values in individual cells?

@ExcelBasement

2 жыл бұрын

Yes, definitely

@octavioacosta4984

2 жыл бұрын

@@ExcelBasement How exactly?

This formula not working office 2019. Please help this type of data exact office 2019 .

Does this work with dates

how we can do it without using textjoin and unique??

@ExcelBasement

2 жыл бұрын

VBA

does it still work if data source is about 30,000 cells?

@ExcelBasement

3 жыл бұрын

Yes

Can i get sum of value?

It's taking too much time for large data, any other solution

but Office 2016 it is not working .

@ExcelBasement

2 жыл бұрын

These are simple IF formulas combined with a new TEXTJOIN function (TEXTJOIN is only available in Excel 2019 and Microsoft 365).

Ala