im trying to make an automatic attendance sheet here are the details: -Data will be imported in the excel sheet (left side) -I want to automatically mark "p" or "a" a specific cell based on the data imported
Excel Auto Attendance sheet
214 Views Asked by Jester Magdaraog At
1
There are 1 best solutions below
Related Questions in EXCEL
- Is my UnloadContent method acceptable?
- Remove items from screen on rectangle click
- OutOfRangeException error when the array has items in it?
- How do I scale the graphics of a game?
- How do I apply multiple matrices in spriteBatch.Draw()?
- C# XNA Collision Detection with list of objects
- Playing a wav file from a MemoryStream windows phone 8.1
- Error loading textures in monogame as non content files
- Shading in XNA Game Studio
- Creating an update method with custom rate processing in c++
Related Questions in WINDOWS
- Is my UnloadContent method acceptable?
- Remove items from screen on rectangle click
- OutOfRangeException error when the array has items in it?
- How do I scale the graphics of a game?
- How do I apply multiple matrices in spriteBatch.Draw()?
- C# XNA Collision Detection with list of objects
- Playing a wav file from a MemoryStream windows phone 8.1
- Error loading textures in monogame as non content files
- Shading in XNA Game Studio
- Creating an update method with custom rate processing in c++
Related Questions in FORMS
- Is my UnloadContent method acceptable?
- Remove items from screen on rectangle click
- OutOfRangeException error when the array has items in it?
- How do I scale the graphics of a game?
- How do I apply multiple matrices in spriteBatch.Draw()?
- C# XNA Collision Detection with list of objects
- Playing a wav file from a MemoryStream windows phone 8.1
- Error loading textures in monogame as non content files
- Shading in XNA Game Studio
- Creating an update method with custom rate processing in c++
Related Questions in COMMAND
- Is my UnloadContent method acceptable?
- Remove items from screen on rectangle click
- OutOfRangeException error when the array has items in it?
- How do I scale the graphics of a game?
- How do I apply multiple matrices in spriteBatch.Draw()?
- C# XNA Collision Detection with list of objects
- Playing a wav file from a MemoryStream windows phone 8.1
- Error loading textures in monogame as non content files
- Shading in XNA Game Studio
- Creating an update method with custom rate processing in c++
Related Questions in TIME-AND-ATTENDANCE
- Is my UnloadContent method acceptable?
- Remove items from screen on rectangle click
- OutOfRangeException error when the array has items in it?
- How do I scale the graphics of a game?
- How do I apply multiple matrices in spriteBatch.Draw()?
- C# XNA Collision Detection with list of objects
- Playing a wav file from a MemoryStream windows phone 8.1
- Error loading textures in monogame as non content files
- Shading in XNA Game Studio
- Creating an update method with custom rate processing in c++
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
since you're trying to check several conditions at the same time (date, time, id) in your source data I'd recommend normalizing the time to the start of the hour,
START OF HOUR FUNCTION
then adding a unique value for each you could concatenate "DATE", "TIME", "ID" with some type of separator for example "-"
CONCAT FUNCTION
and then you could try with using a lookup function to look for that specific value,
LOOKUP FUNCTION
with an IF function so that if the value is returned you print p or if false print a.
IF FUNCTION