-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if not empty
-
J
Formula to find column value with ticked/filled cells for Google Sheets
I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...- jw2022
- Thread
- cell value excel excel formula formula google sheet if not blank if not empty is not blank search not blanks
- Replies: 8
- Forum: General Discussion & Other Applications
-
S
If not (empty selection) then ...
Good morning to all, An easy one.. I have the following code, it works, but it breaks whenever somebody chooses a full column ($A:$A) as it selects all the blank cells and performs all the loop to all cells.. How may the code be adapted in order to work with the selected range EXCEPT blanks...- sm3117
- Thread
- blanks in range if not empty loop except blanks no blanks select all except blanks
- Replies: 4
- Forum: Excel Questions
-
C
copy autofilter values if not empty
Hi i need help with a small problem. have a thread which filters a dataset to show a criteria wanted to use ActiveCell.Offset(1, 0).Activate ActiveCell.Select If Not IsEmpty(Range(Selection).Value) Then ..... end if to determine whether there are any values...- confused in Frankfurt
- Thread
- autofilter if not empty
- Replies: 2
- Forum: Excel Questions
