+ Reply to Thread
Results 1 to 2 of 2

Confirm if last entry in a row is specific data

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    bristol, England
    MS-Off Ver
    2007
    Posts
    62

    Confirm if last entry in a row is specific data

    Hi all,

    I am trying to use a formula to confirm if the last entry in a row a specific bit of data.

    So for each row I need to Know if the last entry in it (Furthest right) begins with a 1, if it does I would like the formula to return Yes, if it does not begin with a 1 I would like it to return no?

    Is this possible?

    Thanks as always

    Claire

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Confirm if last entry in a row is specific data

    This would work for row 4. You can change it to look at whatever row you need to.

    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-11-2013, 09:25 AM
  2. [SOLVED] Lock All Cells after data entry of a specific cell
    By celialynn in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-09-2012, 01:41 AM
  3. Replies: 1
    Last Post: 04-14-2012, 08:09 PM
  4. Prompt users for data entry upon specific cell value
    By Coachwooten in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-29-2012, 12:54 PM
  5. Matching Data Entry to a specific list
    By rob1st in forum Excel General
    Replies: 6
    Last Post: 04-29-2009, 05:46 PM

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