Posted to microsoft.public.excel.misc

Fred Hill

external usenet poster

Posts: 2

Forumla required

I have a display as such

A B F G
FRED YES FRED
JIM JIM
FRED YES JANET
FRED
JANET YES
JIM

I need a formula to tell me in COL G how many times the names in COL F show
a YES in col B.
As you can see all the names in COL F are the unique names from Col A
For example in this case FRED should read 2 in Col G and JIM reading zero
and Janet reading 1

Thanks for the help

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
Need a forumla help	Igneshwara reddy[_2_]	Excel Worksheet Functions	3	November 26th 07 06:53 PM
if then forumla	Ann	Excel Worksheet Functions	2	June 26th 07 01:50 AM
Help with Forumla	WeSt39	Excel Worksheet Functions	2	March 20th 06 11:22 PM
IF Forumla help	Bryan	Excel Discussion (Misc queries)	3	February 28th 06 11:17 AM
Forumla Help	streetboarder	Excel Discussion (Misc queries)	12	January 27th 06 11:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us