Delete rows
Hi
I want to delete rows. I am doing Vlook up, and I am getting some rows with #N/A and some with 1. Then I want the code to find out which rows have #N/A and delete them. I am getting some problems with #N/A, is there any way to convert it to other thing or in delete rows code, just to put N/A (without #) Thanks |
Delete rows
=IF(ISNA(vlookup_formula),"N/A",vlookup_formula)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Faboboren" wrote in message ... Hi I want to delete rows. I am doing Vlook up, and I am getting some rows with #N/A and some with 1. Then I want the code to find out which rows have #N/A and delete them. I am getting some problems with #N/A, is there any way to convert it to other thing or in delete rows code, just to put N/A (without #) Thanks |
Delete rows
Thanks Bob,
How do I create the delete-rows code and insert what you wrote down for me "Bob Phillips" wrote: =IF(ISNA(vlookup_formula),"N/A",vlookup_formula) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Faboboren" wrote in message ... Hi I want to delete rows. I am doing Vlook up, and I am getting some rows with #N/A and some with 1. Then I want the code to find out which rows have #N/A and delete them. I am getting some problems with #N/A, is there any way to convert it to other thing or in delete rows code, just to put N/A (without #) Thanks |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com