A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Error bars by alex
I wish to add different error bars to each and every point in my graph. How do I do it? In particular I want to show the error of my dependent variable y. ...
January 6th 10 03:46 AM
by B. R.Ramachandran Go to last post
1 595
Why doesn't excel count function update automatically? by nlb1
I have a row of data that I would like to have "total" at the end of the row in Column "T". The formula should count all of the non-blank cells in the range...
January 6th 10 03:33 AM
by T. Valko Go to last post
1 3,263
Conditional formating by Garyp1961
Hello All, I would like to know how to format a cell where it will give me the number 1 when I enter any type of data in a different cell. Example I enter...
January 6th 10 03:07 AM
by T. Valko Go to last post
3 407
Formula Help by Mike
In CH5:CH65 I have names, Now in CL5:CL65 i want to enter these names if greater than THERE values=hours in CJ5:CJ65 by 28
January 6th 10 02:45 AM
by Sheeloo Go to last post
1 315
ascending sort definition [sorting alphabetically] by GaryBlade
Does ascending sort mean A-Z?
January 6th 10 02:42 AM
by Sheeloo Go to last post
2 1,541
unable to get the pivotfields property of the pivottable class by dhstein
In an Excel macro to create a pivot table, I am suddenly getting this message: unable to get the pivotfields property of the pivottable class. This used to...
January 6th 10 02:27 AM
by dhstein Go to last post
0 1,510
pivot table rolling 12 month filter? by Randy Suggs[_2_]
Is there a way to add a rolling 12 month date filter for 'last 12 months' to a pivot table? I see how to add conditional filters like last year, last month,...
January 6th 10 02:09 AM
by Bernie Deitrick Go to last post
1 1,796
Zoom and view settings reverting after download from a website by Kurt
I have an issue with the view settings that are saved into Excel documents. I know that the document saves the way you’ve chosen to view it, so if others...
January 6th 10 01:54 AM
by Kurt Go to last post
0 484
How do I create a list based on another list? by David G[_2_]
The second list is based on the first, but only if the items meet a certain value. I do not want blank cell or N/A in the second list.
January 6th 10 12:17 AM
by zvkmpw Go to last post
1 1,495
nesting functions to compare segments of two columns by PPease
In Excel I would like to nest functions to make the formula =MAX(OFFSET((ADDRESS((MATCH(I1,F1:F8000)),6)):(ADDRESS((MATCH(I2,F1:F8000)),6)),0,1)) The part...
January 5th 10 11:39 PM
by zvkmpw Go to last post
1 376
Name of the Day by Raz
1. if I add one to the Date it gives me date of the next day. How do I do it for the days? Example: 04-Jan in cell A1, on A2 I have =A1+1 gives me 05-Jan if...
January 5th 10 11:33 PM
by T. Valko Go to last post
2 284
Can I use & export data & sheets between Excel 2003 & 2007 by SDinSD
I have excel 2003 on the office computer - I want to interchange & work on my workbooks on my new laptop - do I need to install 2003 on the laptop to insure...
January 5th 10 10:59 PM
by Dave Peterson Go to last post
3 283
excel passwords by biff
Are Excel passwords easy to crack? We have a spreadsheet that we forgot the password for and was wondering if we could get into it. How secure are Excel...
January 5th 10 10:56 PM
by Gord Dibben Go to last post
8 419
Build link to an other excell doc by danielh
Hi! I've managed to link fileds to an other excell document. IE. ='C:\Page1'!A1 But now I'm trying to build a link so that it updates with a new year every...
January 5th 10 10:53 PM
by Dave Peterson Go to last post
1 318
Combining multiple spread sheets into one by flaschman
I have individual week spread sheets needing to be combined into one form for year report. This is weekly contributor reporting that needs to be an individual...
January 5th 10 10:50 PM
by Gord Dibben Go to last post
2 297
Change multiple worksheets at one time to print in color by Sundance
For some reason I have to go through and change each worksheet individually to print in color. Then I can select all of the worksheets to print and it...
January 5th 10 10:34 PM
by Gord Dibben Go to last post
1 2,632
what does "% B/A" mean? by MMcGovern
In an excel sheet for sales projections, there is a column that states % B/A. Can anyone please assist as to what this means?
January 5th 10 10:25 PM
by Bob I Go to last post
3 1,595
CONVERT A .DBF FILE TO AN EXCEL SPREADSHEET by Francois from RI
I have a .dbf file and I need to convert it to an excel spreadsheet.
January 5th 10 10:24 PM
by Bob I Go to last post
2 642
January 5th 10 10:01 PM
by Gord Dibben Go to last post
6 557
Validation Data using Validation Table cell range..... by Dermot
I have included a few additional empty cells in my list so I can add a few more names in the validation drop down list.....not sure if this...
(Multi-page thread 1 2)
January 5th 10 09:35 PM
by Dermot Go to last post
16 1,801
Post New Thread


Display Options
Showing threads 10001 to 10020 of 146459
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 On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:11 AM.


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