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.

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


Fatal error: Uncaught Error: Call to undefined function setPostViews() in /home/yodalear/public_html/excelsuperstar.org/wp-content/themes/consulting-PURCHASHED/single.php:10 Stack trace: #0 /home/yodalear/public_html/excelsuperstar.org/wp-includes/template-loader.php(106): include() #1 /home/yodalear/public_html/excelsuperstar.org/wp-blog-header.php(19): require_once('/home/yodalear/...') #2 /home/yodalear/public_html/excelsuperstar.org/index.php(17): require('/home/yodalear/...') #3 {main} thrown in /home/yodalear/public_html/excelsuperstar.org/wp-content/themes/consulting-PURCHASHED/single.php on line 10