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
SUM function over infinite number of sheets? by Not2Bright
Hi Folks I've currently got a workbook with 5 spreadsheets. The first sheet acts as a summary sheet and totals up the values in cell A1 in each of the...
October 28th 04 02:35 AM
by Dave Peterson Go to last post
1 1,257
end of worksheet question by olmedic
I have made a kindof daily log in excel. How can I get the worksheet to automatically creat a new identical page when I reach the end of the current page. if I...
October 28th 04 02:01 AM
by Dave Peterson Go to last post
1 843
VLOOKUP Pls help!!!! by Jim
Hi i just started off with VLOOKUP function but it doesn't seem to work , i want ot have the basic understanding of how it functions? Example A B...
October 28th 04 01:50 AM
by Gord Dibben Go to last post
7 883
formula simplification by Todd
I am using an if statement and wondering if I can simplify it. I think I can remember being able to group ifs. Like If(v113;x113;z113<>""),"Y","N") instead...
October 28th 04 01:49 AM
by Dave Peterson Go to last post
2 954
using a reference in vlookup with excel 2003 by Gord Dibben
Don Mayhaps the 223995 in J4 has an extra space before or after. Try clearing J4 and re-typing the number. Gord Dibben Excel MVP On 26 Oct 2004 22:41:22...
October 28th 04 01:27 AM
by Gord Dibben Go to last post
0 918
A formula to check differrent cells by Carlsbad
Thanks in advance, I'm new to this site, but I'm learning. I should have left an example of the formula I'm currently using. IF('Calculations'!C8>=1,'Daily...
October 28th 04 01:19 AM
by Carlsbad Go to last post
0 1,089
Conditional Sum by Gos-C
Yes! It worked. Thank you Myrna :) -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile:...
October 28th 04 01:18 AM
by Gos-C Go to last post
0 859
Conditional Sum by Gos-C
I entered: =SUMPRODUCT((REPLACE(REPLACE(A9:A933500,1,1,""),3,4,"")="LR"),(B9:B33500>"31-Dec-03"+0),(L9:L33500)) Column A contains eight-character record...
October 27th 04 11:20 PM
by Myrna Larson Go to last post
1 790
Please help create a formula by JuliaC
Hello. I need to create a formula that will find the amounts on a spreadsheet that add up to a particular total. Can someone...
October 27th 04 11:12 PM
by Paul Corrado Go to last post
3 863
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 1,031
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,222
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 996
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 879
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,517
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 872
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 753
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 787
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,435
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,428
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,888
Post New Thread


Display Options
Showing threads 88481 to 88500 of 88519
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 11:20 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.