leonardtan
Member
Hi Excel Experts,
I am trying to track my card swiped data with time stamp but every time when i try to insert a new data all the time stamp in the column updates to the most recent time.
What formula should i use.
I am using the following
=IF(C8="","",IF(B8="",NOW(),B8))
Another condition required is, if the member id, under column D is reflected for more than 3 times it will prompt an error message "Keep a look out for guest"
I am trying to track my card swiped data with time stamp but every time when i try to insert a new data all the time stamp in the column updates to the most recent time.
What formula should i use.
I am using the following
=IF(C8="","",IF(B8="",NOW(),B8))
Another condition required is, if the member id, under column D is reflected for more than 3 times it will prompt an error message "Keep a look out for guest"