two columns

Hi I've been looking at a lot of transpose demos, still can't get what I need to do this so let me explain. I have a four column table and I am looking to Transpose it over to a two column table or array? It will reuse the column headers so I'm thinking a loop for them and a counter to...

Dear All, I have a database of projects and I need to filter to those projects which were active in 2016. Column J contains the projects' start date, column K contains the projects' end date in a mm/dd/yyyy format. So I do not want my filtered list to contain projects that run out of this...

Hello everybody, I need to compare two areas with two columns each . First column is full of dates, and the second has names in it. Both columns in both areas are already sorted A to Z. Areas are similar to each other, but some names/dates combinations can appear in one area, and not in...

Hi all, I wonder if anyone could help me with a work related excel query I have. I have two columns of data and need to find the earliest plan date and keep only that (deleting any duplicate named plans with later dates) Please see the below example of columns I have, the result I need is...

Hi I am an Excel VBA beginner. I have an Excel sheet with 3 columns. The EmployeeID is in column A and this is repeated for whatever number or records it has. In column B there is a start date, and in column C a "Talent" grade change. I want to output in column D, a result which shows the...

Hi everyone, I'm using Excel 2007 and I've tried a lot of different methods including VLookup and Match to solve this problem, but nothing is working. I have data like this: A B C 1 12/10/2002 10/9/2003 Period (dec. 10, 2002 - oct. 9...

I have two columns with names of people, <TABLE style="WIDTH: 241pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=322><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 63pt; mso-width-source: userset...

Hello! I have two columns. Lets say column A and column B. In column B I have positive, negative and nul prices. If cell B1 has a positive price, I want cell A1 to have green colour. If cell B1 has a negative price, I want cell A1 to have red colour. If cell B1 has a zero price, I want cell A1...

Hi, I've been struggling to get my head around, what is possibly a simple formula.. heads fried.. Column A Column B A 03/01/2008 A 15/01/2008 A 29/01/2008 B...