Need help to build excel formulas

Hello everyone,   I need help with to process some data.   Problem 1: As per mentioned below, Can you please show me formula used so that i can have result for example, "3" in I7 column (An...