#16

Posted to microsoft.public.excel.misc

Herbert Seidenberg Herbert Seidenberg is offline

external usenet poster

Posts: 1,180

Combining formulas, "and" & "or" to verify content of multiple

Or combining the insight of Ron and Leo:
=SUMPRODUCT(OR(A1=K1:K6)*OR(A2=K1:K6))

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
How to transpose formulas from column content to row content.	Notrom	Excel Worksheet Functions	1	October 12th 06 06:57 PM
Combining formulas	jezzica85	Excel Discussion (Misc queries)	5	March 3rd 06 06:56 AM
lookup cell content in multiple files	oldbuffer	Excel Worksheet Functions	0	September 13th 05 06:37 PM
How to create Multiple Conditional Formulas in a single cell?	Maxfx	Excel Discussion (Misc queries)	2	February 1st 05 02:26 PM
Multiple formulas including INDIRECT	Gizmo	Excel Worksheet Functions	4	December 21st 04 07:07 PM

All times are GMT +1. The time now is 12:09 PM.

About Us

"It's about Microsoft Excel"