How to use Excel formula to count the item and generate the 'LineNo'
column and the result look like the following:

LineNo Item Location
0 A101 L01
1 A101 L02
2 A101 L03
0 B100 L01
0 C111 L02
1 C111 L03
2 C111 L05
3 C111 L08


--
annsmjarm
------------------------------------------------------------------------
annsmjarm's Profile: http://www.excelforum.com/member.php...o&userid=13691
View this thread: http://www.excelforum.com/showthread...hreadid=467435