COUNTIF copy and pastevalue COUNTIF function can be used when calculating how many same date is exists or checking same data is no duplicated. However, this function makes your computer slow because it re-calculates every time the sheet is…

Making Janken Game (Rock Paper Scissors game). This would be good exercise for VBA beginners. Macros will be introduced in this article. It shouldn't be difficult. I hope this helps your study.