| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use functions when cells are merged
I have a worksheet with data on the first tab. Cells C2, C3, C4 and C5 are
merged cells and cells E2, E3, E4 and E5 are NOT merged but coinside with the other cells in the respective rows. Then the next 4 cells are merged in column C and they again go with column E which is never merged. I am trying to get a count of items in Column E that have "Absent" in the column AND Column C has "Allen". If I un-merge the cells then the data only goes into the first cell and the others are left blank. I want it to assume that if the cells are merged then all merged cells contain that data. Please help! I worked on this for several hours. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text wrap in merged cells | Excel Discussion (Misc queries) | |||
| paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
| con't paste merged cells | Excel Worksheet Functions | |||
| getting msg: cannot sort merged cells not same size | Excel Discussion (Misc queries) | |||
| Charting of Merged Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
