I have a very large spreadsheet for work.
I have 100's of items in one column that that i have isolated with a filter.
I want those items sequentially numbered in another column.
I have included, a totally simple example.......in the example if I filter out chips in column D, I am unable to drag and fill numbers in column B for fish...
(imagine the fish and chip column going on for about 1000 entries)
is there a way around this?
Attachment 354433

have searched this and seen countif and other formulas to fix this, but I am afraid I haven't understood them....
I am using excel 2013
thanks a bunch
Dave