Anthony's VBA Forum
Where the knowledge is shared
Menu
Home Page
Forum Index
FAQ
Memberlist
Usergroups
Register
Profile
Messages
Login/Out
Quick Search
Advanced Search
Links
Consulting
Products
Who's Online
[
Administrator
]
[
Moderator
]
Having Excel return Row Numbers
Anthony's VBA Forum Index
->
General Excel VBA
View previous topic
::
View next topic
Author
Message
BobM
Joined: 07 Apr 2009
Posts: 1
Posted: Tue Apr 07, 2009 4:06 pm
Post subject: Having Excel return Row Numbers
What if I have blocks of data in one column and I want Excel to return the row number when it finds a new number?
Example…
Industry Value (Header Row)
2300
2300
2300
2300
5200
5200
5200
So, I would want it to return the row number for the first 2300 and the first 5200, and so on.
Thanks for ANY help on this!!
Back to top
Kenneth Hobson
Gold Member
Joined: 25 Mar 2007
Posts: 21
Location: Tecumseh, OK
Posted: Fri Apr 24, 2009 11:00 am
Post subject:
In B2, copy down:
=IF(A1<>A2),A2,"")
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Anthony's VBA Forum Index
->
General Excel VBA
All times are GMT - 4 Hours
Page
1
of
1
Jump to:
Select a forum
Excel VBA
----------------
General Excel VBA
VBA on Finance and Investment
----------------
Option Pricing Models
Portfoilio Optimization
Other Finance Topics
VBA on Statistics
----------------
Probability Distributions
Monte Carlo Simulation
Regression Analysis
Announcement
----------------
Updated News
You
cannot
post new topics in this forum
You
cannot
reply to topics in this forum
You
cannot
edit your posts in this forum
You
cannot
delete your posts in this forum
You
cannot
vote in polls in this forum
Powered by
phpBB
© 2001, 2002 phpBB Group