+ Reply to Thread
Results 1 to 2 of 2

intersections value in columns formula

  1. #1
    Registered User
    Join Date
    09-20-2019
    Location
    lebanon
    MS-Off Ver
    2016
    Posts
    29

    intersections value in columns formula

    Hi I have 4 columns and I want to find the intersection numbers in this columns with formula:
    Please Login or Register  to view this content.
    the output must be number (2)

  2. #2
    Registered User
    Join Date
    04-20-2015
    Location
    cairo,egypt
    MS-Off Ver
    2010
    Posts
    48

    Re: intersections value in columns formula

    Assuming that Column A is the tallest one, then we will use Vlookup on its cells
    try typing this code on cell F2
    =(VLOOKUP(A2,B:B,1,0)+VLOOKUP(A2,C:C,1,0)+VLOOKUP(A2,D:D,1,0))/3

+ 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. Finding Intersections in Charts?
    By Scott S. in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-19-2017, 02:56 PM
  2. Finding Intersections
    By John Bates in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2008, 10:56 AM
  3. How to use labels or Intersections to sum data
    By jchambers00 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2007, 06:39 PM
  4. Counting Intersections
    By tpampel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2006, 12:31 PM
  5. Looping macro needed to find intersections of rows and columns
    By Clifford Middleton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2006, 09:10 AM
  6. Intersections
    By Voodoodan in forum Excel General
    Replies: 3
    Last Post: 08-12-2005, 12:08 PM
  7. Intersections of two lines
    By George III in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 04:17 PM

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