Worksheet Functions - Page 54 - OfficeFrustration

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.

		Home » OfficeFrustration forum » Microsoft Excel
Worksheet Functions

Home

Page 54 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
=B by floortje Hi, Is it possible to create a function that uses the value of a field as a pointer for another row this is what I want no-A-B 1-3-blaat 2-...	June 2nd, 2005 10:43 AM by mangesh_yadav	3	75
=bahttext(A1) please tell me about language in english how can i by after applying hte fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸² AOA Dear MS Office Team please tell me about this formula when i apply this formula then the language has changed this formula in other language not...	April 4th, 2006 03:58 AM by after applying hte fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸²	0	92
=bahttext(A1) please tell me about language in english how can i by after applying hte fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸² AOA When i feed in ms excell value 2000 then the formula will automatically convert in english words like Two thousand Rs only. Dear MS Office Team please tell...	April 4th, 2006 04:01 AM by after applying hte fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸²	0	89
=bahttext(A1) please tell me about language in english how can i by after applying the fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸² AOA When i feed in ms excell value 2000 then the formula will automatically convert in english words like Two thousand Rs only. Dear MS Office Team please tell...	April 4th, 2006 04:08 AM by Peo Sjoblom	1	124
=bahttext(A1) please tell me about language in english how can i by after applying hte fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸² AOA When i feed in ms excell value 2000 then the formula will automatically convert in english words like Two thousand Rs only. Dear MS Office Team please tell...	April 4th, 2006 04:01 AM by after applying hte fomula à¸ªà¸à¸‡à¸žà¸±à¸™à¸šà¸²	0	79
=Cell( , ) by Steven I cannot get this function to work when using a VLookup. My formula is =Cell("contents",VLOOKUP(D5,D8:E10,2,0)) where the VLookup returns an A1 or B1 or C1...	January 23rd, 2005 03:13 PM by Tushar Mehta	5	99
=cell("filename") by Steve I am trying to use a function to auto add the filename to a cell. I went to http://www.xldynamic.com/source/xld.xlFAQ0002.html for advice and got what i was...	September 22nd, 2005 08:54 PM by JE McGimpsey	3	78
=CELL("color",a1) by Fris =CELL("color",a1) displays 0 irrespective of the color of CELL a1?	November 20th, 2007 12:47 PM by Niek Otten	7	58
=cell("filename") in multiple places by Ricky Pang Hello Experts, What would be the workaround so that each tab in the workbook containing the formula =cell("filename") would have the correct tab name including...	December 6th, 2005 03:30 AM by Ricky Pang	2	81
=CELL("filename") VOLATILE? by DR Hall Our office is running Office / Excel 2003. When I enter the formula =CELL("filename") into a cell on my computer and then save the file the cell displays the...	December 31st, 2005 06:32 PM by Peo Sjoblom	6	106
=cell("filename",a1) by topher Is there anyway to use this function to enter only the filename and not the full path?	October 15th, 2005 08:46 PM by Anne Troy	3	92
=cell(color,a1) by Fris if A1 format = F2- =cell(color,a1) displays 1 if A1 format = G =cell(color,a1) displays 0 =cell(color,a1) therfore does not refer to the cell color but...	November 20th, 2007 12:37 PM by Bob Phillips	1	58
=concatenate With A Space by nander How do I concatenate Cell B3 & C3 and have a space between the values in B3 & C3? B3 C3 423 "CHANGE-OVER"...	August 15th, 2005 08:26 PM by dominicb	4	134
=CONCATENATE("today_is ",TODAY()) by Steven Stadelhofer Hello, I was trying to develop a formula(function) in one cell which would say... "Today is 6/21/04" ...I tried to use the fomula...	June 21st, 2004 06:35 PM by Harlan Grove	5	129
=CONCATENATE() help! by shfcook I'm trying to pull into one sheet, the values from the same 10 cells in about 500 spreadsheets all stored in the same way. Using =CONCATENATE() I can...	September 14th, 2005 11:01 AM by shfcook	4	130
=COUNT(IF(AND(K2:K20=382,K2:K20=383),IF(E2:E20=" x",1,0))) by [email protected] k2-k20 is a range of numbers E2-E20 include X as a name I'm attempting to count all the instances in which x exist between 382 and 383 in the k colum. I'm...	August 21st, 2006 05:01 PM by David Billigmeier	2	62
=counta() unless row is hidden by Susan hi all in column A i have some text data. some of the rows have been hidden. i want to count how many are left (visible). but any COUNT functions count the...	August 22nd, 2009 02:11 PM by JLatham	5	117
=countbycolor anomalies by Bilbert I am using the =countbycolor function provided by Chip Pearson (http://www.cpearson.com/excel/colors.htm) to count cells with a certain color font and am...	December 7th, 2006 02:18 PM by Bilbert	3	66
=COUNTIF & how to make it apply to consecutive cells by gretchen I'm a fairly new excel user and need some advice on how to count the number of cells with a specific value in a column. I know that you can use the...	July 24th, 2008 06:15 PM by M Kan	2	53
=countif (h3:h16"=01 01 2006") how to substitute cell for date by Barry this formulas works fine, however how do is substitute a a cell for the actual date, i.e. the date I want to refer to is b1. I have tried using the cell...	January 14th, 2006 12:35 AM by Barry	4	92

Page 54 of 4390

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 02:45 AM.