G
Guest
I have a range of cells, say A1:B10. All of these cells contain formulas
that conditionally display a value in that cell. So, imagine looking at
A1:B10 and just a handful of the cells are displaying a value. i.e. the
formula in each of the cells resembles: IF(<some condition>,<display
conditional value>,"")
I want to filter all the nonblank cells into another location, and all in
one column preferrably. e.g. A3 shows "foo", A5 shows "squim", B7 shows
"flam", all others in A1:B10 contain the empty string "". I need D13 =
"foo", "squim", "flam".
Autofilter on nonblanks is not exactly what I want since I want to combine
all the nonblanks into another location.
Also, I tried using ISBLANK to filter the cells, but I guess ISBLANK
considers the presence of a formula to be nonblank despite what is being
shown in the cell.
Thanks for looking!
-brandon
that conditionally display a value in that cell. So, imagine looking at
A1:B10 and just a handful of the cells are displaying a value. i.e. the
formula in each of the cells resembles: IF(<some condition>,<display
conditional value>,"")
I want to filter all the nonblank cells into another location, and all in
one column preferrably. e.g. A3 shows "foo", A5 shows "squim", B7 shows
"flam", all others in A1:B10 contain the empty string "". I need D13 =
"foo", "squim", "flam".
Autofilter on nonblanks is not exactly what I want since I want to combine
all the nonblanks into another location.
Also, I tried using ISBLANK to filter the cells, but I guess ISBLANK
considers the presence of a formula to be nonblank despite what is being
shown in the cell.
Thanks for looking!
-brandon