Set value to odds or evens and then write inn another cell accordingly.

[Bartor]

Screenshot 2022-08-01 100937.png

In the picture you can see that there is a name, is it possible to check if the name appears inn odds or evens the check inn/out column is updated with Check In on an odd number and Check Out on an even number in VBA?

Right now I have typed it in manually to set an examle.



Thanks in advance

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Just FYI:

inn = hostelry, place where you might enjoy a beer by a roaring fire or even spend the night
in = preposition

[davsth]

Yes it is possible a sample as ALi says makes life easier

the count if function will count the occurrences of the value
countif(a$2:a2) will do this

isodd will return a true if this value is odd

if(isodd(countif(a$2:a2)), "check in", Check out") in cell c2

[Bartor]

Thanks, this helped out a lot I ended up with this: =IF(ISBLANK(A2),"",IF(ISODD(COUNTIF($A$2:B2,A2)),"Checked In","Checked Out"))

[davsth]

yes that was the final polish with the addition, =IF(A2="","",IF(ISODD(COUNTIF($A$2:B2,A2)),"Checked In","Checked Out"))

Would also work but the b2 references should be A2 as you will never find the name sin the next column, unless your data formatting isn't entirely consistent

If you are happy mark the thread as solved