Pages

Monday, 13 August 2012

EXCEL: How to create running number for data with loopholes

Hello! change of content!
Today Im going to show you how to automatically create a series of running number/tracking number in excel. :)

(A)Usage:
1. create running number when only you type them list of items instead of pre-entering the number first then item.
2. if there is a hole between 2 data, it will still create running number for the cells that only have data and ignoring blank cell.

Let say you want to go for a shopping. and here are the items: