Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-25-2016, 02:02 AM
c991257 c991257 is offline Staff Attendance Calendar where text = values Windows 10 Staff Attendance Calendar where text = values Office 2016
Advanced Beginner
 
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default

Try typing ="S"="s" in a cell. If you do that you'll see that excel doesn't differentiate between a capital or a lower case S.

In the attached I made a simple table that adds up the different instances for you. That you can then manipulate.

It's often easier to break down the problem into steps and then solve each step on it's own. Later you'll learn how to solve the problems more efficiently in fewer steps.

/Møller
Attached Files
File Type: xlsx Attendance 2 (Recovered).xlsx (31.3 KB, 25 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Staff Attendance Calendar where text = values Creating watermark macro for 400 staff ryan1878 Word VBA 1 07-13-2016 02:45 AM
Staff Attendance Calendar where text = values Project as a Staff-tracking Tool Kerry Project 1 03-01-2012 02:46 PM
Automate Office Attendance kgwack Outlook 0 02-14-2012 09:39 AM
Calendar control accepts other values JeJ Word 0 03-02-2011 03:38 PM
Using MSP to predict staff resource jarvo273 Project 0 05-13-2010 04:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft