Is there a formula I can use to automatically skip blank rows and return only the values of a particular cell(s) that have numbers in them?

I have a activity to record and there could be three to four dates for start of that activity(Suppose A1) and end of that activity (Suppose B1) {like the activity start on 12-nov-2010, 18-Nov-2010, 25-Nov-2010 and this same activity finishes ...

I have two worksheets in my workbook. I want to create a “Print” button on Worksheet 1 (the worksheet that I use to enter data) that will print Worksheet 2. I know how to create a print “button” on my Worksheet ...

Can Excel 2016 find and replace a word’s (character string) font color? I need the capability to search a spreadsheet for a word and change that word’s font color. For example, find all instances of the word “ANALYZE” and change the ...

If I have data that needs to be separated into columns that looks like this: JaneDoe MaryannSmith RobertWhite Is there a way to separate into a first name and last name column? Thanks – Alice

Hi Heroes, I’ve got quite a big spreadsheet (1.4MB) with a lot of calculations on it but nothing Excel shouldn’t be able to handle. When I try to copy and paste it causes excel to go “Not responding” Any help on how ...

I have produced a document to act as a school report, in a protected form that teachers can complete as required. However I have inserted the picture place holder, but want my users to be able to change the picture, ...

I CANNOT OPEN MY DATABASE

I have a problem when copying cells with formula from window to a new window,excel 2010 said the range you are pasting contains formulas that cannot be pasted into this instance of Excel;however,the formulas will be pasted as value,,, So ...

Anyone know what this error means: There was an error processing a page. There was a problem reading this document (18). I’m getting it when trying to view a pdf in Version 7. Any assistance is greatly appreciated!