Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2018, 03:40 AM
julien julien is offline Ctl Shift Arrow to Exclude Formulas Windows 7 32bit Ctl Shift Arrow to Exclude Formulas Office 2010 32bit
Novice
Ctl Shift Arrow to Exclude Formulas
 
Join Date: May 2018
Posts: 2
julien is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-11-2018, 03:50 AM
ArviLaanemets ArviLaanemets is offline Ctl Shift Arrow to Exclude Formulas Windows 8 Ctl Shift Arrow to Exclude Formulas Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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).
Reply With Quote
  #3  
Old 05-11-2018, 04:37 AM
julien julien is offline Ctl Shift Arrow to Exclude Formulas Windows 7 32bit Ctl Shift Arrow to Exclude Formulas Office 2010 32bit
Novice
Ctl Shift Arrow to Exclude Formulas
 
Join Date: May 2018
Posts: 2
julien is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 05-11-2018, 05:08 AM
ArviLaanemets ArviLaanemets is offline Ctl Shift Arrow to Exclude Formulas Windows 8 Ctl Shift Arrow to Exclude Formulas Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ctl Shift Arrow to Exclude Formulas 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
Ctl Shift Arrow to Exclude Formulas Noob here - I need a shift calendar by days with count of shift. freeman Excel 8 09-12-2012 08:45 AM
Ctl Shift Arrow to Exclude Formulas 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft