Would it be possible to show Sumifs Vba for more than 03 criteria or best Alternative for that. this is for Large Database like Debtors Statement where i would need to tally with collection.
every solution is based on having "text" in one column , but how to substitute character from area of cells(more columns)? By the way, your way of explaining is quite good ,and simple, and I like it. Just this I missed there.
I almost gave up before I saw your xlookup demo here …thank you Chester
Thank you Chester. This is particularly useful for stuff I'm working on right now.
chatgpt and numerous videos had me using vba, when all i needed was vlookup, thanks Chester
Same, asif we even know what VBA stands for, when all we trying to do is df.replace()
The Vlookup just saved me about 100 hours of work, thank you.
exactly what i was looking for - thank you! also very good explanation :)
Excellent tutorial. Thank you for the VBA code Chester!!!
many thanks dear. this was very very helpful
Exactly what I was looking for
Your examples are quite unique and really useful.
Great tutorial 🙏
Is there a way to do this with fixed ranges vs selecting via prompt?
Would it be possible to show Sumifs Vba for more than 03 criteria or best Alternative for that. this is for Large Database like Debtors Statement where i would need to tally with collection.
Dear Thank you for great help, but VBA code not working with Turkish language characters such as I ğ ü ş ç ö. How can i fix that?
Power Query, just tweaking the M Code to replace multiple strings
Can work ? Find and replace multi word in multi file with multi sheet in a folder
Is it possible to insert a word in the middle of a sentence in Excel?
every solution is based on having "text" in one column , but how to substitute character from area of cells(more columns)?
By the way, your way of explaining is quite good ,and simple, and I like it. Just this I missed there.
for some reasons when i run macro it replaced everything including the exisiting database old text . can you please help
👏👏