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 Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Feed text from one cell to another no cut & Paste by b2annay
Hello, I really need help. I'm trying to figure out how to create a template which has information in one worksheet that feeds into another. Can anyone help...
October 27th 04 10:57 PM
by Frank Kabel Go to last post
1 947
Using the Indirect.Ext function by henryhbb
The original reference works fine even if the source workbook is closed. Does anyone know of a way to change the reference based on a vaule in another...
October 27th 04 10:53 PM
by Frank Kabel Go to last post
1 1,105
Pasting onto filtered cells by Mediaexcel
it doesn't work! I guess the concept is similar as when trying to paste onto hidden & unhidden columns. Thanks M.E.
October 27th 04 10:29 PM
by Dave Peterson Go to last post
1 904
There should be a Refresh All feature, enabling all pivot tables . by JL1981
....within a file or workbook to be refreshed with a single click.
October 27th 04 10:22 PM
by Frank Kabel Go to last post
1 803
continuous cell function by milljaso
I am trying to create a function from a worksheet that has market data and changes every week. example: Worksheet 1 A B 1 10/15/04 250 2 ...
October 27th 04 10:21 PM
by Frank Kabel Go to last post
1 1,449
How do I create a crosstab process to determine patterns in surve. by trmzr
I need to find a function that would allow me to do the following example: If a person answers ‘Yes’ to question #1, what % of those people also answered...
October 27th 04 10:20 PM
by Frank Kabel Go to last post
1 795
How do I hide a formula message? by PHM
My formula result is #DIV/0! The cells the formula references has no value. How can I hide the "#DIV/0! ?
October 27th 04 09:44 PM
by Frank Kabel Go to last post
1 686
SUMPRODUCT CAPTURING DATA FROM ANOTHER SPREADSHEET by Carole O
Excel 2003 I have two spreadsheets within a workbook (Shift 1 and Daily Worksheet). I want to capture each category (i.e. 2-MAKE READY)in Shift 1 spreadsheet...
October 27th 04 09:36 PM
by Frank Kabel Go to last post
6 724
how do you subtract military time? example 12:00 - 07:00 = 5 hour. by Bill
how do you subtract military time? example 12:00 - 07:00 = 5 hours
October 27th 04 08:25 PM
by Niek Otten Go to last post
1 1,365
how do I get a calculation to repeat various number of times? by weelittlekim
Our compensation rates are built on "steps" and each step is 4.5% so if an employee was to get two steps I would calculate their current salary times 4.5%...
October 27th 04 08:13 PM
by Frank Kabel Go to last post
1 1,301
index match and sum by Pamela
Hello All, I have a listing of product orders in a workbook. In another workbook I want to find the product, and sum the quantity of orders I have for...
October 27th 04 08:10 PM
by Pamela Go to last post
4 2,724
How do I create a column that has a 'drop box' by Dave Simons
I would like to create a spreadsheet that contains a 'drop box' feature in certain cells that allow the user to choose from a pre-described list of values. How...
October 27th 04 07:57 PM
by Frank Kabel Go to last post
1 1,201
MIN >0 by Neil
How do I get this to tell me when column B MIN >0 =INDEX(A2:A367,MATCH(MIN(B2:B367),B2:B367,0))
October 27th 04 07:46 PM
by Myrna Larson Go to last post
4 1,034
Get cell value from 2 lists by cybersteve
Biff - that's why I posted the question here in the first place, as I tried a number of things and nothing worked. If anyone can help me I would appreciate...
October 27th 04 07:08 PM
by Biff Go to last post
1 1,350
Count cells with the red color by Collcat
Thanks for the links. I have ben trying : *=SUMPRODUCT(--(ColorIndex(A1:A100)=3))* (from xldynamic) But I get *#NAME?* as a response in my cell. What am I...
October 27th 04 07:04 PM
by Frank Kabel Go to last post
1 1,301
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? by hims
Can anyone suggest me ways to simultaneously sort and match multiple colums . The multiple columns mostly similar values with few dissimilar ones. I need to...
October 27th 04 07:03 PM
by Frank Kabel Go to last post
2 2,595
Need to sum values of columns 1 - 13 and 4 - 15 by ExcelHelp
I have many rows of data and need to sum values in the first 13 columns (col 1 - 13) and starting from the column a value first appears. For example a value...
October 27th 04 07:03 PM
by Frank Kabel Go to last post
1 1,753
copy worksheet ... formulas do not update by Datasort
I am coping a worksheet (in the same workbook) and then renaming the sheet all in vba code. There are formulas on the source sheet, and copied sheet, that...
October 27th 04 07:01 PM
by Frank Kabel Go to last post
1 1,976
Add months and adding partial monhts by Adam C
Hi - When I need to add a month, to a date. I use - =DATE(YEAR(B27),MONTH(B27)+S21,MIN(DAY(B27),DAY(DATE(YEAR(B27),MONTH(B27)+S22,0)))) However, I...
October 27th 04 06:53 PM
by Ron Rosenfeld Go to last post
2 3,741
Help!! What formula do I use? by HL
I have two columns in my worksheet. In column A I have the last name and in column B I have "active" or "inactive" Example: Column A Column B Johnson ...
October 27th 04 06:45 PM
by HL Go to last post
5 1,291
Post New Thread


Display Options
Showing threads 88481 to 88500 of 88510
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 12:34 PM.


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