I created a subtotal by count of "Vendor Names" for each "General Item" and the result is displayed as a number (in this case the number of times the Vendor Name is repeated). My question is this, is there any way for me to convert this number into the name that Excel subtotaled from this column? Or, how can I convert the number into text. I created a (=CELL) function which worked, but I now have to go subtotal line by subtotal line and paste the function into that line for it work. Any suggestions?

Thanks
Tom