How can Excel recognize a merged cell's value automatically, without using absolute address?
Unquestionably, it's too unproductive to change the formula for C2-C4 singly. Please don't ask me to
or use absolute address of Cell A1 ($A$1) in Cell C2 and drag the formula down. Why? Undoubtedly, this is too unproductive if column A has many cells, and if only some cells in column A are merged. Then I must manually and singly locate the merged cells, to change their formula to absolute address.