• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

first & last Row Formula

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
  • 2
1 Solution
RayneAuthor Commented:
but a direct cell formula for cell C2 and C3
For the first row:


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

RayneAuthor Commented:
thank you :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now