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.

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