Posted to microsoft.public.excel.misc

KellTainer

Posts: n/a

Count() question

Assuming your numbers are from A1 to A10.

in B1, =COUNTIF($A$1:$A$10,A1)

Drag down till B10.

--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=549290

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
Count and Count if funtions	Debi	Excel Worksheet Functions	3	September 27th 05 08:41 PM
Count Question	inkpassion	Excel Discussion (Misc queries)	1	September 13th 05 12:05 AM
complex count question	JBoulton	Excel Worksheet Functions	13	March 24th 05 02:57 AM
Pivot Tables - "simple" question	Eoin Bairead	Excel Discussion (Misc queries)	1	February 28th 05 07:07 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM

All times are GMT +1. The time now is 01:30 AM.

About Us

"It's about Microsoft Excel"