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
formula for negative time durations by DAZA
I am looking for a formula that will produce negative time durations...
April 16th, 2008 05:45 PM
by Pete_UK Go to last post
1 89
Removing Digit Separator by Daze
I've string of digits like this 111/2222/33333. How can i change it to 111222233333? -- Daze
July 23rd, 2008 08:42 AM
by Dennis Go to last post
2 50
Cells are not sorting correctly by Daze3Daze
Hi...I'm trying to sort a column of percentages from highest to lowest I unhide and highlight all the columns (so they stay together) and then hit...
December 17th, 2008 08:47 PM
by Daze3Daze Go to last post
2 93
Concantenate columns with dates and text by Dazed and Confused
The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly...
April 4th, 2009 01:02 PM
by Dazed and Confused Go to last post
2 57
transferring files by DAZED AND CONFUSED
I SENT A FILE FROM THE OFFICE USING EXCEL, AT HOME I HAVE XP HOME, HOW CAN I READ IT WITHOUT BUYING FURTHER SOFTWARE.
September 24th, 2005 04:33 PM
by Debra Dalgleish Go to last post
2 104
Office 2007 How do I change the direction of the enter key betwee. by Dazed n confuzed[_2_]
Excel, Office 2007. How do you change the direction to move right between cells instead of down, when using the enter key?
November 25th, 2008 01:07 AM
by Shane Devenshire[_3_] Go to last post
1 82
List top five by Dazed&Confused
Hi there, I've searched this site looking for an answer for this but no luck What I have is imported list of invoices thousands of rows long with about 450...
March 16th, 2010 03:13 PM
by Dazed&Confused Go to last post
4 220
Insert Current Date when cell is empty?? by Dazed&confused!
HI Apologies for this - I just seem to have left my brain at home today. Essentially I'm calculating the time difference in hours between IssueLogged and...
February 7th, 2007 10:18 AM
by Dazed&confused! Go to last post
4 60
Update of cell values after insert row? by dazman
Hi, I have a worksheet where using VBA I am inserting a new row and setting cell values in the new row to values specified in other worksheets. I can...
August 23rd, 2005 07:07 AM
by dazman Go to last post
2 162
Real Value of .UsedRange.Rows.Count by dazman
Hi, In VBA I'm setting a variable as follows: NumRows = Sheets("Summary").UsedRange.Rows.Count and NumRows is subsequently used to make sure a chart has the...
August 25th, 2005 03:24 PM
by dazman Go to last post
2 106
Implied Compound Interest? by dazman
Hi, I've just checked all the Excel Compound Interest functions but I can’t seem to find the exact one for calculating implied compound interest. I have a...
January 6th, 2006 07:01 PM
by [email protected] Go to last post
4 97
If Formula by dazoloko via OfficeKB.com
Dear All I have two columns (A and B) that Contain a "Y" or "N" in column A and a Date or Blank in Column B. If A = "Y" and B has a Date in the Result is...
May 31st, 2008 10:33 AM
by dazoloko via OfficeKB.com Go to last post
6 99
Formula by dazoloko via OfficeKB.com
Dear All Im wandering if someone can assist. I have two columns each containing a Monetary Value Amount Chargeable and Potential Charge Im after an If...
July 3rd, 2008 05:13 PM
by dazoloko via OfficeKB.com Go to last post
3 69
comparing two columns & then perform a calculation by dazp1970
Hi, I am a teacher analysing attendance figures - and struggling somewhat! Here's what I want to do . . . I have a spreadsheet with the following columns: A ...
September 10th, 2005 01:17 PM
by Ian Go to last post
2 71
Conditional formating for text by dazp1970
I am using conditional formatting to change the colour of cells that contain text. What I am trying to do is format cells so that those that do contain text...
April 27th, 2007 07:10 AM
by Max Go to last post
1 56
converting a decimal to time by dazp1970
I want to be able to convert a decimal into time, and am completely stuck! As an example, I have in cell A1 4.9 (this number represents 4.9hrs). I want a...
August 5th, 2007 09:16 AM
by David Biddulph Go to last post
3 55
EXCEL FUNCTIONS by DAZZER
I WANT TO SORT NUMBERS, ODD FROM EVEN, AND THE MOST PREFERRED IN A GROUP OF 23 NUMBER. HELP?
January 20th, 2009 02:40 AM
by JE McGimpsey Go to last post
2 67
Fast fourier transforms by dazzler2058
Can anyone tell me how to use the the output from the fast fourier analysis tools?
January 13th, 2010 05:29 PM
by dazzler2058 Go to last post
0 84
45 Day Count Down Timer by da_bigone
I am creating a worksheet to track a 45 day window. I need the worksheet to count down in days from 45 to 1 in column L from any date entered in column K. 45...
August 30th, 2009 11:43 AM
by Joel Go to last post
1 129
Mathematical elimination by da_big_k
how could i use excel to eliminate certain feilds like how leagues are able to eliminate certain teams for playoff...
January 11th, 2006 07:22 PM
by ufo_pilot Go to last post
2 79
Post New Thread


Display Options
Showing threads 20281 to 20300 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 03:23 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.