20MAR2024.png
Hopefully my picture makes sense.
20MAR2024.png
Hopefully my picture makes sense.
Try:
=IF(AT2:AZ10="","x",AT2:AZ10)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
um... i think you forgot the most important thing as mentioned in the picture. It is underlined and bolded. The outcome of what i want is different from what you gave. (As seen in picture)
Not really clear to me though.
This is how I guess.
You need to insert a space between day and month in AO9 like attached.
26Mar to 27 Mar 2024
Please Login or Register to view this content.
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks