|
Data Validation and Empty Row
Folks - I have a spreadsheet with two columns Database Name Status ABC Checked ABC Checked ABC Checked Here is a Blank Row Checked XYZ Checked XYZ Modified XYZ Modified XYZ Modified Here is another blank row How can I get rid of Status value for blank rows? Can someone please help? Regards, mzafar -- mzafar ------------------------------------------------------------------------ mzafar's Profile: http://www.excelforum.com/member.php...o&userid=16096 View this thread: http://www.excelforum.com/showthread...hreadid=388352 |
Autofilter all the non-blank rows F5 - Special - Visible cells only - Delete mzafar Wrote: Folks - I have a spreadsheet with two columns Database Name Status ABC Checked ABC Checked ABC Checked Here is a Blank Row Checked XYZ Checked XYZ Modified XYZ Modified XYZ Modified Here is another blank row How can I get rid of Status value for blank rows? Can someone please help? Regards, mzafar -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388352 |
| All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com