You are here: HomeExcelTutorials

# auto- sequence number based on another column?

## auto- sequence number based on another column?

Price: FREE

my problem:
column A contains a unique ID # for a well, in other columns are events for that well. Multiple events occur for each well (multiple rows with same unique ID #)
now I need to put into column B, a sequential number counting each event for each well.
I know I did not describe this well so let me try to show
A B
how to auto-generate column B?

Visit publisher's web-site: auto- sequence number based on another column?

Category and Tags: ExcelTutorials :

## Related Tutorials

### Unique Sequence Number Based On The 1st Column

Free: Yes
Tags: Excel ›

I have a spreadsheet with in the first column names and I want to create an unique sequence number per record name , hope somebody can help with a macro.
So I have this:
Name(A)
2AA
2AA
BB
BB
BB
CC
DD
DD
DD
DD
And it should be like this:
Name(A), Unique Seqno(B)
2AA, 1
2AA, 2
BB, 1
BB, 2
BB, 3
CC, 1
DD, 1
DD, 2
DD, 3
DD, 4

### auto numbering rows based on changing values in another column

Free: Yes
Tags: Excel ›

I have a list of items for multiple people (territories). I would like an Excel formula that would restart a row numbering sequence every time the territory number changes. The simple spreadsheet attached illustrates the results I would like to obtain.

### [solved]Auto Sequence Date of of previous entry

Free: Yes
Tags: Excel ›

im developing a spreadsheet for end users that will assign the day of the week based off of the date and give feedback based on that. what im looking for is a way to foolproof the spreadsheet so they enter day 0, and excel will auto fill the dates after that to reduce chances of them screwing up (31 days in November, forgetting leap year, etc)
so my sheet looks like this:
a1 = 11/15/2011
a2 = 11/16/2011
a3 = 11/17/2011
what im looking for is a simple statement that will look at cell a3, and apply 11/18/2011 in a4. does something like this exist? non-vba preferred if possible

### auto sequence

Free: Yes
Tags: Excel › Functions

how to make a cell advance numerically

### Auto fill column with sequential numbers with decimals

Free: Yes
Tags: Excel ›

Want to auto fill as follows: 3, 3.1, 3.2, 3.3, 3.4
What method works? Can only seem to get sequence on primary number, example:
I want the number to the right of the decimal to change.

## Related Applications & Scripts

### Manual Slideshow

Free: No
Tags: JavaScript › Excel Slide Shows

A collection of images can be viewed in any ordered sequence using manual/auto slide show script.
Features:
- You can switch to any slide using the manual slider options provided.
- You can also set the size and duration of the image show.
- It supports JPEG, TIFF, BMP and PNG formats.
- Try the manual slide show given below.

### No-nonsense sequencer

Free: No
Tags: Flash › Excel Image Galleries

Tired of getting complicated banner rotators and image sequence items implemented properly in your works?
No-nonsense sequencer is a very basic image/swf rotator. It generates a number of pictures or SWF files in sequence, fading in and out. It's bare bone default setup will work in any template, file or website. Simple as that.
All you need to adjust if you want in the XML file is the time to fade in, time to fade out, the path to where the images/swf folders are, and the size of your canvas.
But if you need a few simple extras, you can add a few basic masking transitions, basic reveal movements and ken burns effect, to each item in the sequence individually

### BANNER ROTATOR with Auto Delay Time

Free: No
Tags: Flash › Excel Banner Rotation

This is an XML banner rotator with automatic delay time depending on the number of words used in caption. There are more features, around 35 settings parameters available in the xml file.
Features:
- Can load JPEG , PNG, GIF images and SWF files
- Resizable to any extent
- Auto Time delay according to number of words (length of caption)
- Fixed time delay also can be added
- 5 Different Transition Effects

### XML Based BannerRotator

Free: No
Tags: Flash › Excel Banner Rotation

Flash version: 9, ActionScript 3.0. A simple Banner Rotator based on xml files
* auto resize images
* timer for every image
* pause timer
* auto rotate images
* well commented source
* drag and drop
* xml configuration file
* TweenLite engine used

### Auto Image Gallery Class

Free: No
Tags: PHP › Excel Image Galleries

Simple Gallery is a class based auto image gallery creator. The idea for this is to allow the user to instantly insert a photo gallery into their site with absolute ease. The goal for this class is to make it easy for any one to achieve an attractive image gallery with out having to know PHP or tediously setting up the gallery by hand coding html . Simple gallery works by taking a folder of images, you supply, and based off that folder a gallery will be created for you. All you have to do is select the options you want, insert two lines of code and style your gallery with css. Its that simple! All the code has been written for you and simple gallery comes pre-built with prettyPhoto, a JQUERY photo lightbox. Theres no need for a mySQL database or an admin panel, just input your folder location on your server and your good-to-go.
Features:
Class based, for full customization
Auto Thumbnail generation, for quick page load.
Implement JQUERY prettyPhoto lightbox with ease