auto- sequence number based on another column?
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:
And it should be like this:
Name(A), Unique Seqno(B)
Looking forward to an answer.
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.
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
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
A collection of images can be viewed in any ordered sequence using manual/auto slide show script.
- 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.
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
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.
- 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
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
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.
Class based, for full customization
Auto Thumbnail generation, for quick page load.
Implement JQUERY prettyPhoto lightbox with ease
Add pagination to your image gallery
Add multiple folders to gallery
Define the number of images you want displayed.
Standards based gallery design
Full documentation for customization and installation.