ExcelBanter - Excel conditional cell merge

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel conditional cell merge (https://www.excelbanter.com/excel-discussion-misc-queries/212972-excel-conditional-cell-merge.html)

Sandip Dalvi

Excel conditional cell merge

Hi,
How we can merge rage of cell based on a condition may be in fourmula or
using macro
Regards
Sandip

Max

Excel conditional cell merge

Presuming you meant say conditionally concatenate only if cols A and B both
contain numbers, then something like this
In C2: =IF(COUNT(A2:B2)=2,A2&", "&B2,"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Sandip Dalvi" wrote:
How we can merge range of cell based on a condition may be in formula or
using macro

All times are GMT +1. The time now is 02:35 PM.