#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Text seacrh

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using TEXT and &TEXT - display numbers with commas, underline text Gary Excel Discussion (Misc queries) 3 May 5th 23 03:46 AM
Function to seacrh for a word across multiple columns Vibeke Excel Worksheet Functions 2 April 19th 10 09:01 AM
Text does not display in "Text boxs" and when wrapping text in a c Esteban Excel Discussion (Misc queries) 1 March 8th 07 11:59 PM
How do I seacrh for the chracter "*" without it being a wildcard. erareeve Excel Discussion (Misc queries) 3 March 7th 06 03:28 PM
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' Dan E[_2_] Excel Programming 4 July 30th 03 06:43 PM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"