it might have slipped your attention, but there is a dot after the pears! Just from reading, I did not use wildcards up to now
Hope it helped Eugen ----- Original Message ----- From: "Fred Grant" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, August 11, 2005 7:29 AM Subject: Re: [users] wildcard in formulas > On Tue, 2005-08-09 at 06:10, Nzman wrote: > > I am having trouble using the * in the criteria part of the countif > > formula. Typing in "pears.*" will not find pears1 for instance. I have a > > formula in an excel spread sheet > > =IF(OR((MONTH(A16)=MONTH(A15)),(A17="")),IF(WEEKDAY(A16)=$B$7,LOOKUP($B$7,$J $1:$J$7,$K$1:$K$7)&MOD((COUNTIF($C$14:C15,LOOKUP($B$7,$J$1:$J$7,$K$1:$K$7)&" ?")+$B$3-1),($B$2))+1,WEEKDAY(A16)),"BOM"&MOD((COUNTIF($C$14:C15,"BOM?")+$B$ 5-1),($B$4))+1) > > that works fine in excel and mostly works fine in OO except it dosent > > count my weekdays or oems because of the countif formula not working > > properly. In excel a ? in used instead of an *. When i change formula it > > makes no difference. I did a test on counting cells with pears in as > > follows. > > Making cell A1 = "pears" and using =countif(A1;"pears") will return a 1. > > Making cell A1 = "pears1" and using =countif(A1;"pears.*") will return a 0. > > How do I get the second line to work. > > > > John Meredith. > > > I seem to remember solving a similar problem to your "pears" example by > enabling regular expressions in calc. I don't think it will solve your > larger problem as the only strings I've had it count are at the > beginning of the cell, eg it wouldn't count "ripe pears". > > good luck > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
