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
average rate of change per given time period between 2 moments in time of a value by David Virgil Hobbs
I could not find any Excel function for a very basic task: Calculating the average percentile (or other) rate of change of a value between two time...
December 19th, 2006 08:24 AM
by Martin Fishlock Go to last post
1 49
Excel Formula using relative position of cells in two different worksheets by David Virgil Hobbs
I want to know how a certain Excel formula would be written. Excel formulas reside in cells computing the value of the cell content. A given formula can be...
December 14th, 2006 04:36 AM
by Martin Fishlock Go to last post
1 42
Another way to lookup data by David Vollmer
I need another way to take the contents of two cells (City and State) and go find whether they exist on another workbook that contains a sheet for each state....
September 23rd, 2005 05:16 AM
by JMB Go to last post
1 171
sequential counter by David Webster
I have a column of species and a row of plots as follows: PLOT: 1 2 3 4 5 Spp1 Spp2 Spp3 Spp4 Spp5 .... to Spp 150
September 17th, 2003 07:34 PM
by 2rrs Go to last post
4 301
MouseClick as Counter by David Webster
Is there a way to add code so that you add one to every cell you click on within a range? E.g. any cell between say C3 to H20 when I clik it I want it to...
September 17th, 2003 08:45 PM
by Andy Brown Go to last post
1 324
Applying module to startup by David Webster
I have created an Application.OnKey code that maps PasteSpecial to F15 but I want it to work every time I open a new spreadsheet when I start up. How is this...
September 25th, 2003 07:39 PM
by Cliff Myers Go to last post
1 137
applying macro to startup by David Webster
Hello I created a code in a module that allows me to map Paste Special Value to F15. I want this macro to automatically start when I load any new...
September 29th, 2003 01:18 PM
by Bob Phillips Go to last post
2 371
A formula to discount percentage by David Wilson
I am trying to find a formula to discount by percentage rather than currency on Excel 2007. Example: A1 B1 C1 £25 ...
February 12th, 2009 09:33 PM
by Shane Devenshire[_3_] Go to last post
4 78
percentage formula by David Wilson[_2_]
can someone give me a formula to dicount by percent. Example: A1 B1 C1 £50. -33% £33.50 ...
April 15th, 2009 03:38 AM
by T. Valko Go to last post
3 95
How to show two students have same result? by DAVID Yii
How to show that two or more students having a same CGPA? If there are 100 students,then the top of 2 students have the same CGPA,by ranking they both are Num...
November 19th, 2008 01:21 PM
by vezerid Go to last post
6 70
Compare times : IF time time2 then by [email protected]
Hi, I'm stuck on a comarison of times problem. My time column is formatted as "dd/mm/yyyy hh:mm:ss" although the cell is formatted as hh:mm:ss I'd like a...
July 12th, 2006 11:36 AM
by Pete_UK Go to last post
2 73
Recalculation taking a massive 11 seconds by David.Allen297
Hi, I've designed a simple spreadsheet that's looking at a small table of data and returning 2 values. (The sheet gets updated by external means, hence I'm...
November 12th, 2005 07:46 PM
by David.Allen297 Go to last post
2 73
1 Attachment(s) Recalculation taking a massive 11 seconds by David.Allen297
Hi, I've designed a simple spreadsheet that's looking at a small table of data and returning 2 values. (The sheet gets updated by external means, hence I'm...
November 12th, 2005 02:21 AM
by David.Allen297 Go to last post
0 85
Identification of what day it is by [email protected]
Hi I was hoping someone could shed some light on this.I want column B to identify the day in column A and express it as text. I.E. when column A is...
March 8th, 2008 08:47 PM
by Tyro[_2_] Go to last post
5 106
Return a different date format by [email protected]
Hi Can anyone help me with this? What i want to do is to take part of two dates and ,a name and combine them into a string. In other words,I want to take the...
February 22nd, 2008 11:10 PM
by David Biddulph Go to last post
1 82
How to use time with an If command? by [email protected]
Can anyone tell me what formula i could use to perform a function whenever for example,the month of April or perhaps the 31 days of a specific month appears in...
February 19th, 2008 12:05 AM
by Tyro[_2_] Go to last post
1 56
Looking up non-unique data by david1
I haven't had to do this for so long that I've forgotten how, so memory jogs would be appreciated. Assume datalist subset: A1:A10 =...
January 20th, 2006 01:41 AM
by Domenic Go to last post
1 55
Create a list based on single shared criteria by David127
An array or function is needed to create a list based on a single shared criteria. ID# Value Name y1 5 Jill x2 7 Jack x3 ...
December 15th, 2005 03:36 AM
by Biff Go to last post
5 139
Worksheet design: How to allocate costs to plants? by David3553
Hi, I'm trying to find a way to allocate administrative costs to plants. I have a worksheet set up to do it, but it's complicated and doesn't handle adding...
July 4th, 2008 06:11 AM
by David3553 Go to last post
0 86
Easy quesiton: Text sorting. by david987
I'm just wondering how can I make text to be sorted from the right to left... Instead of having: Hello Example One Have:
September 23rd, 2003 12:38 AM
by Harlan Grove Go to last post
1 145
Post New Thread


Display Options
Showing threads 20061 to 20080 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 09:50 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.