+ Reply to Thread
Results 1 to 5 of 5

Replacing Values

Hybrid View

  1. #1
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Replacing Values

    like this?

    =IFERROR(IF(($E5<>$E4),IF($E5<>"",$Y5,($Y5+$Y4)),""),"")
    well, technically that returns an empty text string rather than a blank cell.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  2. #2
    Registered User
    Join Date
    12-27-2013
    Location
    Irving, Texas
    MS-Off Ver
    Excel 2013
    Posts
    42

    Re: Replacing Values

    Labor Tracking Log 10.4.xlsx
    Sorta, yes. I've attached the workbook with some sample data. Our equation is rocking out in Column Z. I put a couple different manager names in column E so that I could have two separate counts going. So, the count for Ed should be 2 and the count for Same should be 3, given this sample data. Make sense?

+ 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. [SOLVED] Replacing formula values with text/raw values
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-08-2013, 12:36 PM
  2. [SOLVED] Help with replacing values.
    By igolfniray in forum Excel General
    Replies: 6
    Last Post: 04-13-2012, 03:39 PM
  3. replacing certain values
    By nesthead98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2009, 04:22 AM
  4. Replacing many values
    By David Gilbert in forum Excel General
    Replies: 4
    Last Post: 08-12-2009, 11:28 AM
  5. Replacing Linked Cell Values w/ Current Values
    By TomCat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2006, 07:25 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