+ Reply to Thread
Results 1 to 2 of 2

If formula that shows hours within first instance of range

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287

    If formula that shows hours within first instance of range

    Hi, I was looking to find out if it is possible to write an if formula that will look through a column range and if any duplicate values are found in that range then this will add a 0, otherwise it will add the value that is found in the next column.

    I am not sure if that could be written, but an example of the data that I have is shown below.

    ID | Hours
    A | 31
    B | 26
    C | 32.6
    D | 24.5
    E | 32
    E | 32
    F | 14
    G | 13.5

    The formula I would like to write should show me the following:

    Formula
    31
    26
    32.6
    24.5
    32
    0
    14
    13.5

    This would then allow me to only take 1 value for hours.

    If somebody could please advise.

    Thanks in advance.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: If formula that shows hours within first instance of range

    Hi,

    See if the attached is what you are asking for.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 05:05 PM
  2. [SOLVED] cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 04:05 PM
  3. cell shows 20. Formula shows 20. why not 540/27
    By William Horton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  4. cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] cell shows 20. Formula shows 20. why not 540/27
    By griswold in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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