+ Reply to Thread
Results 1 to 7 of 7

Find in the same column but give result from another column

  1. 10-29-2017, 08:35 AM #1
    J8zel
    J8zel is offline
    Registered User
    Join Date
    02-18-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Find in the same column but give result from another column

    Hi everyone

    I'm looking to find a product in the same column but let me know if there's another product less than a minute closeby.
    Is this possible?


    Time Product Solution
    00:25:00 Restaurants/Takeaways - OK
    00:26:00 Telecommunications - Adjust
    00:26:30 Telecommunications - Adjust
    00:27:00 Hardware - Adjust
    00:27:30 Hardware - Adjust
    00:55:00 Accountants - OK
    00:56:00 Telecommunications - OK
    00:56:15 Financial Institutions - OK
    00:56:45 Restaurants/Takeaways - OK

    Sorry but the table is not showing.

    Assume Time, Product and Solutions are the coulmns. Solution column is where I want to place the formula.

    Cheers
    Last edited by J8zel; 10-29-2017 at 08:39 AM. Reason: The table didn't look right
    Reply With QuoteRegister To Reply
  2. 10-29-2017, 08:50 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Find in the same column but give result from another column

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 10-29-2017, 09:38 AM #3
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Find in the same column but give result from another column

    Hello and welcome to the forum.

    Try this in C2:

    =IF(COUNTIFS(A:A,">"&A2-TIME(0,1,0),A:A,"<"&A2+TIME(0,1,0),B:B,B2)=1,"OK","Adjust")
    Reply With QuoteRegister To Reply
  4. 10-30-2017, 08:08 AM #4
    J8zel
    J8zel is offline
    Registered User
    Join Date
    02-18-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Find in the same column but give result from another column

    Sorry guys - please find attached file

    falcondude - thanks for the formula however all cells in the column said "Adjust". I just copied and pasted the formula - did I miss a step?

    the time will go for 24hours so the rows will be long.

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 10-30-2017, 08:30 AM #5
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Find in the same column but give result from another column

    The times in column A are formatted as Text.

    To convert the text times to actual times, highlight column A > Text to Columns > Finish

    Then apply the formula given in post #3.
    Reply With QuoteRegister To Reply
  6. 11-02-2017, 07:42 AM #6
    J8zel
    J8zel is offline
    Registered User
    Join Date
    02-18-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Find in the same column but give result from another column

    falcondude thank you!!! it worked yeay!
    Reply With QuoteRegister To Reply
  7. 11-02-2017, 08:12 AM #7
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Find in the same column but give result from another column

    You're welcome. Thanks for the rep!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Last edited by 63falcondude; 11-02-2017 at 09:35 AM. Reason: Rep Added
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Which formaula give the actual result in description column
    By Imran368 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2016, 02:53 PM
  2. Find first cell in column less than 2000 and give associated number
    By rongil20 in forum Excel General
    Replies: 1
    Last Post: 04-14-2016, 05:46 AM
  3. Excel copy images from Column B to column C and give them name of column A
    By sofianeuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2015, 07:41 PM
  4. Search the value in first column and give the corresponding second column value as result
    By szpt9m in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-19-2013, 06:48 AM
  5. [SOLVED] using a max formula on a column with no data to give a Blank result
    By Brentsa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2013, 05:42 AM
  6. Find part of a text in a column and give as a result the position of the text
    By enitron in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 04:33 AM
  7. match two column in sheet 1 v shee 2 and find the result column
    By smlim7 in forum Excel General
    Replies: 2
    Last Post: 06-23-2011, 11:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1