Devam Ediyor

Excel Keyword Search

Using the previous spreadsheet, on the DASHBOARD sheet, in cell F10, I would like a keyword search that would display the same information as the other searches (ID, LAST NAME, FIRST NAME, DEGREE, YEAR, and JOB TITLE) of everyone in Sheet1 with a word in their title, such as "Professor", "Emerit", "Art"...

For example, if I typed in "Professor" it would display almost everyone, and if I typed in "Vice President" it would display:

ID | FIRST NAME | LAST NAME | DEGREE | YEAR | TITLE

19 | C.H. Bolton | Bolton | B.S., D.D | 1948/49 | Professor Vice President & Finance Comm.

47 | Ralph H. | Ferell | | 1962/63 | Professor Vice President & Finance Comm.

47 | Ralph H. | Ferell | | 1963/64 | Professor Vice President & Finance Comm.

47 | Ralph H. | Ferell | | 1964/65 | Professor Vice President & Finance Comm.

47 | Ralph H. | Ferell | | 1965/66 | Professor Vice President & Finance Comm.

47 | Ralph H. | Ferell | | 1966/67 | Professor Vice President & Finance Comm.

Beceriler: Excel, Üretim, Matematik, İstatistik, Uygulamalar için Visual Basic

Daha fazlasını görün: ralph, keyword search, finance excel, excel finance, display excel cell, search keyword excel 2010, dashboard excel using, finance excel spreadsheet, excel dashboard using, excel finance spreadsheet, dashboard excel spreadsheet, spreadsheet dashboard, 1964, sheet dashboard excel, keyword name, search excel cell, excel finance dashboard, excel macro job, php code example job, excel scheduling job coding, search vbscript excel, toronto excel expert job, keyword search excel, searches excel, excel keyword

İşveren Hakkında:
( 8 değerlendirme ) Deland, United States

Proje NO: #6556696

Seçilen:

Aldo21

Hired by the Employer

3 gün içinde 40$ USD
(14 Değerlendirme)
3.4