#1
|
|||
|
|||
Ctl Shift Arrow to Exclude Formulas
Hi, Is there a way to use ctrl shift arrow key to select only cells with data in them and exclude blanks - where the entire column range contains a formula. The formula begins =IF(ISBLANK(A1),"",VLOOKUP..... and i would like to use ctrl shift arrow key to select only those cells where the formula returned a value and NOT where it returned "". Is this possible? Thanks! Julie |
#2
|
|||
|
|||
Selelct cells for copy?
Set autofilter on table on; Activate autofilter selection for column. Unselect Blanks and click <OK>; Select all visible cells in filtered column; Copy (or do whatever you wanted to do with those cells). |
#3
|
|||
|
|||
thanks! that does work. though my team didn't have this issue last week. it is only after we added new rows to the file that this problem started occuring. we simply inserted rows and dragged the formulas down. was hoping to get things back to what they were but this is certainly a good work around.
|
#4
|
|||
|
|||
When inserting rows (Copy, Insert, Shift rows up/down) cell references may get messed up. Better way is to copy whole row, and then use Insert Copied Rows.
When originally the same formula was same for whole row, then the way to get table to work again is to find a row where formula(s) are OK, select cell(s), and drag up/down for rest of rows. Or correct manually the formula(s) in topmost row, and then copy down. When the formulas were different for different rows, and you can't restore the file, or messing formulas up was done many days ago, you are out of luck and you have to create formulas anew. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Night shift and Day shift | Tinbot11 | Project | 1 | 05-09-2016 06:32 PM |
SQL db query to exclude some entries | jillapass | Excel | 1 | 11-09-2012 04:53 AM |
Noob here - I need a shift calendar by days with count of shift. | freeman | Excel | 8 | 09-12-2012 08:45 AM |
Exclude phrase from email | kiwiora | Outlook | 2 | 07-16-2012 03:03 PM |
Alt-Shift-Direction Arrow | Joshuasq | Word | 2 | 02-12-2011 09:21 AM |