array equations

Hi all, I have created a unique list of countries using a example from this link How to extract a unique distinct list from a column in excel | Get Digital Help - Microsoft Excel resource This is my formula array: {=INDEX(Countries, MATCH(0, COUNTIF($K$1:K1, Countries), 0))} where Countries...

I'm trying to figure out how to select two values from a drop down list and then to to a table on another tab to pull out a sub value. I have SIZE as a drop down (pulling from a named range) I have COLOR as a drop down (pulling from a named range of parent colors, which have child colors)...

Hi all - I have just discovered array formulas which appear to answer an averaging issue I have. One question though can I add to an array average formula an initial test to check if all the fields are zero. For example, the array formula I wrote that works is...

I have a sheet with names and options and I need to create a receipt of each person based on their choices However I do not want to print out blank choices as there are over 300 of these and each name may choose between 1 or more. Usually no more than 6 but i need to take into account the guy...

I need some help with this. I have a massive amount of data, broken down in columns. Each column contains a different set of values, pertaining to a single text value in another column. For example: Column A (going downward): A, A, A, A, A, A, A, B, B, B, C, C, C, C, C, etc. Column B (going...

Hi all: Thanks in advance for your help. I have the following issue: I'm trying to search for string "Intel" in an array A1:A100 However, in the array, "Intel" doesn't always appear as "Intel", sometimes it's "abcIntel" or "Intelproject1" or " Intel xyz" I've used the address function and...

I am drafting a score card to track on-time completion for four tasks within a standard process. My Excel sheet currently has the following information: Column A: Period completed (we are on a 12-period calendar) Column B: Date due Task 1 Column C: Date completed Task 1 Column D: Date due Task...