excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel

resolvedResolved · High Priority · Version 2003

Edited on Mon 30 Nov -0001, 00:00

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

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


 

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips


Server loaded in 0.09 secs.