LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default Matching dates to cells

Hi,
IS THERE A WAY TO FIND ALL CORRESPONDING A'S FOR COLUMN "F" THAT HAVE
THE SAME DATE IN COLUMN A. WHAT I WOULD LIKE FOR IT TO DO IS IN ANOTHER
COLUMN TO NUMBER THE ADJUSTMENTS (COL G).
Col A Col B Col C Col D Col E Col F COL G
1/8/2008 2396112 50 NEW C
1/17/2008 25391 -50 R
1/28/2008 2406382 50 REN C
2/7/2008 25572 -50 A 1
7/22/2009 2716889 14,268.00 REN C
7/22/2009 -10,701.00 F
7/29/2009 1387 -3,567.00 R
7/22/2009 2716889F 10,701.00 REN F
8/12/2009 ach081209 -10,701.00 C
4/28/2008 26513 -1,136.00 R
4/21/2008 2453844 19 END C
4/28/2008 26596 -19 R
5/30/2008 2476656 1,155.00 INS C
6/24/2008 -1,155.00 V
6/24/2008 2490192 531 END C
8/1/2008 26784 -12 R
8/5/2008 -519 A 2
6/24/2008 2490197 1,297.00 INS C
6/26/2008 25972 -1,155.00 R
7/2/2008 -1,297.00 V
7/8/2008 1,155.00 A 3
7/2/2008 2495031 1,155.00 INS C
10/9/2008 30148 -1,155.00 R
7/3/2008 2496532 1,155.00 INS C
7/8/2008 -1,155.00 A 3
7/01/08 1234566 50.00 C
2/07/08 12345 -50.00 A
1
7/7/08 -519 C
8/05/08 123456 519.00 A
2

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
matching data to dates - please help Marty[_2_] Excel Worksheet Functions 8 January 1st 09 09:14 PM
Matching dates Hutchy Excel Discussion (Misc queries) 2 August 29th 07 12:02 PM
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side [email protected] Excel Discussion (Misc queries) 2 June 11th 07 02:38 PM
macro paste by matching dates arepemko via OfficeKB.com Excel Discussion (Misc queries) 10 September 7th 06 08:47 PM
Matching 2 "dates" that are formated differently carl Excel Worksheet Functions 3 December 3rd 04 07:35 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"