LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

as Peo gave you

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ben Blair" wrote in message
...
I'm a bit confused. Let's suppose my data looks like this:
A B C
Math AA AD
Lit AA AC
Art AB AE

The results will be in a table like this:
code Math R Math W
AA x y
AB
AC

What exact formula belongs in x or y?





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Excel IF and COUNT functions Robin Faulkner Excel Worksheet Functions 2 February 18th 05 06:34 PM
Using Dates in Count functions HWade Excel Worksheet Functions 1 December 6th 04 10:25 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"