I have a set of 150k devices where I need to display the last person and date/time they logged onto that device. I know I can use data filters to create a column of unique SNs, and I can use MAX to find the last login date, but I have some blanks and I would like to exclude those unless there is no other user data. (For example, the last login for SN1 was blank, but yesterday a person logged in, so I want to capture yesterday's person. On the other hand, SN4 shows only blanks, so I would like it to say something like "No user info available" for those.) I know I can do an IF statement for that part, but cannot figure out how to combine if last login is blank, then go to the next one with a user, and if they are all blank, show "no info avail".
Bookmarks