Ctl Shift Arrow to Exclude Formulas

		Microsoft Office Forums > Microsoft Excel > Excel
Ctl Shift Arrow to Exclude Formulas

FAQ

Thread Tools

Display Modes

05-11-2018, 03:40 AM

julien

Windows 7 32bit Ctl Shift Arrow to Exclude Formulas

Office 2010 32bit

Novice

Join Date: May 2018

Posts: 2

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:22 PM.