The SUPER Fast way to use the Match function to count position number in Excel

Learn: SUPER Fast way to use the Match function to count position number in Excel

Iss baar mera motive hai ki, mai aapko Match Formula k basics k baare mai batau:

Ek(1) baar basics clear hoga, fir mai aapko batauga Formula ki khubiya

Generally, Vlookup aur Index k Formula mai aap behtarin tarike se usme milakar istamaal kar sakte hai.

Toh chaliye dosto, dekhte hai ek chota sa Experiment:

Experiment 1:

Agar mai aapko puchu, Cost kaha betha hai? 1/2/3 Position par?

  • Cost → 3rd Position
  • Sales → 2nd Position

Aur mai chahta hu ki Answer⇑ bhi vahi aaye.

Abb mai jo Formula batane wala hu, vo humare form mai likhne ki puri style badal dega:

  1. Type ⇒ {=MATCH(}
  2. Lookup Value → Select Cost ⇒ {=MATCH(B5,}
  3. Lookup Array(Jr. Table Array) → Select Blue Cells ⇒ {=MATCH(B5,B7:D7,}
  4. MAtch Type → Exact Match/0 ⇒ {=MATCH(B5,B7:D7,0)}
  5. Press ENTER↵

Waah bhaiya!, Answer aagya Cost=3.

Jab Match par aapka grip aaye, tab mai aapko batauga ki,

Vlookup aur Match ki jugalbandi aapko banayegi Excel Superstar.

Experiment 2:

Mujhe jaana hai ki, Grey colour Cell k andar Black ki Position kya hai?

Agar mai aapko puchu Black konse position par hai?

Black5th 6thPosition par hai(aapko ek ek Cell gin na hoga)

Toh chaliye dosto, mai aapko batata hu Answer kaise aayega:

  1. Type ⇒ {=MATCH(}
  2. Lookup Value → Select Black ⇒ {=MATCH(B10,}
  3. Lookup Array → Select Data Portion ⇒ {=MATCH(B10,B12,B17,}
  4. Match Type → Exact Match/0 ⇒ {=MATCH(B10,B12:B17,0)}
  5. Press ENTER↵

Waah bhaiya, Answer aagaya Black=6.

Note: Agar aap Spelling wrong likhege, toh dosto Answer nahi aayega.

Ye Formula ek simple kaam karta hai:

  • Ye ginta(count) hai Position Numbers
  • Uppar(Up↑) se Niche(Down↓) Numbers
  • Left← to Right→ Numbers

Ek baar Basic Practice jarur kijiyega.

Mai aapko le chaluga ki, kiss tarah ye aapko help karta hai:

  • Vlookup ko aur takatvar banane mai
  • Index Formula ko aur bhi takatvar banane mai

Toh Dosto:

Next Post

Advanced Excel Webinar v3.0

2000+ Participants, different sessions, expertise training, Join Now for the Webinar. Learn Advanced Excel and Enhance your knowledge for better JOB (on 26th Jan 2018)