Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 7

understanding what part of a formula represents

I have numbers in column F and I want to see if they are duplicated anywhere
in column B. I was given a formula that seems to work but I do not
understand part of the formula. The part I want to know what is represents
is =1
The formula is as follows:
=IF(COUNTIF($F$2:$F$20),B2)=1,"remains on report","fell off report")
What does greater then or equal to 1 mean?
--
mrs luke

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
Understanding formula	Dig	Excel Worksheet Functions	1	July 3rd 08 03:31 PM
Taking out string part which represents date	c8tz	Excel Worksheet Functions	8	February 2nd 07 01:08 PM
Understanding a formula	Jordan	Excel Worksheet Functions	1	May 27th 05 05:42 AM
Understanding a formula	Jordan	Excel Worksheet Functions	6	May 26th 05 09:14 PM
Understanding this formula	Sal	Excel Worksheet Functions	4	March 26th 05 06:32 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us