98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
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. |