Functions

excel 2007 filter 3 text values at the same time from the same co.
I have a column that has these values AA, AX, AW, RJ, WD, CA, IE, NC Now I would like to filter AA,AX and IE only. How can I do it with just one step instead of filtering each one separately, copying and pasting onto another worksheet. Please, help ... 6 Apr 2010 16:29

Auto fill
When I have a spreadsheet #1 and would like it to automaticaly update spreadsheet # 3 in the same workbook, how do I do that. I know that there is a way but I cannot remember. ... 6 Apr 2010 15:21

How to stop time format changing when I merge cell contents?
I am trying to merge to time cells, (both set to English (United States), Time Type 13:30) both cells display correctly where I entered them (9:00 and 9:45) but when I merge the cell contents using the function =A4&" - "&B4 I get the result 0.375 - 0.406 instead of 9:00 - 9:45 as expected. The destination cell... 6 Apr 2010 15:21

Explain INDEX MATCH
Can someone please explain the Index, Match formula to me? It is used in a spreadsheet and I need to understand it. Thank. ... 6 Apr 2010 14:12

Calculating Time?
I have a spread sheet that in colum a I enter the time in, B is Time out, C is total time for that period, C is total for the day. Now I am trying to add all the total for the day, which it does fine unless the total time for the week is greater then 24hours. Ex: Daily Total: 0:00 Daily Total: 0:30 Daily Total:... 6 Apr 2010 14:12

Need to bring back 2 vlookup values
1 Week Ending Mar 28, 2010 TOTAL US - GROC 100 __________________________________________ I need to return back the number 100 when I have two vlookup functions that differ - e.g. first vlookup value would have be '1 Week Ending Mar 28, 2010' and the second vlookup value would be 'TOTAL US - GROC' on... 6 Apr 2010 14:12

Repeating rows not wanted
I am running Excel 2003 and not sure why this is happening. I have a 2 page report and there is a header plus I have flagged two rows to repeat at top (12 & 13). But when I print the report I get all rows from 1 to 13 repeating at the top? Has anyone come across this? Does anyone have any advice? ... 8 Apr 2010 09:30

numbers in a column are not sorting ascending
I am working in an Excel 2007 spreadsheet and one very long column of normal numbers are not sorting. for Example: 407 408 102 103 104 Everytime I try to sort this ascending, it does nothing. ... 6 Apr 2010 10:49

Sum Indirect
Hi Struggling with this indirect formula - got #ref error exel 2003 A4 = sheet number =SUM(INDIRECT("&A4&!"&M1:M14)) any one able to assist? regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201004/1 ... 6 Apr 2010 08:35

How do I use 'between' 95% and 100% for a nested IF function?
I need an excel formula which claculates 'between' 95% and 100% i.e. If( O2= between 95% and 100%, 1 x 2, 2 x 3) I need nested IF functions, ... 6 Apr 2010 11:56