A Microsoft Office (Excel, Word) forum. 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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
XIRR function not defined? by Alex
For some reason the XIRR function on the version of Excel 2003 on my new computer is not working. When I enter it the "#NAME?" response comes up, and when I...
February 21st, 2008 10:04 PM
by George T Go to last post
3 110
compould yield calculation by alex
The yield function in excel gives the simple yield calculation, while am looking for the compound yield calculation thanks
November 23rd, 2007 04:01 AM
by ryguy7272 Go to last post
1 62
Time Calculation by alex
Hello experts, Question on how to add hours to a time... E.g., I have a time in A1 (let's say 6:06 AM) I want to add an amount to A1 (let's say 8.5 hrs in...
December 20th, 2007 12:21 AM
by Fred Smith Go to last post
5 70
Nesting named formulas by Alex
I want to go around the maximum of 7 nested functions in Excel. I have created two named formulas as described on...
December 21st, 2007 03:10 PM
by Alex Go to last post
2 103
Data Validation - Insert Row by Alex
Hi, I have been trying to figure this out but, can’t seem to find a solution. Please Help. Cell A1 will show lists of categories (fruits or veggies), cell...
February 29th, 2008 05:48 PM
by Pete_UK Go to last post
3 78
Range by alex
Hello experts, using Excel '03... I'm trying to write a formula that checks a range of cells, basically modifying this formula: if(B55="","1","2") to...
March 7th, 2008 07:24 PM
by alex Go to last post
2 77
If function with Another Function by Alex
I have a function that extracts the number only from a string. Example: Cell A1: Fund: fhks99al, Cell B1 with function =NumberOnly(A1) will result in 99. ...
May 1st, 2008 04:04 PM
by Rick Rothstein \(MVP - VB\)[_364_] Go to last post
3 69
Vlookup with the result being once cell below the orginal value by Alex
Hi I have a vlookup in which I wanted to return the value for the cell right below what would have the orginal cell. This is the Formula I have. The...
May 1st, 2008 06:08 PM
by T. Valko Go to last post
3 108
Sort Chart Values by Alex
I have tried Jon Peltier's example on linking table to sort data for charting by using the LARGE function, to no avail. My data is set up different than...
July 14th, 2008 07:24 PM
by Alex Go to last post
0 73
SNMP functions? by Alex
Hi Does anyone know about Excel add-ons or functions for SNMP queries, like SNMP GET, GETNEXT, GETBULK, etc. TIA Alex
October 24th, 2007 03:33 PM
by Alex Go to last post
0 60
Help with Concatenation by alex
Hello all, I'm trying to concatenate two cells with dates. The concatenation works; however, the dates change formats. Formula: =concatenate(i34," and...
August 28th, 2007 06:09 PM
by alex Go to last post
3 87
Excel 2003 customize toolbar command lost by Alex
Recently my Excel does not keep customize toolbar commands (like paste special value). Once excel is close and re-open, the customized commands...
April 17th, 2007 08:30 PM
by Dave Peterson Go to last post
5 108
Can I lookup a value in a range of worsheets? by Alex
I would like to use a formula that will lookup a value within a specific cell over a range of worksheets. Similar to vlookup only for a range of worsheets...
June 20th, 2007 04:01 PM
by rayh Go to last post
2 63
Freeze Panes Shared workbook problem by Alex
I am using Microsoft Excel 2002, and was wondering if there is away around my problem. Currently often in the shared workbooks when freeze panes is used, it...
May 16th, 2007 03:07 PM
by Alex Go to last post
0 113
plus 1 by alex
Hello Experts, I have an xls worksheet in which users paste a date from another application. Once pasted, I want to increase the value by one day (in the...
(Multi-page thread 1 2)
July 25th, 2007 11:15 PM
by Gord Dibben Go to last post
10 85
return partial string by alex
Hello experts, I'm attempting to write a function that will return part of a name. E.g., I have the name John Doe in cell A1. I want the cell B1 to populate...
July 20th, 2007 11:41 AM
by alex Go to last post
5 118
Sum If by Alex
Hi - can comeone help me please Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18 contain the word "Premier" tks
July 24th, 2007 10:46 AM
by Alex Go to last post
3 114
Using Rank function, how to show value as 'N/A' IF O by Alex
I have put an rank function in place which works as follows (column A in my worksheet) =RANK(AC3,AC$3:AC$134,0) This works fine, except I want it to come up...
August 1st, 2007 12:48 PM
by Alex Go to last post
2 94
Minimum Value by Alex
Hi, using an accounting format on Row E, I am trying to extract thje lowest value from E6:E34 where B6:B34 = 2006. I am using:...
August 1st, 2007 03:44 PM
by Toppers Go to last post
2 148
Vlookup based on 2 criteria by Alex
I have a table that has three values seen below. I would like to transfer/copy these values into a new worksheet that has the date listed horizontally on...
July 21st, 2008 07:15 PM
by Alex Go to last post
2 73
Post New Thread


Display Options
Showing threads 2261 to 2280 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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 12:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.