Macro or formuale help required comparing cel
Closed
NT
-
May 13, 2009 at 06:46 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - May 14, 2009 at 02:43 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - May 14, 2009 at 02:43 AM
Hello,
I've got Excel 2003 with 2 columns of data A & B with people names in it. Column A is always populated with data (a name), column B isn't always populated (with a name) its either present or not.
I've got to a point whereby if there is nobodys name in a row cell for column B (i.e. its an empty cell) I want the contents to the right of that particular cell (i.e. persons name in column A) copied to another column i.e. C
Its probably simple but I'm not sure how to do this so any help would be appreciated.
Many thanks
NT
I've got Excel 2003 with 2 columns of data A & B with people names in it. Column A is always populated with data (a name), column B isn't always populated (with a name) its either present or not.
I've got to a point whereby if there is nobodys name in a row cell for column B (i.e. its an empty cell) I want the contents to the right of that particular cell (i.e. persons name in column A) copied to another column i.e. C
Its probably simple but I'm not sure how to do this so any help would be appreciated.
Many thanks
NT
Related:
- Macro or formuale help required comparing cel
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- This ipod cannot be used because the required ✓ - iTunes Forum
- Run macro when cell value changes by formula ✓ - Excel Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 14, 2009 at 02:43 AM
May 14, 2009 at 02:43 AM
put the following formula in cell C1,
=if(B1="",A1,"")
=if(B1="",A1,"")