Worksheet Functions - Page 79 - 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 79 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
How can I apply a function (PROPER) to multiple cells at once? by AGrozier have a "database" of names and addresses completely in uppercase letters and need to format it with the PROPER function so I can use it to print address...	December 3rd, 2007 07:54 AM by Tim Zych	3	120
Formula by agungf84 Hi all, I am new to this website and am wondering if anybody can help me. I want to form a formula that if number 6000,4000,2000, or 0 appear, that it will...	June 18th, 2006 08:33 AM by Mallycat	1	74
Is there a way to save header that repeats from worksheet to works by aguy	June 19th, 2008 03:33 PM by Spiky	4	125
Time difference w/o weekends by AG[_5_] Hi! Can someone help me with a formula to compute the time difference between two columns containing "Start Date & Time" and "End Date & Time". I want to... ( 1 2)	May 29th, 2008 01:27 AM by Shane Devenshire	12	153
How to flag the items that net off each other by AG[_5_] Hi Everyone, I have a problem and even after trying out several things I am not able to solve it. I have a table as below: Code Book ...	October 23rd, 2008 01:59 PM by AG[_5_]	3	63
Computing the item age by AG[_5_] Hi, Can someone help me with this: I have the following type of data: Itam Tag Last Updated Date AAA 01-Jan-09 AAB 01-Jan-09 AAC ...	May 28th, 2009 03:11 AM by AG[_5_]	3	113
Identifying the presence of a randomly ordered text string in a cell by AG[_5_] Hi All, I am facing a challenge where I need to do certain computations based on text that is entered by the users manually. There is a series of cells in one...	September 3rd, 2009 10:21 PM by AG[_5_]	2	119
Calciation by AH i want to calk a loan in excel - and the Variabels is :- rent, loan amount, year x, and total year payback I want to calk the rest loan after x year...	January 30th, 2009 08:41 PM by Shane Devenshire[_3_]	1	67
Replace text with text by AH I have text within a cell that I need to replace with differenct text so I can so a vlookup. Example: FDA1510 needs to become CA1510, there are about 160+...	June 2nd, 2009 10:06 PM by Shane Devenshire[_3_]	1	67
Excel queries by ah Hi; Appreciate if someone could help me with this: I have a spreadsheet that contains a column for the user to indicate whether they want to "Update" or...	May 8th, 2008 02:23 PM by Dave Curtis	2	141
If statement help needed by ah Hi; I get an error when I use the following statement: =IF(ISNUMBER(SEARCH("Cost... ( 1 2)	June 19th, 2007 09:19 PM by Roger Govier	16	138
how do I insert picture into cell so vlookup can return picture? by ah I have a table in excel containing names of products and their pictures. On another worksheet, I want to select the name of the product from a drop-down list...	May 1st, 2007 04:38 AM by JE McGimpsey	1	56
formula needed by ah Hi; Can anyone advice me on how to extract the text value only? The formula that I'm using currently works well if the text value appears before the space...	February 5th, 2007 07:38 AM by David Biddulph	9	40
left function by ah Hi; Can anyone advice me on how to : extract all the wording in a cell except the numeric value, for example: Example: For ABCDDEFG 1234------- I want it to...	January 31st, 2007 12:24 PM by Bob Phillips	4	47
indirect function by ah Hi; I'm using the "indirect" function to duplicate my contents from 1 sheet to another worksheet. The formula that I'm uisng is :...	January 25th, 2007 12:22 PM by CoRrRan	1	63
insert records by ah Hi; I'm facing some issues with the following, could anyone help? a) I've created 2 worksheet in a spreadsheet , name as "A" and "B" All the employees will...	January 25th, 2007 02:13 PM by vezerid	2	57
Ranking within in ranges by ah I need a formula that will allow me to rank one column of numbers based on a value in another column. e.g. If I have values in column A and countries...	April 12th, 2006 04:22 PM by ah	2	85
Create a prompt as a person saves a file by ah I would like to create a prompt that will pop up as a user tries to save a file and ask them have they filled in a certain cell, say "A2" Can anybody...	February 9th, 2005 08:19 PM by ah	4	65
display formula instead of its values in some cells by ah 3 Hello all, I encountered problem for some excel files when typing a formula but displayed a formula instead of its calculated values, e.g. when I entered... ( 1 2)	January 9th, 2006 03:59 PM by ah 3	11	219
EXCEL IF FUNCTION by Ah Ping Excel IF Function Help!!! plz? Ok I am having problem with Excel IF Function. Here is the problem. (Cell A1) 10209.0 - (Cell A2) 10208.7 (Cell A5) = A1 -...	April 29th, 2007 11:55 AM by MH[_2_]	9	146

Page 79 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 03:29 AM.