what syntax is correct in the false part of an "if" statement to delete a
blank row...eg =if( a1= "Tom", B1,{ what goes here to delete the row so as
blank rows are not returned}
what syntax is correct in the false part of an "if" statement to delete a
blank row...eg =if( a1= "Tom", B1,{ what goes here to delete the row so as
blank rows are not returned}
Formulas can't be used to hide rows.
You can use a filter to hide rows based on a condition
select your data
Data=>filter=>Autofilter
select the column that has the values you want to filter on. Select the
dropdown and set the condition. so you would filter on Tom, so only rows
containing tom are visible.
Repeat the sequence to in the menu to remove the filter.
--
Regards,
Tom Ogilvy
"John O'brien" <John O'[email protected]> wrote in message
news:[email protected]...
> what syntax is correct in the false part of an "if" statement to delete a
> blank row...eg =if( a1= "Tom", B1,{ what goes here to delete the row so as
> blank rows are not returned}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks