Hi I have 4 columns and I want to find the intersection numbers in this columns with formula:
the output must be number (2)Please Login or Register to view this content.
Hi I have 4 columns and I want to find the intersection numbers in this columns with formula:
the output must be number (2)Please Login or Register to view this content.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks