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
eliminate partial text in many fields by BuffaloBilly
I have many fields with, for example, "08:22 CST" and I'd like to eliminate the "CST" so that I can use an IF formula with these times. How can I eliminate...
December 27th, 2006 02:45 AM
by Teethless mama Go to last post
1 93
cell math to decrement/increment a cell by BUFFETT
I have a total cell that I can add or subtract from. Any ideas? My math is as such IF(A6-A50,...
June 16th, 2006 08:37 PM
by Chip Pearson Go to last post
1 54
Help with a formula - probably an "IF" by Buffgirl71
I have cells that look like this, sorted in this order: A1 B1 B2 What I want B2 to be 2 1212 ...
March 2nd, 2006 12:52 AM
by Buffgirl71 Go to last post
5 108
Calculate the difference between two times by Buffgirl71
I have two columns. Both have a time format of NN:NN:NN. I would like to calculate the difference. For example, if I have 10:02:01 and 10:03:05, I want to know...
February 10th, 2006 01:05 AM
by Buffgirl71 Go to last post
3 77
Overline the sum instead of underline the number by Buffgirl71
I many times need to add additional numbers to the bottom of a column of numbers that I'm summing. When I do this, I always have to reformat so the underline...
January 10th, 2006 09:07 PM
by Ron Coderre Go to last post
1 100
Calculate the difference between two times by Buffgirl71
I have two columns formatted as time in this manner: NN:NN:NN. I want to calculate the difference between the two times. For example, in the first column I...
February 9th, 2006 11:10 PM
by Bob Phillips Go to last post
1 52
Inserting information from One Sheet to Many by Buffulo Alice
I have a workbook with 150 sheets. My first sheet is a list of places. I would like to take that list and have each cell become fill into cell C5 in all the...
December 22nd, 2008 11:38 PM
by David Biddulph Go to last post
3 115
How can i fill horizontally? by Buffulo Alice
I am working on a rather large inventory workbook. I have a main page which compilies data from 130 sites. Each one of these sites has it's own sheet titled...
December 23rd, 2008 11:51 PM
by T. Valko Go to last post
2 84
How to match date criteria then calculate an average of matches by Buffy M. Warren
I have a spreadsheet currently containing 2 sheets, the first sheet contains raw data and several lines of information are tied to the same date which is...
November 21st, 2007 04:22 AM
by T. Valko Go to last post
5 149
lookup or match or max??? by buffyslay
hi there XL - 2000 i have a page in my workbook with the following info: Col A Col O Col P Name ...
December 8th, 2003 12:47 PM
by Dave Ramage Go to last post
2 461
F2 Enter to make Formula Work by Buffyslay_co_uk
Hi anyone got any idea on this? I have a vlookup, which is picking up data from another page in the same workbook, I have to F2 and then Enter to make...
February 2nd, 2004 05:45 PM
by Paul Go to last post
3 414
how to seperate into columns? by bufhal
Hope someone can help me. I have a text file that when I open in Excel, all the comma delimited fields are in the "A" column. I need all these records to be...
January 16th, 2006 06:35 PM
by bufhal Go to last post
3 109
Pivot Table References by Bufo
In 2000, I think you could refer to a Grand Total in a Pivot Table in another formula, copy it down, and have it be a relative reference. Now, it seems to...
December 3rd, 2003 12:59 AM
by Go to last post
2 123
How can update keep an updated balance on a spreadsheet by bug28
i have a budget setup in a spreadsheet and i cant figured how to keep a balance updated on a loan without typing in the new balance everytime
December 7th, 2007 10:24 AM
by Stephen Go to last post
1 56
Help using the 'If' function to automatically fill in other cells by Bugaglugs
I'm trying to write a formula which will generate a value in one cell dependent on what the user chooses in the other. See below for example (the worksheet is...
August 21st, 2005 11:23 PM
by Bugaglugs Go to last post
3 72
Countif using dates by Bugaglugs
In column A I have dates in the following format; 01-Apr-05 right through until the end of March 2006 On a different sheet in my workbook I want to summarise...
(Multi-page thread 1 2)
August 23rd, 2005 05:16 PM
by Bob Phillips Go to last post
11 234
how do I view excel rows in name order infirst column? by Buglebeek1
I want to view name labels in alphabetical order in that I label in the first column. How can I adjust the column after I add new names?
November 17th, 2007 02:02 AM
by Gord Dibben Go to last post
2 46
How do I format cell to 0.25 resolution? by Bugman
I would like to restrict a cell to a 0.25 resolution. (5.00, 5.25, 5.50, 5.75, 6.00, ...).
May 5th, 2008 03:25 PM
by David Biddulph Go to last post
3 100
Same header and footer in excel and word by Bugsy
I have a header that includes some special colors and border that I want to copy to excel. I can copy it as a picture and it sort of works. How do I same...
May 23rd, 2007 02:22 PM
by Bugsy Go to last post
0 52
Excel should have a formula for amortization. by BugTracker
Would be handy to have a formula or wizard for an amortization schedule. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to...
November 28th, 2005 03:23 PM
by noyb Go to last post
2 90
Post New Thread


Display Options
Showing threads 11161 to 11180 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 01:55 AM.


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