Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking at a table. It is almost like a 2X2 array.
I want to find out if a person is trained in an area(Excel). The tabl has training (Rows), and names (Columns). The search would be for sa "Current". Then output in the following format on a new worksheet. Status (Search type) Training Name(i.e. Excel spreedsheets) John Smith Mike Jones Scott Verhoef ect. I could adapt the code to search for the following Current Update(6months), Update(3months), Update(1month), Expired, an Untrained. I know I am going to have to use a loop and some type of filter. I am still looking for the answer. Just thought some one might hav done this -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
Function to seacrh for a word across multiple columns | Excel Worksheet Functions | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
How do I seacrh for the chracter "*" without it being a wildcard. | Excel Discussion (Misc queries) | |||
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming |