+ Reply to Thread
Results 1 to 8 of 8

adjusting formula index with count t get last value in column

  1. 05-13-2020, 06:31 AM #1
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    adjusting formula index with count t get last value in column

    hello

    i need help to fix my formula to get the last value in columns it supposes the result in e2,e3,d2,d3 after search in cell a3
    this is my formula
    HTML Code: 
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-13-2020, 08:33 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,632

    Re: adjusting formula index with count t get last value in column

    In D3 enter
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and pull right
    Reply With QuoteRegister To Reply
  3. 05-13-2020, 11:04 AM #3
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: adjusting formula index with count t get last value in column

    hi, pepe you can check my file after use a new formula , your formula works only in e2 and 2 and gives me wrong date in e3,d3 and i would for you make clear this
    HTML Code: 
    what means , please ?
    Attached Files Attached Files
    Last edited by ABDELFATTA; 05-13-2020 at 11:06 AM.
    Reply With QuoteRegister To Reply
  4. 05-13-2020, 12:10 PM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,632

    Re: adjusting formula index with count t get last value in column

    See attached
    Use the Evaluate formula tool to see how the formula works
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-13-2020, 12:14 PM #5
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: adjusting formula index with count t get last value in column

    where i get this tool from,please ?
    Reply With QuoteRegister To Reply
  6. 05-13-2020, 12:17 PM #6
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,632

    Re: adjusting formula index with count t get last value in column

    Formula tab - Formula auditing group
    Reply With QuoteRegister To Reply
  7. 05-13-2020, 12:22 PM #7
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    758

    Re: adjusting formula index with count t get last value in column

    thank pepe for every thing now formula really works
    Reply With QuoteRegister To Reply
  8. 05-13-2020, 12:22 PM #8
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,632

    Re: adjusting formula index with count t get last value in column

    You're welcome
    also see https://www.ablebits.com/office-addi...okup-function/ for more explanation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with adjusting Index lookup formula to include additional lookup criteria
    By kingofcamden in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-14-2018, 01:04 PM
  2. Adjusting an array formula to not count blank spaces.
    By RYLEE.HART in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2016, 07:23 PM
  3. [SOLVED] Roadblock Adjusting Formula... Not sure how to calculate incorporating a new column
    By jnswbc in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-04-2016, 03:15 PM
  4. [SOLVED] Adjusting Formula For Newly Inserted Column
    By general_excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2016, 03:14 PM
  5. Adjusting code to check column, and insert formula
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2010, 01:50 PM
  6. How to copy formula without column row numbers adjusting?
    By stormracela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2010, 08:46 PM
  7. Automatically Adjusting a Column with a Formula
    By mellissacook in forum Excel General
    Replies: 5
    Last Post: 04-09-2008, 04:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1