Worksheet Functions - Page 453

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
XL 2003: How do I get every possible combination? by Conan Kelly Cross-posted: - microsoft.public.excel.programming - microsoft.public.excel.worksheet.functions Hello all, I'm looking for an XL solution and/or a VBA... ( 1 2)	July 17th, 2009 05:09 PM by Dana DeLouis[_3_]	14	191
Help with large texts in excel spreadsheets by Anne I need to use excel for a report as it contains numerous charts and links etc but I also need to add a lot of text to support it. I tried formating the excel...	July 17th, 2009 04:49 PM by Shane Devenshire[_3_]	1	141
Copy rows based on parameters by npop03 Hello all, I am trying to find a way that will allow me to copy an entire row of data from one sheet to another based on matching values. Hard to explain,...	July 17th, 2009 03:52 PM by npop03	2	105
How do I get cursor to move left and right in excel? by Q-Bear Since I started using office 2007 it has been annoying when something that was simple to find answers for before now require a degree in rocket science....	July 17th, 2009 03:51 PM by Meebers[_2_]	3	186
summing only certain numbers in calumn by carourke A B C 1111 5000 2 2222 3000 1 1111 4000 1 2222 700 1 Col A has 200 set number codes, col b has various amounts, col C has set...	July 17th, 2009 03:41 PM by Shane Devenshire[_3_]	2	82
compare cells, copy, loop by Immortal_Creations I"m working on an inventory sheet which constantly changes in size. If there is a way to do this with Functions, i would rather that because this is a report...	July 17th, 2009 03:34 PM by Bernie Deitrick	2	125
Worksheet to Worksheet by Yoli In worksheet 1, I have: A B C 27 1.5 text 15 1.0 text 27 .75 text In a cell in worksheet 2, how do I get all the text...	July 17th, 2009 03:16 PM by Teethless mama	1	75
selecting the penultimate cell from a column of data by jfp =IF(ISERROR(MATCH(9.999999E+306,A:A)),MATCH("",A:A,-1), IF(ISERROR(MATCH("",A:A,-1)),MATCH(9.999999E+306,A:A), MAX(MATCH(9.999999E+306,A:A),MATCH("*",A:A,-1))...	July 17th, 2009 02:37 PM by jfp	3	103
How do I add up the last 12 cells (containing values) in a column. by Michelle D I have a table of hours worked by temporary staff which I am constantly adding new values to. I need to calculate average hours worked from the last 12 weeks...	July 17th, 2009 02:28 PM by Teethless mama	4	97
Data validation against seperate worksheet by Kcope8302 I have a large dataset that I am importing from an outside source. This data contains all project codes from a specified date. To be able to limit the data I...	July 17th, 2009 02:19 PM by Max	1	79
Ifs by myname[_2_] Dear group, I'm trying to calculate the attendance allowance as follows: 1) if accumulated 2 or more days of sick leave from beginning of year to last...	July 17th, 2009 02:08 PM by myname[_2_]	2	84
www fahrrad mit hilfsmotor,elektro fahrrad preis,elektrofahrradplus,ride klapprad,elektrofahrrad antrieb,yamaha elektro fahrrad,elektrofahrradmotor,kalkhoff elektro fahrrad,emg elektro fahrrad edq,sachs fahrrad mithilfsmotor,fahrad mit elektrom by fbysngfbsgfn www fahrrad mit hilfsmotor,elektro fahrrad preis,elektrofahrrad plus,ride klapprad,elektrofahrrad antrieb,yamaha elektro fahrrad,elektrofahrrad motor,kalkhoff...	July 17th, 2009 11:56 AM by fbysngfbsgfn	0	302
colum is not found thats missing a column B how to find it by meena colum is not found thats missing a column B how to find it	July 17th, 2009 10:36 AM by Stefi	1	86
How to concatenate cells that meets a specific criteria in threecolumns by ramana Hi All, I need to concatenate values from two rows I tried But I couldn't able. I'll expalin my situation I have two columns A and B in which data was...	July 17th, 2009 09:13 AM by Bernd P	6	73
Retrieve formula instead of value by willemeulen[_47_] Does anyone know if it is possible to retrieve a fromula instead of a value from another cell. Now I have a huge lookup table where I use match/index function...	July 17th, 2009 08:28 AM by Liliana[_3_]	1	77
Merge base on same code number by Pran Hi Groups, I have such data which is one column (ex:B) has various same code number, but di other column (ex : A) has single different area. So, how can I...	July 17th, 2009 08:26 AM by Pran	5	124
ä¿è·å·¥ä½œè¡¨ by AMOS* å„ä½å¤§å¤§: EXCELä½¿ç”¨äº†ä¿è*·å·¥ä½œè¡¨,è€Œé™å®šäº†ä½¿ç”¨è€…åªèƒ½ç·¨è¼¯æŸäº›å›ºå®šçš„æ¬„ä½,ä½†ç•¶ä½¿ç”¨è€…æ–¼é€™äº›æ¬„ä½ä¸Šç·¨è¼¯å¾Œ,ç™¼ç¾ç·¨è¼¯æœ‰èª¤...	July 17th, 2009 07:18 AM by AMOS	0	124
Data Verification between worksheets by Kcope8302 I have a large dataset that I am importing from an outside source. This data contains all project codes from a specified date. To be able to limit the data I...	July 17th, 2009 07:02 AM by Max	1	95
Omitting whole numbers when formatting decimals by BunnyHop Hi, I am trying to copy a number, e.g. 24.8795 to a different cell. Once copied I want to be able to format the new cell without the whole number(including...	July 17th, 2009 06:52 AM by Shane Devenshire[_3_]	2	97
Get Cell Style by Thomas M.[_2_] Excel 2007 I need to return a boolean value based on whether or not a cell contains a hyperlink. All the cells that contain hyperlinks are formatted in the...	July 17th, 2009 06:24 AM by Thomas M.[_2_]	2	113

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed