Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm working on a sheet where I need a formula in a column that is, say, col A
* col B. Easy without merged cells. Say that nothing in Col B is merged. But, Col A, for instance, consists of two cells vertically merged, maybe 3 or 4 in places. So A1 and A2 are a single cell with one number, and B1 and B2 are separate cells with different numbers. I want two results - A (merged) times B1 in C1, A(merged) times B2 in C2. Excel unfortunately evaluates A2 as a zero. Is there a way to get it to correctly find the value of entries in col A? A cells are not always in pairs, so just referring one-row-up in every other C formula will not work. I'm thinking there might be a function that returns the highest value of a cell and any cells it is merged with. like =MERGEDHIGHEST(A2) would discover A1 and A2 are merged, and return the number in A1 rather than the phantom zero in A2. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
formula to convert raw data from several sources into relative tot | Excel Worksheet Functions | |||
Merged Cells In Data Base | Excel Discussion (Misc queries) | |||
Chart data from merged cells. | Excel Discussion (Misc queries) | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |