Functions

Oops
Sorry for the double post julie kothari wrote: Double quotes when using line feed 09-Apr-10 I use ASAP Utilities which is a free pack of Excel macros. Under Export, there is a function called Copy Selection As Values. That copies everything except the double quotes to the clipboard. I assigned the funct... 9 Apr 2010 19:00

Double quotes when using line feed
I use ASAP Utilities which is a free pack of Excel macros. Under Export, there is a function called Copy Selection As Values. That copies everything except the double quotes to the clipboard. I assigned the function to Shift-Control-C and it works like a charm. CarlT wrote: Line Feed in Formula Adds Double ... 9 Apr 2010 17:53

Excel 2007 - AVERAGEIF on rows that are non-continuous
I have 42 rows of data and I need to average every 3rd row if ">1". I've tried a couple formulas: 1. averageif(D6,G6,J6,M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6,AN6,AQ6,">1",D6,G6,J6,M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6,AN6,AQ6) I get #VALUE. 2. =SUM(SUMIF(INDIRECT(D6,G6,J6,M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6,AN6,AQ6),">1"))/SUM... 9 Apr 2010 20:07

=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
Anyone see the problem with this, it isn't working. I am tring to put all the results (in columns AF:AR) into a cell, based on the input Z3 (The input will match only one row in AD2:AD361) Sorry I know I have asked this question tons of different ways but I'm not able to make it work ... 14 Apr 2010 12:12

sum column based on single cell match?
This seems so simple and yet the solution eludes me... In row 2 I want Excel to match a cell's contents (ex: find 3200). Once finding the column that matches, I want it to sum rows 3:94. Thank you in advance for your assistance. ... 9 Apr 2010 14:31

Counting Merged Cells
Is there a formula I can use to: 1. Count the number of merged cells (comprised of 3 cells) in a column AND how many of those are blank? 2. Count the number of merged cells (comprised of 2 cells) in a column AND howmany of those are blank? ... 9 Apr 2010 21:13

return 0 if cell has data?
I feel stupid asking this question.......I just cannot figure a formula out that I know I know......... I need a formula to display 0 in a cell if another cell has a date. ... 9 Apr 2010 13:25

How do I truncate linked text?
I am linking text from other worksheets, but I only want a portion of the text to appear in the final document, using a certain number of characters. Any ideas? ... 9 Apr 2010 14:31

IF Formula
I have formula =min(312,200+8) and im trying to add the IF function to it as well, with the logic that if 0<312 that the text will change a certain color if true and a different color if its false. Is there a way to do this? ... 9 Apr 2010 14:31

Using VLookup with 2 Workbooks
Hi, I am stumped and hoping someone can assist me. I am writing a macro that will format workbook1 and pull who is assigned to a task from the previous days report(workbook2). I am getting an error on the table array and can not figure it out. I am using excel 2007 on windows XP pro OS. I will post the co... 9 Apr 2010 12:18