Solved

first & last Row Formula

Posted on 2014-03-13
3
371 Views
Last Modified: 2014-03-13
Hello ,
What is the very good formula to find the first and last occurrence row for the word “Area”? Please see the attached. I am looking for a vba but a direct cell formula
first-last-occurence.xlsx
0
Comment
Question by:Rayne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:Rayne
ID: 39928012
but a direct cell formula for cell C2 and C3
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39928016
For the first row:

=MATCH("Area",$E$1:$E$105,0)

and for the last row, the following as an array formula (entered with Ctrl+Shift+Enter)

=MAX(IF($E$1:$E$105="Area",ROW($E$1:$E$105),0))
0
 

Author Comment

by:Rayne
ID: 39928044
thank you :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question