Posted to microsoft.public.excel.programming

p45cal[_167_] p45cal[_167_] is offline

external usenet poster

Posts: 1

matching cells

=if(and(a1=a2,a2=a3),4,0)

or a la Rick:
=4*(AND(A1=A2,A2=A3))

no, I got that wrong:
=4*(A1=A2)*(A3=A3)

--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146902

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Matching cells	saman110 via OfficeKB.com	Excel Discussion (Misc queries)	0	March 12th 08 09:06 PM
display a range of cells editible cells based on matching date	Miki	Excel Worksheet Functions	0	October 10th 07 03:27 PM
Matching cells	gary	Excel Programming	4	October 8th 07 10:47 PM
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side	[email protected]	Excel Discussion (Misc queries)	2	June 11th 07 02:38 PM
Matching cells	[email protected]	Excel Discussion (Misc queries)	0	July 1st 05 02:43 PM

All times are GMT +1. The time now is 05:40 AM.

About Us

"It's about Microsoft Excel"