two columns

  1. G

    Autofilter using two date interval_dates stored in two columns

    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...
  2. S

    Comparing two columns to another two columns with similar data

    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...
  3. O

    Find earliest data by date

    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...
  4. R

    Loop through ID's and calculate number of days...

    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...
  5. C

    Puzzling Find If Date Falls Between Two Dates And Return Value

    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...
  6. S

    Comparison & Duplicate Check

    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...
  7. K

    Conditional Formatting

    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...
  8. D

    HELP plz?? Trying to count number of occurances in 1 column, that occur between dates in another

    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...

Some videos you may like

This Week's Hot Topics

Top