I want it to count and fill in a range in column A until it sees a blank or notices the change in value in column B. In the example below i hope it shows what i need to do. i left the last group without numbers to show that is where it needs to start counting over again. i am basically wanting to count down 1st place 2nd place etc.... in divisions i designate for tournaments i manage. thanks for your time.
Please Login or Register to view this content.
Last edited by Traymond; 06-10-2009 at 02:55 AM.
Manually, you could do this with a formula. In A1, put 1. In B1 and copied all the way down, put this:
=IF(B2="","",N(A1)+1)
Now, if row1 actually has column titles, you could just use that same formula from first row of data all the way down, don't need to enter the 1 to start it.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
...and the same approach built into a macro:
Please Login or Register to view this content.
I can be dumber than a bag of rocks sometimes. i attached a sample file. could you fill that in so i can see how to do it. i guess i am confused.
thanks
Jbeaucaire... i tried the manual code but it is not adding the plus one. it puts all ones in. it does skip the blanks. any suggestions
Please Login or Register to view this content.
never mind ..... i figured out what i was doing wrong. thanks so much for the help. you have always given me the right answer or solutions. i hope to pass on what i am learning from you experts.
Your workbook doesn't match the sample chart you posted, you shifted everything over by one column and I imagine you didn't adjust anything in the formula
Put this in B7 and copy down:
=IF(C7="","",N(B6)+1)
Or use the adjusted macro (based on your sample sheet):
Please Login or Register to view this content.
Perfect !!!!!!! dang i wish i had your knowledge.
The more I use Excel, the more I realize I have so much to learn. It's a monster.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks