# Dividing merged cell in two different sheet

1. ## Dividing merged cell in two different sheet

I have two different excel sheet with merged value. Suppose, column A of sheet 1 has merged row (A2:A5), (A6: A10) and so on and column B of sheet 2 has merged row (D2:D5), (D6:D15), (D16:D20) etc, . I am trying to divide the value of column 1 by column 2 like (A2:A5)/(D2:D5), (A6: A10)/(D6:D15),.... , but I am getting wrong value for second division. Numerator value is changing but the denominator remains same. Sorry , yy sentence must be confusing. This is what I am getting:

(A2:A5)/(D2:D5)
(A6: A10)/(D2:D5)

But actually I should get
(A2:A5)/(D2:D5)
(A6: A10)/(D6:D15)

Anjani  Register To Reply

2. ## Re: Dividing merged cell in two different sheet

I have attached sample files  Register To Reply

3. ## Re: Dividing merged cell in two different sheet

Hello anji001 and Welcome to Excel Forum.
Perhaps the following will help.
Produce a list of distinct Names. This could be done by copying the column from sheet 2 > utilize the Find & Select feature (Home tab) > Go to Special > select Blanks > OK > using the mouse right click and select Delete > move cells up.
To get the values use the formula: =INDEX(Sheet1!D\$2:D\$19,MATCH(G2,Sheet1!\$C\$2:\$C\$19,0))/INDEX(D\$2:D\$5,MATCH(G2,C\$2:C\$5,0))
Let us know if you have any questions.  Register To Reply

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