[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel 2010  autofill, reset fill value based on data in a different column

Posted on 2012-08-16
2
Medium Priority
?
517 Views
Last Modified: 2012-08-16
I have a spreadsheet that I want to autofill the column called Seq (below) with 10,20,30 but I want to reset to 10 based on a different Part ID.  Is this possible?

Part ID                                        Seq      Req
CN235-1008200-1000-0      10      CN365-1007600-1000-1
CN235-1008200-1000-0      20      CN365-1007700-3000-1
CN235-1008200-3000-0      10      CN365-1007600-3000-1
CN235-1008200-3000-0      20      CN365-1007700-3000-1
CN235-1008201-1000-0      10      CN365-1007601-1000-1
CN235-1008201-1000-0      20      CN365-1007701-1000-1
CN235-1008201-3000-0      10      CN365-1007601-3000-1
CN235-1008201-3000-0      20      CN365-1007701-3000-1
CN235-1008201-3000-0      30      CN365-1007801-3000-1
CN235-1008202-1000-0      10      CN365-1007602-1000-1
CN235-1008202-1000-0      20      CN365-1007702-1000-1

Thank you in advance
0
Comment
Question by:BFanguy
2 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 2000 total points
ID: 38301948
not with autofill, but you can use a formula and drag it down.
=countif($a2:a2,a2)*10
0
 

Author Closing Comment

by:BFanguy
ID: 38302043
Thanks,  I had to tweak it just a bit...   =COUNTIF($A$1:A1,A1)*10
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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 use longer labels with horizontal bar charts instead of the vertical column chart.

873 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