unique columns

Hi Everyone, I have an issue with a formula and I have been told we have all the experts in the world to answer to this question. I am trying to get a list of unique values for 2 non-adjacent columns. I have tried the formula below but it doesn't work. It only spills the result for one single...

I have the following code. the current macro generate separate workbooks based on unique values of a column of only one sheet. but i want it to do traverse across all the sheets and consolidate it. for ex: if the record "India" is present on all the sheets, the workbook "India" should have all...

All, I have searched and search and not found what I am looking for. But I khow there has to be an answer. I am routinely comparing two lists "Original" vs "New". I worte an VBA macro to apply column headers, make named ranges from the ranges, and then use conditional formatting to color the...

Hi, I have a table with one column containing a lot of duplicates: 'Gantt Chart'!$A$8:$A$1000 I want to create a unique column in another sheet which I have done with: =INDEX('Gantt Chart'!$A$8:$A$1000,MATCH(0,COUNTIF($AI$14:AI14,'Gantt Chart'!$A$8:$A$1000),0)) The issue I am having is...

Hello, I'm trying to make a drop down list that shows only items in column A that have > 0 value in column B. For example, my column A has items A, B, C, D, E, F with values in column B as 0, 22, 20, 50, 0, and 50. I want to have a drop down list (Data Validation list) that would only show B, C...

Imagine 3 fields:userid, event, event context. These fields define the record. A 4th field is the "super context" and requires excel abilities beyond my own. The array is sorted by userid. Can formulas in excel be written tha would read the userid1, read event1 and event context1, read next...

I wish to create an advanced filter that averages the values of a unique column. For example. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Column A has the following A,B,C,C,A in consecutive rows without blanks<o:p></o:p> Column B...

How do I copy a 3 digit number in one column to 3 - one digit columns? example 321 copied into 3 - 2 - 1 . Does this make sense? May be not for one two or even 10 or maybe even a 100 items but my list is over 3500 items. Please help!