Відео

How to delete left text

Excellent Information. Thanks

Hi Master, there a way to do that with two criteria? Like Search the name and Date? Two itens

Thanks, Brother From Bangladesh

It's wow trick

Hi Ajay are you giving any training session on excel? If yes please teach me I'm looking for a mentor who can help me to reach my vision in corporate sector.

good morning ur video teach me many things thank you very much

hello this sajja from Uganda I have liked ur video

Excellent teaching Sir thanks 🇵🇰

This is just an amazing with a clear crystal process flow.. God bless and thanks a ton for such wonderful video.

Very good 👍

Thank you

Thank you so much ....

Thank you so much 😮❤❤

the symbol appears but i cant click on it

How can we find 18 year age date from the birth date

You are making too complicated

I love this thank you ❤

Thank you

hi @ajayAnandXLnCAD .. I Tried ,but the problem is the number start with 0. I converted the value into text but it didn't work>>>>> can you help

Thanks

Hi after typing formula in whatsapp message box I m getting #VALUE! in that cell Please help

How do we do that in outlook

Good to understand, its easy.

Hi sir I am maths teacher I had created the marksheet of students only maths subject where I had taken multiple test but everytime whenever I want to make that I have to search the students name first then in next column I write there marks So my question is'' is there an any formula where I write there name and there marks so it's automatically add in column?"

Great, Thanks

Apps Script Code for sending Birthday Wishes function sendBirthdayWishes() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var data = dataRange.getValues(); var today = new Date(); var todayDayMonth = today.getDate() + "-" + (today.getMonth() + 1); for (var i = 1; i < data.length; i++) { if (data[i][0] === '') { continue; // Skip empty rows } var name = data[i][1]; // Adjust column index based on your sheet var dobCell = data[i][2]; // Date of Birth column var dob; if (typeof dobCell === 'object' && dobCell instanceof Date) { dob = dobCell.getDate() + "-" + (dobCell.getMonth() + 1); // Format DD-MM } else if (typeof dobCell === 'string' && dobCell !== '') { var dobParts = dobCell.split("/"); dob = dobParts[0] + "-" + dobParts[1]; // Format DD-MM } else { continue; // Skip rows with invalid or empty Date of Birth } if (dob === todayDayMonth) { var email = data[i][3]; // Email column var subject = "Happy Birthday " + name + "!"; var message = "Dear " + name + ", Wishing you a very Happy Birthday! Have a fantastic day! Best Regards, Ajay Anand"; MailApp.sendEmail(email, subject, message); } } }

Bro here shows value...not generated to link

very nice explanation, really appreciated

I could hug you right now!!!! Omg!! You saved my life. i have been struggling. Thank you.

Makes sense, really love that😂❤

Awesome, Thank you Bro

Really nice

Thank u Sir , amazing videos ❤

thank you for such simple and understandable explanation

Really really appreciate your effort. This is superb. Is there any way to connect their attendance ledger of the month along with payslip ...? Please make a video on it as well

I'm not able to do . I is showing that whats app web is external site and blocking me. Plz help.

I don't know what is this and why all are saying thanks?

Very useful, sir. Can't thank you enough.

Just fantastic

This is wonderful and very creative. But is it possible to change to date instead of the names?

Can u please share any full project for data visualisation with excel , sql

Hi Ajay I have a group of Golfers 28 to 36 max in an Excel sheet I would like to have every week each player from the foursome cannot meet any one that he already played with for nine consecutive weeks wondering if it is easy way thanks

How to get text in formula cells.. please help

Thank you very much

Hi Ajay, I have followed your steps, however I have an error where it stated that 'Do without Loop' which I think it told me that I did not put loop word Could you please advise how I can fix this? Thank You and appreciate your response

if update field inactive what i do

Very very clever, fabulous

Wait... Why false?