question

**A.S.** · August 3rd, 2006, 09:59 PM posted to microsoft.public.publisher

I am trying to create a formula so that from a list of say 2000 of which 1999
are "NO" and one will be a digit, what formula can I use so that this one is
selected out of all of them?

Example:
7
No
No
No
No
....
I want to create a formula so that all the cells are checked and it picks
the 7 because it is not a "NO".

Thanks.

**Mary Sauer** · August 3rd, 2006, 10:04 PM posted to microsoft.public.publisher

Might try an Excel newsgroup... Or Access

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/p...649111033.aspx

"A.S." wrote in message
...
I am trying to create a formula so that from a list of say 2000 of which 1999
are "NO" and one will be a digit, what formula can I use so that this one is
selected out of all of them?

Example:
7
No
No
No
No
...
I want to create a formula so that all the cells are checked and it picks
the 7 because it is not a "NO".

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot table question	gary	General Discussion	1	January 10th, 2006 06:25 PM
random sort my table	ADAM	Running & Setting Up Queries	5	December 30th, 2005 06:59 AM
Question about reducing number of tables in a database	tlyczko	Database Design	0	October 27th, 2005 04:15 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good	dazed and confuzzed	General Discussion	0	April 23rd, 2005 02:39 PM
database design question	e-mid	Database Design	9	June 16th, 2004 09:42 PM