Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Tue 9 Mar 2010, 14:36 Edited on Tue 30 Nov -0001, 00:00 Delegate Joan said...

Joan has attended:
Excel Intermediate course

Excel

I've got a list of project names running down one column, in another column I have numbers against each of these projects numbered from 1 to 87.
Some new rows have been added, in different places, so now I have numbers to put in against those new rows that have been inserted but. I don't want to repeat or use a number that already exists so how do I .. give those new rows a number without repeating one that already exists. I.e ? filtering showing all my numbered rows (in order) and then having, directly below it, the rows that have no numbers. Thus enabling me to continue the number ordering.

Thanks
Joan

Wed 10 Mar 2010, 15:37 Trainer Stephen said...

RE: Excel

Hi Joan

Thanks you for your question

One solution would be to run a MAX function on the entire column. This would give you the current highest number. You could then simply enter the number after that into the relvant row. The function would then return that number, and you could repeat the process for the next row

Hope this helps

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Use RANDBETWEEN to generate random numbers