Excel Auto Attendance sheet

214 Views Asked by At

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

enter image description here

1

There are 1 best solutions below

1
On

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