Results 1 to 3 of 3

Looking back through cells in a column to find Specific Text

Threaded View

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Looking back through cells in a column to find Specific Text

    Please refer to the below thread marked as solved, however I have encountered another problem with the same item:

    Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel Programming » [SOLVED] Looking back through cells in a column to find Specific Text(s)

    Please see attached example.

    Column F is required to check column A for current row, as well as look back up the rows until it encounters an Origin. If the origin is Either NADI or PHUKET, Column F must be 0.5, if not it must be 1.0.

    At present, If i delete any formulas in column A (as shown in rows 14-19) after one of the above origins, it works fine. As soon as I copy the formula down (eg rows 27-42), it then reverts column F back to 1 for all rows except where the origin actually appears.

    How can I amend my formula please in column A or F so I dont have to go through manually and delete formulas between origins that are showing in column A.

    Also, could you please check my use of the formula in column F where it refers to PHUK and NADI to ensure i have used it correctly?
    Attached Files Attached Files
    Last edited by Grimace; 05-20-2010 at 02:26 AM.

Thread Information

Users Browsing this Thread

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

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