counting a piece of a text string
Posted by jason on October 05, 1999 1:59 PM
i have an excel column that has a string of information about cds. if the cd is recorded live, if it is part of a 2 cd set, etc. sometimes it is more than one, and i type both into the box. is there a way to go through and count all the cells that contain the text string "live" if it isn't the only thing in the cell and return a total?
Thanks,
Jason