Search results

Hi Hui, Congratulations on the Excel MVP recognition! A well deserved recognition! -Sajan.

Hi, Is there a consolidated view that displays the messages from all of the forums? (For example, is there a view that displays messages from "Ask a question", "Excel Challenges" and "Lounge"?

Challenge Name -- Count the number of times a numeric 2-d array occurs in another 2-d array Challenge Description -- This is a formula challenge. As such, only formula submissions are accepted. -- For two lists named "nList" and "sList", count the number of times "sList" appears in "nList"...

Challenge Name -- Count the number of times a sublist occurs in a list Challenge Description -- This is a formula challenge. As such, only formula submissions are accepted. -- For two lists named "List" and "Sublist", count the number of times "Sublist" appears in "List". -- "List" and...

Challenge Name -- Calculate the number of unique characters that are common to two strings Challenge Description -- This is a formula challenge. As such, only formula submissions are accepted. -- For two given strings (that may contain any number of characters -- alphabets, numbers...

Challenge Name -- Calculate the cumulative sum for a range of data, while meeting some conditions Challenge Description -- This is a formula challenge. As such, only formula submissions are accepted. -- If the cumulative sum equals or exceeds the threshold, then the output = sum of all...

Hi, It has been almost a year since I joined this forum. I wanted to take a moment to thank all of you for giving your expertise so generously, and asking some great questions. I still remember vividly my first post and quick responses from Luke, Narayan and Haseeb. Having never posted...

Hi All, I recently started reading some of the older posts in the forum since I am a relatively new member here. As one would expect, there are quite a few Excel gems among the posts. That got me wondering if there would be any interest in creating a compendium of the Chadoo.Org forum posts...

Hi, Is there a quick menu link to view the Formula Forensics posts? thanks, Sajan.

Hi, I like the new mobile-friendly view (now on the blog site). I hope to see it extended to the main forum site also. Regards, Sajan.

Hi, I love the clever and creative solutions proposed for various problems / questions. However, sometimes I miss the actual solution because it is described in file attachments / links in posts. Would it be possible to include the solutions proposed in the post itself, even if it is...

Hi, Could anyone provide any pointers for creating dynamic charts with non-contiguous data? My data setup is similar to the following: A B A B A B A B A B Jan-12 Jan-12 Feb-12 Feb-12 Mar-12 Mar-12 Apr-12 Apr-12 May-12 May-12 1 10 2 20 3 30 4 40 5 50 i.e. the header row is row 1 the date row...

Hi, Does anyone have any sample Excel VBA code that shows how to use the Sharepoint Web Services? I did find some cryptic examples elsewhere, but before I embarked on interpreting what I found into VBA, I was hoping that someone may have translated it to VBA already! I am specifically...

Hi, I am attempting to find a way to identify the maximum value in an array that contains one or more rows. My sample dataset is as follows: 0,1,2,0;1,2,0,0;0,0,0,3;0,4,5,0;0,0,0,0 Just for illustration, the above dataset can be represented in rows as follows: A B C D 0 1 2 0 1...

Hi, I have the following dataset (simplified to illustrate my question): # A B C D E 1 Item 1 1 2 Item 2 2 Item 2 Q 4 Item 4 3 Item 3 5 6 4 Item 4 7 8 Column A has a list of text values (Item 1, Item 2, etc.) Column B and C has the mostly numeric values that I...