Functions

find&select button, help?
Hi everybody, i'm using excel 2007,when i press the find&select button it dosen't sow me the cell i'm looking for,it has been disabled,although when i look the rows one by one i can find it,how can i able the find&select. i'd appreciate if u'd let me know,cuz i'm in trouble here ... 18 Feb 2010 07:14

_xlfn prefix
Hi all, I have a "true blood" XL 2007 .xlsb workbook that was created in XL 2007. There are no workbooks open in compatibility mode anywhere. The workbook however does contain links to a 2003 workbook (currently closed.) In my Range name list, I have a range name _xlfn_IFERROR with a value of #NAME. I am... 18 Feb 2010 12:51

Multiple criteria search
Here a version with the labels in row 3 and the data starting in row 4 =INDEX(Sheet2!A3:F7,MATCH(Sheet1!A17&Sheet1!B17&Sheet1!C15,INDEX(Sheet2!A3:A7&Sheet2!B3:B7&Sheet2!C3:C7,0),0),MATCH(E10,Sheet2!A3:F3,0)) t e y l y n ; 6 4 6 9 1 9 W r o t e : Hi, the following formula works with Sheet2 having the... 18 Feb 2010 05:03

how do i import data from my excel worksheet into quickbooks
... 18 Feb 2010 11:43

how to calculate the difference of values (numbers) in a column?
A B C D A1 10 A2 9 1 A3 8 2 1 A4 7 3 2 A5 6 4 3 1 I need to calculate the differences of each value in a column and have the answers on second third column. For example subtract A2 from A1, A3 from A1, A4 from A1, A5 from A1; and subtract A3 from A2, A4 from A2,... 18 Feb 2010 02:53

Adding formula
I am trying to complete a formula that will enable me to do the following. D4 = C3 + C4 D5 = C4 + C5 So the total in the D columnis the addition of the new C column total. example: B C D 10+10 20 20 <-- 20+10 30 50 <-- these is a running totals 5+... 17 Feb 2010 23:35

where is tthe "read only" TOGGLE button ?
HI i often open a file and leave open as a read only file , and whenever i edit a cell , i click on the "read only " toggle button then key in the password and then save the file , then click on "read only" again and the file is read only again, i dont have to close and reopen the file to make changes to any ce... 18 Feb 2010 11:43

How to sum the number of times answered in a single column with b.
I have a column of data with number answers and blanks. The numbers vary slightly between 9 to 11, with no answers or zero's for some rows. I only want to know the number of times in the column that an anwer is present out of 214 rows. I thought the "DCOUNTA" function was right, but I just can't get it. It ra... 17 Feb 2010 21:21

how do I create a formula to add up time on a time sheet
I am creating a weekly time card for our office. I have columns for start and stop times and have successfully found the formula to get each time segment to add up in the third column. When I try to make that 3rd column add up the total hours for the week I can't get a sensible result. Also, is there a simple ... 17 Feb 2010 17:57

countif object
Is there a way to use a count function for objects? I have a series of textboxes in rows and columns that will be moved around freely. I need to be able to have a running count of how many textboxes are in each row and how many are in each column. VBA suggestions are also appreciated. Thanks in advance. ... 17 Feb 2010 16:48