Disclaimer: haven't used Excel for about ten years, haven't ever used OpenOffice.
About two minutes with the paperclip in Excel led me to the COUNTIF function, but it sadly doesn't seem to do substring searches, and I can't work out how I'd make it do that. Certainly no obvious command, I guess you'd use an IF as the criteria to the COUNTIF, with a text search for your search string as the inner conditional. Openoffice also has a COUNTIF, but it supports regular expressions. However, the help was no good at telling me the basic syntax to enter formula, so I gave up after about five minutes.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
baggyeyes
(no subject)
Date: 2005-07-14 12:02 pm (UTC)About two minutes with the paperclip in Excel led me to the COUNTIF function, but it sadly doesn't seem to do substring searches, and I can't work out how I'd make it do that. Certainly no obvious command, I guess you'd use an IF as the criteria to the COUNTIF, with a text search for your search string as the inner conditional.
Openoffice also has a COUNTIF, but it supports regular expressions. However, the help was no good at telling me the basic syntax to enter formula, so I gave up after about five minutes.