+ Reply to Thread
Results 1 to 11 of 11

How to search a column with keywords and write decimal value in to a row

  1. #1
    Forum Contributor
    Join Date
    07-05-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    100

    How to search a column with keywords and write decimal value in to a row

    Hi ,

    I have a excel work sheet. It has 5856 file names in the B column.
    I want to search particular file name by keyword search.
    If the keyword match with a file name or part of the file name then I want to write a new decimal value in the same row but in the C column.


    For example I want to search Project management keyword in the B column (B1:B5856). If I found three results such as in B5, B10, B5050 then I want to write 1.01 values in to C5, C10 and C5050.


    Could you please help me?
    Last edited by naflas; 07-06-2010 at 06:44 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: How to search a column with keywords and write decimal value in to a row

    Here is a way using A filter Macro
    Please Login or Register  to view this content.
    Check out the Example
    Attached Files Attached Files
    Last edited by davesexcel; 07-05-2010 at 11:21 PM.

  3. #3
    Forum Contributor
    Join Date
    07-05-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: How to search a column with keywords and write decimal value in to a row

    Thanks for your msg,

    I'd like to scan B(B1:B5056) column for a certain word (e.g. "Project Management") and put a code (e.g. "PM") on the cell next to it each time it finds it. In this case, "Project Management" might be by itself or in the middle of a sentence.Also "Project Management" keyword can exist more than one place in the B column.

    Can you help me pls?
    Last edited by davesexcel; 07-05-2010 at 10:49 PM. Reason: Quoting previous posts are not required.

  4. #4
    Forum Contributor
    Join Date
    07-05-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: How to search a column with keywords and write decimal value in to a row

    Your code does not work mate, Only display the (1.01) value in the first row of the C column....
    Can u pls help me?

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: How to search a column with keywords and write decimal value in to a row

    My code works just fine.
    You will have to attach a sample of your workbook, to see what the problem is.
    Keep it to 50 rows or so

  6. #6
    Forum Contributor
    Join Date
    07-05-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: How to search a column with keywords and write decimal value in to a row

    According to your advise the code would be

    Please Login or Register  to view this content.
    If I type Project Management Plan its displays 1.01 in the D1 cell. It is wrong. 1.01 should be in 58 cells( D4,D14,D58.... etc.)
    Last edited by davesexcel; 07-05-2010 at 11:11 PM.

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: How to search a column with keywords and write decimal value in to a row

    Check out the amended code

  8. #8
    Forum Contributor
    Join Date
    07-05-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: How to search a column with keywords and write decimal value in to a row

    Thanks mate,

    I tried your sample but when I try with my work sheet It does not work

    The work sheet has 5856 rows,

    I also paste those rows into your sample sheet and tried, but did not work , its only return 1.01 value to the first row.


    Could you please help me

    Quote Originally Posted by davesexcel View Post
    Check out the amended code

  9. #9
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: How to search a column with keywords and write decimal value in to a row

    Stop changing the code! I have it at B65536 for a reason, so the code will find the very last cell in the column.
    Last edited by davesexcel; 07-06-2010 at 01:44 AM.

  10. #10
    Forum Contributor
    Join Date
    07-05-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: How to search a column with keywords and write decimal value in to a row

    Yes mate it is working

    Your NO 1

    Many * 10000*10000= Thanks


    Quote Originally Posted by davesexcel View Post
    Stop changing the code! I have it at B65536 for a reason, so the code will find the very last cell in the column.

  11. #11
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: How to search a column with keywords and write decimal value in to a row

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1