# Use the Match Function to Count Position Number in Excel

## Learn: The Match Function to Count Position Number in Excel

Iss Video mai hum continue karege, Match Formula k basics k baare mai, dusre(2nd) Example k sath.

So Friends, mere pass ek list hai jissme:

• 417 = Naam hai.

Iss list mai koi bhi naam repeat nahi ho raha hai.

Agar aapko jaana hai, Dublicate kaise Find kare ya hataye? → Refer

Filhal mene jo 2 Naam yaha par rakhe hai:

1. Williams, Dennis A.
2. Brown, Johari C

Ye↑ Naam list mai konse Position par hai?

Toh Chaliye dosto, dekhte hai Match Formula k zariye:

1. Type ⇒ {=MATCH(}
2. Lookup Value → Select Williams, Dennis A. ⇒ {=MATCH(F6,}
1. Note: Spelling vahi honi chaiye jo aapke list mai hai.
3. Lookup Array → Select Pehla(1st) Naam → Shift+Ctrl+⇓ ⇒ {=MATCH(F6,C4:C420}
4. Press F4 ⇒ {=MATCH(F6,\$C\$4:\$C\$420,} (Ye table kbhi niche giske nahi)
5. Match type → 0(Exact Match) ⇒ {=MATCH(F6,\$C\$4:\$C\$420,0)}
6. Press ENTER↵
7. Copy Same Formula → Brown, Johari C

#### Waah bhaiya!, Answer aagya dono ka:

• Williams, Dennis A.= 400 Serial No. par hai
• Brown, Johari C = 39 Serial No.par hai

Match Formula aapko batayega Position, Vertically ya toh Horizontally.

Previous Post