| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i find data from worksheets in excel
I have 3 work sheets that contain data re a rota patten.
I have a list off 12 employees in 1 column and then 5 Columns with ranges from Mon,Tue,Wed,Thu,Fri. I am trying to find a function that will allow me to search for "V" or "H" and display the name of the employee that as "V" or "H" on this day? Can any one help me please J.Ainsworth |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i find data from worksheets in excel
Can more than one employeee have a V or H for the particular day?
If the answer to that question is yes and you have the data on 3 sheets this will be VERY difficult. Putting all the data on one sheet will make things a whole lot easier. -- Biff Microsoft Excel MVP "James" wrote in message ... I have 3 work sheets that contain data re a rota patten. I have a list off 12 employees in 1 column and then 5 Columns with ranges from Mon,Tue,Wed,Thu,Fri. I am trying to find a function that will allow me to search for "V" or "H" and display the name of the employee that as "V" or "H" on this day? Can any one help me please J.Ainsworth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find like data in multiple worksheets? | Excel Worksheet Functions | |||
| Find and copy data from 2 worksheets | Excel Discussion (Misc queries) | |||
| how do i find data in several worksheets at one time | Excel Discussion (Misc queries) | |||
| How do I find data in separate worksheets and normalise? | Excel Worksheet Functions | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
![James[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
