| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning Data to an empty Cell
Worksheet 1 is called All Staff
Worksheet 2 is called TEAM 1 Worksheet 3 is called TEAM 2 All Staff A B C LOCATION EMPLOYEE # EMPLOYEE NAME 1 JOHN SMITH 2 RAY SMITH TEAM 1 A B LOCATION EMPLOYEE NAME DOWNTOWN OFFICE JOHN SMITH TEAM 2 A B LOCATION EMPLOYEE NAME CENTRAL OFFICE RAY SMITH I would like a formula to gather the location for each employee and return it to the All Staff worksheet. Thank you -- Newfie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning Data to an empty Cell
It's ok worked it out my self, thanks though.
-- Newfie "Newfie809" wrote: Worksheet 1 is called All Staff Worksheet 2 is called TEAM 1 Worksheet 3 is called TEAM 2 All Staff A B C LOCATION EMPLOYEE # EMPLOYEE NAME 1 JOHN SMITH 2 RAY SMITH TEAM 1 A B LOCATION EMPLOYEE NAME DOWNTOWN OFFICE JOHN SMITH TEAM 2 A B LOCATION EMPLOYEE NAME CENTRAL OFFICE RAY SMITH I would like a formula to gather the location for each employee and return it to the All Staff worksheet. Thank you -- Newfie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list from empty data cell source | Excel Worksheet Functions | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| Returning an empty cell when no data present | Excel Discussion (Misc queries) | |||
| Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
| Returning Data from a third cell in same row that meets two other | Excel Discussion (Misc queries) | |||
Linear Mode
