| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bringing to a cell the last date an event occurred
This is a long worksheet and need a formula, but don't know if possible.
A COLUMN B COLUMN C COLUMN Doe, John Jan 05 a Doe, Jane Jan 16 a Presley, Elvis Jan 22 Doe, Jane Jan 30 a All the previous data will be in SHEET 1 Now, in SHEET 2 : COLUMN A = all possible names in COLUMN A SHEET 1, written by me. The formula will be used in COLUMN B, SHEET 2 and will tell me which was the last date for example DOE,JANE had a letter "a" (Jan 30 should be the result of the formula) I'm thinking in VLOOKUP formula but don't know how to organize it. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shade cell shortcut without bringing up palette | Excel Discussion (Misc queries) | |||
| how do i keep a time/date register of every change occurred in a c | Excel Worksheet Functions | |||
| What is the syntax to check if a date occurred before a referance. | Excel Discussion (Misc queries) | |||
| Bringing partial data from one cell into another | Excel Worksheet Functions | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
Threaded Mode
