Ctl Shift Arrow to Exclude Formulas

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:25 PM.