Of all the rows that have X in the "I" column, return the row w/ oldest date in A col

**ks100** · 10-28-2015, 02:19 PM

I need to search through all the rows that contain variable X in the "I" column, and then out of these cells, return the row that has the oldest date in the "A" column.

What's the fastest way to do this? I could try some Do Until chains but I feel that would slow my already lagging script.

**protonLeah** · 10-28-2015, 02:22 PM

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

Of all the rows that have X in the "I" column, return the row w/ oldest date in A col

LinkBack

Thread Tools

Rate This Thread

Display

Of all the rows that have X in the "I" column, return the row w/ oldest date in A col

Re: Of all the rows that have X in the "I" column, return the row w/ oldest date in A col

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro To Look at list of files in column "A" and show their last Saved Date in Column "B"

[SOLVED] return value from row where column equals "y"- problem with skipping rows

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

Return "green", "yellow" or "red" from date/age and priority ranking

lookup date in column, search columns to right for name, return "x"

Select the oldest date of based on "P" in another column

Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank

Bookmarks

Bookmarks

Posting Permissions