Results 1 to 8 of 8

Last value from column of formulas

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Last value from column of formulas

    I want to return the last posted value from column K. The problem I am having is that the column is populated from the formula show below and all I get is a blank value.


    =IF(AND($G3="",$H3=""),"",COUNTIFS($D$3:$D3,$D3,$I$3:$I3,"W")&" - "&COUNTIFS($D$3:$D3,$D3,$I$3:$I3,"L"))
    It is a column that returns a win loss record based on a given year (column D).

    Jim O
    Last edited by JO505; 09-08-2015 at 06:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear column D cells in same row if formulas in column A yield blank value
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2015, 03:03 PM
  2. [SOLVED] Remove duplicate entries from one column and output it into another column using formulas
    By alrikvincent in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-12-2014, 08:55 AM
  3. Macro that moves Formulas 1 column right and then Pastes Values into previous column
    By ExcelDavid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2014, 05:30 PM
  4. Move formulas to another column then preserve values in 1st column
    By malanis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2014, 04:55 PM
  5. VBA to copy formulas in column D and paste as values in same column
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2012, 05:18 AM
  6. Excel 2007 : sum a column containing formulas
    By gsdanger in forum Excel General
    Replies: 2
    Last Post: 06-10-2010, 05:57 PM
  7. copying formulas from column to column
    By mufan in forum Excel General
    Replies: 2
    Last Post: 06-04-2009, 06:24 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