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
Doing multiple borders by Herb[_2_]
How to "freeze" border menu so I can do multiple borders without losing menu each time. I think it was in 2003 Excel that by double clicking title at top of...
June 26th 09 01:52 PM
by Homey Go to last post
1 531
referencing only rows with data by Rich S.
i'm new to macros(cursor only), and i want it to create and print a graph for each row of data(about 25 columns wide). If I select the first row, how can i...
June 26th 09 01:42 PM
by Rich S. Go to last post
2 316
How do I resize a checkbox? by Nick C
I want a checkbox in Excel 2003 and am using ActiveX control checkbox function but can not make it big enough to see, What can I do?
June 26th 09 12:38 PM
by Dave Peterson Go to last post
1 800
how to create a fixture grid for 18 teams by Tom Burke
I am trying to create a fixture list for two divisions of 18 teams, where teams from the same club will always be 1 at home and 1 away on the same day. i...
June 26th 09 12:27 PM
by Tom Burke Go to last post
0 663
Save Worksheet as new workbook with specifics by Tel
Hi All, I want to give a user the opportunity to save a worksheet, which will be hidden from the user, as a new workbook. In essence I'll create a button...
June 26th 09 12:13 PM
by Tel Go to last post
0 242
Help with odd Excel behaviour - Data Validation by Colin Foster
Hi, Two issues... First one is I've applied some Data Validation to restrict data entry to values in a list (referred via Named Range) . However, whilst the...
June 26th 09 11:55 AM
by Colin Foster Go to last post
0 243
Different color on cell [newbie] by Jon
I would like that text is displayed in a different color, in the following example, with the following conditional (i.e. if it evaluates to false display...
June 26th 09 11:17 AM
by David Biddulph[_2_] Go to last post
2 344
Date by PL
I want to use the number format mmm-yy For a row I want Jan- 1998 Apr-1998 Jul-1998 Oct-1998 Jan-1999 Apr-1999 ...... In other words, I want to repeat...
June 26th 09 10:47 AM
by Fred Smith[_4_] Go to last post
2 218
change cell colour when cell data changes by Stefi
One way using CF: Create a background copy of the worksheet at each refreshment and apply CF with this formula: =A1<>background!A1 Regards, Stefi „Bec G...
June 26th 09 09:21 AM
by Stefi Go to last post
5 317
HOW TO COUNT CAPITAL LETTERS IN DATA? by arun sharma
i hv data in which some cells are n full capital letters, some are in small and some are proper, i want to see which cells are in upper case.
June 26th 09 09:12 AM
by Mike H Go to last post
1 1,341
UDF FOR DEPENDENTS by Faraz A. Qureshi
I sure am in a need of a formula to list the address(es) of dependent(s) relevant to a specific cell, existing in the currently opened workbooks so as to...
June 26th 09 05:02 AM
by Faraz A. Qureshi Go to last post
0 335
getting the min and max of a list of numbers by dal_101
I need to get the maximum and minimum values in a list of numbers, some of the cells have 0 (suppressed), and I do not want to include those, and not get the...
June 26th 09 03:24 AM
by T. Valko Go to last post
9 433
output row number for corresponding non-zero value of match functi by lkd
Hello, I have a list of items as shown below: A .5 B B .25 B .25 C C 1
June 26th 09 02:53 AM
by Jacob Skaria Go to last post
2 909
Index by Need_Help
I'm working with two worksheets. Worksheet1, in column A I have years that i use a filter on. What I want to be able to do is after I filter on the years in...
June 26th 09 02:28 AM
by T. Valko Go to last post
4 255
Sum if formula using multiple criteria by Jeremy
I am trying to create a sum if formula that takes the given in Rows B and places them in D given the Criteria in C matches that of A under the Payable,...
June 26th 09 01:35 AM
by Max Go to last post
4 353
Filtering unique combinations of cells by John T Kennedy[_2_]
I have a spreadhseet (10K+ rows) that contains Column D: First Name Coulmn E: Last Name Column F: Company Name How can I setup a filter to show only each...
June 26th 09 12:59 AM
by Max Go to last post
7 4,355
Formula needed. by FC
A B 1 car 90 2 boat 20 3 airp 22 4 car 10 5 boat 25 I'm needing a formula that will add numbers in B related to the item in A...
June 26th 09 12:51 AM
by westy Go to last post
9 430
Formulas not auto updating by Steve
I can't get any of my formulas to auto update in Excel 2007. What am I doing wrong? The formulas are entered in properly but they don't auto update. Also,...
June 26th 09 12:30 AM
by Gord Dibben Go to last post
4 2,848
Globally change an Access connection string by PJFry
I am trying to establish a UAT environment for my staff to test excel reports. These files have a number of embedded queries that use this connection...
June 26th 09 12:25 AM
by PJFry Go to last post
0 576
Trying to import a WR1 file into excel without much luck..clues? by Roget
Trying to import a WR1 file into excel without much luck..clues?
June 25th 09 11:47 PM
by Victor Delta[_2_] Go to last post
1 1,186
Post New Thread


Display Options
Showing threads 20001 to 20020 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:10 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.