I've been given a report that shows which days of the week someone has a recurring appointment. The sender uses N or Y for the 7 days.
In column be of attached I'm looking for a formula that will tell me which days are Y. MWF ; TT; etc.
Thank for any assistance.
Jim
I think there is a more elegant way of doing this, but give this a try:
Formula:
Please Login or Register to view this content.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Please Login or Register to view this content.
Ben Van Johnson
I like the fact that there are no helper columns!
Thank you - it works great for my purposes.
Very much appreciated
Jim
Yep. It seems I'm not a big fan of KISSOriginally Posted by protonLeah
Please Login or Register to view this content.
Very smooth Ben
Thank you!
Just use a IF and more
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I see I was too late
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks