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
Change View SIze on all Worksheets at once by Brent
Is there a way to change the View size (200%-25%) on all the worksheets in your workbook at one time. I use both Mac and PC platforms but when going from one...
March 24th, 2004 08:14 PM
by Vasant Nanavati Go to last post
1 524
Worksheet formula - auto populate by Brent
I have a workbook containing (2) worksheets. Worksheet 'A' contains various calendaring info. I use this to keep track of what schools I visit on what date,...
April 5th, 2009 09:22 PM
by Brent Go to last post
4 67
PMT function by Brent
I can't ever seem to get the payment function to calculate properly. I am entering an $80,000 loan with and interest rate of 8% payable over 5 years. This is...
February 11th, 2009 07:41 AM
by joeu2004 Go to last post
2 68
Help: Formula for calculating Baseball League Age? by Brent
Ok, I have been playing with excel for quite a while now and have been able to calculate a persons age. But, I have been unable to calculate a persons...
January 27th, 2007 11:38 PM
by David Biddulph Go to last post
4 124
Formula to sum every 4th cell returns #DIV/0! error in some column by Brent
I use this formula to sum the values in every fourth cell in colums =SUMPRODUCT((MOD(ROW(E7:E190),4)=3)*(E7:E190)). This works in about half of the colums, but...
March 16th, 2006 08:20 PM
by Domenic Go to last post
5 90
Variable criteria formula by Brent
Column 'A' contains 2-digit codes (i.e. LB, BA, BB, etc.). Column 'C' contains dates (mm/dd/yy format) Column 'L' contains mileage figures. Attempting to...
February 28th, 2006 06:48 AM
by Biff Go to last post
4 146
Need formula or Function to sum value of every other cell in a col by Brent
Hello, I have a need to sum the values in every other cell, and sometimes every third cell, in a column or row. Thanks -- Brent
January 17th, 2006 09:07 PM
by David Billigmeier Go to last post
2 78
Lookup by Brent
I would like to type a value on one page of my worksheet. Then have a function in the column next to the value that looks up the value typed in and references...
January 2nd, 2006 08:32 PM
by PowerWheels Go to last post
2 58
Can you copy multiple tabs from formulas to values w/o paste spec? by Brent
I have a workbook consiting on several tabs which I want to copy into a new workbook as values only instead of copying over the formulas. Is there a way to do...
October 27th, 2005 12:47 AM
by Brent Go to last post
2 171
VLOOKUP 2 text columns by Brent
I am looking up data from one worksheet. Colunmns A B C 1 smith Joe ...
September 30th, 2005 03:05 AM
by D Hilberg Go to last post
5 128
Create Formula for calculating Little League Age... by Brent
Some of you may be aware, Little League has changed the date in which they use to calculate the players age for the spring season beginning the spring of 2006....
September 21st, 2005 01:19 AM
by Ron Rosenfeld Go to last post
1 114
FINANCIAL FUNCTIONS by Brent
I have created a worksheet to compute future value for various investments using different rates of return and then showing the net return after taxes in...
(Multi-page thread 1 2)
September 9th, 2004 12:43 AM
by Brent Go to last post
13 302
Automatic greenbar effect, varied color, corrects with re-format by Brent -- DNA
Would like automatic stripe effect in choice of fill color which updates when columns or rows are deleted as opposed to filling entire worksheets with color...
February 11th, 2006 07:05 PM
by Anne Troy Go to last post
1 104
M=1000 by Brent Becker
I need to have Excel 97 to look at a cell with the letter C or M in it and put the numerical value in another cell. i.e. m=1000 c=100 Thanks
May 20th, 2004 10:04 PM
by Bob Phillips Go to last post
2 85
excel storing previous cell values in memory by Brent Bortnick
When a value is entered into a cell, you can move to the cell beneath it and start to type the same value. Excel will recognize the value being similar and...
April 19th, 2006 09:00 PM
by CarlosAntenna Go to last post
2 89
Format Cols by Brent E
I've got an Excel workbook that contains many license numbers and I need to format the column so that if a license number has several 0s in front, they aren't...
April 29th, 2005 02:46 AM
by Max Go to last post
2 72
If Statement Criteria by Brent E
Good afternoon, I am trying to assist somebody at work. I would like to ask if there is a way to set a formula in a totals cell at the bottom or a...
May 12th, 2005 12:13 AM
by Michael Go to last post
2 78
searching a workbook by Brent Zirbel
Is there a way to search an entire workbook for data instead of going into each page and doing a search? It gets kind of old going into each page and doing a...
September 2nd, 2004 01:22 AM
by Gord Dibben Go to last post
2 87
create "IF" formula ? by Brent05Redfire
I am trying to figure out how to add two cells on the same row if a cell to the right is true. I have a list of projects listed numerically by job number and...
September 23rd, 2009 04:40 PM
by T. Valko Go to last post
3 99
Rolling figure to a cell by Brenton
I am trying to calculate a rolling figure to a cell by updating a spread sheet on a weekly basis. I want to input data on a dated row and get the formula to...
September 19th, 2008 05:36 AM
by Brenton Go to last post
2 135
Post New Thread


Display Options
Showing threads 10201 to 10220 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:08 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.