Need Help? Chat with us

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.

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

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.



Note: Match Juniour Formula hai, vo kbhi bhi Table Array nahi le sakta, vo Ek part of Column ya Row le sakta hai.

Previous Post

Learn 100+ Excel Tips & Tricks



“To be an Excel Superstar”

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

Download ebook