| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to concatenate cells that meets a specific criteria in threecolumns
Hello,
Enter into C1: =IF(ISBLANK(A1),"",LOOKUP(2,1/ISBLANK($A$1:A1),$B$1:B1)&A1) and copy down. Regards, Bernd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to concatenate cells that meets a specific criteria in threecolumns
On Jul 16, 3:58*pm, Bernd P wrote:
Hello, Enter into C1: =IF(ISBLANK(A1),"",LOOKUP(2,1/ISBLANK($A$1:A1),$B$1:B1)&A1) and copy down. Regards, Bernd Hi Bernd, Thanks for the solution its working perfect. Regards Ramana |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to concatenate cells that meets a specific criteria in threecolumns
Hello Ramana,
You are welcome. Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I format cells with data that meets certain criteria? | Excel Worksheet Functions | |||
| Do Nothing If Meets Criteria | Excel Discussion (Misc queries) | |||
| Adding data in a list that meets a specific criteria | Excel Worksheet Functions | |||
| Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
| Max value that meets a criteria | Excel Worksheet Functions | |||
Hybrid Mode
