LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Creating Nested Functions

I really need some help to write a formula with nested functions.

How do I write a formula to calculate how many times a specific combination
of values appear in two different columns.

i.e. column A is populated with the values 1,2 and 3 in random order;
column B is populated with values a,b and c, also in random order. What
would the formula be to determine the number of times that the combination of
1 and a appear side by side on the same row; over a worksheet with 10 rows.

Thanks for any help in advance.
 
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
Database functions should use criteria in formula, as 1-2-3 does 123user Excel Worksheet Functions 8 September 29th 05 08:57 PM
creating new functions Peter R Knight Excel Worksheet Functions 3 September 19th 05 02:03 PM
creating a excel spread sheet using ffinancial functions slide show Excel Worksheet Functions 1 September 8th 05 08:46 PM
Creating a nested COUNTIF???? Simon Lloyd Excel Worksheet Functions 8 September 7th 05 02:30 AM
Too many nested functions F6Hawk Excel Worksheet Functions 4 November 9th 04 04:38 AM


All times are GMT +1. The time now is 01:45 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"