| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is it vlookup, match, offset?
Order Date Ship Date First Name Last Name Cycle
20051101 20051104 ALITA FAUSETT 0 20051119 20051123 ALITA FAUSETT 1 20051101 20051104 BEVERLY HUSTON 0 20051119 20051123 BEVERLY HUSTON 1 20051221 20051223 BEVERLY HUSTON 2 If there is a reoccurring name in cycle 1, I need to know the shipdate in column B; Is there an easy way? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is it vlookup, match, offset?
Have you looked at Data / Filter
HTH Michael M "ADiscrete1" wrote: Order Date Ship Date First Name Last Name Cycle 20051101 20051104 ALITA FAUSETT 0 20051119 20051123 ALITA FAUSETT 1 20051101 20051104 BEVERLY HUSTON 0 20051119 20051123 BEVERLY HUSTON 1 20051221 20051223 BEVERLY HUSTON 2 If there is a reoccurring name in cycle 1, I need to know the shipdate in column B; Is there an easy way? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is it vlookup, match, offset?
Actually this is a sampling of about 18000 rows of already filtered down data, but thank you. "Michael M" wrote: Have you looked at Data / Filter HTH Michael M "ADiscrete1" wrote: Order Date Ship Date First Name Last Name Cycle 20051101 20051104 ALITA FAUSETT 0 20051119 20051123 ALITA FAUSETT 1 20051101 20051104 BEVERLY HUSTON 0 20051119 20051123 BEVERLY HUSTON 1 20051221 20051223 BEVERLY HUSTON 2 If there is a reoccurring name in cycle 1, I need to know the shipdate in column B; Is there an easy way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
| Which to use - if, vlookup, match, index, offset, vba? | Excel Discussion (Misc queries) | |||
| Formula Help With MATCH & OFFSET | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Linear Mode
