Results 1 to 3 of 3

Using index match function in same row calculation

Threaded View

rehan0129 Using index match function in... 12-12-2021, 05:22 AM
AliGW Re: Using index match... 12-12-2021, 05:32 AM
bsalv Re: Using index match... 12-12-2021, 05:34 AM
  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    24

    Using index match function in same row calculation

    Hello,
    I have made sheet for making bar bending schedule for reinforcement. What I want is depending on the diameter of the bar, its total length for the particular dia in the column should be filled automatically by multiplying cut length with Nos.
    Explanation:
    If in cell M69 its 8mm, than the result in cell Q69 should be O69*P69 and rest of the cell for all other diameter in the same row (R69:X69) should be blank.
    This same pattern is to be repeated for other diameter bars. Only respective diameter bar result should be calculated in the same row and all other cells in the same row should be blank.
    In nutshell my calculation should be dependent on dia of bar in column M, and its corresponding result in its respective column Q to X.
    Any help in this regard will be appreciated.
    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDEX/MATCH based on AVERAGE calculation
    By Bad Idea Fairy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2021, 06:46 AM
  2. [SOLVED] Calculation using index/match with countif
    By seercoven in forum Excel General
    Replies: 3
    Last Post: 02-28-2017, 04:59 AM
  3. INDEX MATCH Return multiple data for YTD calculation
    By BananaJo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2017, 05:16 AM
  4. [SOLVED] Why has Index Match array slowed calculation of spreadsheet to 1.5 hours
    By carrach in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 10-11-2014, 03:15 AM
  5. Replies: 1
    Last Post: 06-17-2014, 05:38 PM
  6. Replies: 3
    Last Post: 02-21-2014, 10:02 AM
  7. USING IF ISTEXT OR ISNUMBER THEN INDEX MATCH OR calculation
    By pippib in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2012, 01:26 AM

Tags for this Thread

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