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
If Than Statement by Xfree
I was not sure on a descriptive Subject for this so I used If Than statement due to if I were using Crystal Reports that is how I would do this: I pulled...
November 12th 08 09:53 PM
by Xfree Go to last post
3 283
split print area in excel - One Page Print by Cyhill
Is it possible to print two ranges in excel to one page. For example...in my report template, I would like to print cells A164:P176,A201:P233 on one page. ...
November 12th 08 09:39 PM
by Cyhill Go to last post
3 3,264
Count with criteria by NM
Hi, I have a column B which can have input as 1, 0,a or sh. Another Column C can have input as I,D,X,M. I want to count the number of "I"s in column C which...
November 12th 08 09:26 PM
by NM Go to last post
5 313
How do I re arrange numbers by Raz
I copied and pasted a table of numbers from another file (converted a pdf to excel) that looks like this. (only 4 rows shown here) 102050903818W400 1 6 ...
November 12th 08 08:04 PM
by Pete_UK Go to last post
3 325
Help! Minimum Excluding zeros across multiple sheets by [email protected]
Hello all - I want a minimum value EXCLUDING Zeros. This formula: =SMALL(A1:A10,1+COUNTIF(A1:A10,0)) Would work great if I was working with one worksheet -...
5 1,296
Second Saturday Of The Month by FrankM
OK, this may seem fairly simple but I'm missing something ... Is there a formula that will calculate the Second Calendar Saturday of the Month for me?
(Multi-page thread 1 2)
November 12th 08 07:35 PM
by Ron Rosenfeld Go to last post
11 1,228
What's causing error message? by Jim Tibbetts
Hello all, The formula: =ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4) returns the cell address (G2) of the largest number in B2:AY2 correctly. The formula:...
November 12th 08 07:13 PM
by Peo Sjoblom[_2_] Go to last post
4 412
Referencing an active cell's content from another sheet. by emon
I need help. I'd like to be able to manually scroll down column A of worksheet 2 and populate cells on Sheet 1 accordingly. How can this be accomplished?...
November 12th 08 06:54 PM
by emon Go to last post
2 452
copy a cell value based on search of another cell by Pendal
I have a worksheet that has two sheets to it on sheet A i have a list of product codes and the name of an image that goes with them on sheet B i have a...
November 12th 08 06:33 PM
by Pete_UK Go to last post
1 519
multiple ranges, transposing? by Mea
I start with a list like this company carries 101 INDUSTRIES BRASS LIGHTING...
(Multi-page thread 1 2)
November 12th 08 06:33 PM
by Herbert Seidenberg Go to last post
19 577
Conditional format entire row from one cell by Shanie
I see examples for this where the cell is a numerical value, but I need to do this where the cell is a person's name. I have 2007 and I went to CF - new...
November 12th 08 06:33 PM
by Shane Devenshire[_2_] Go to last post
2 370
cell lookup by Excel Challenged
I have a value in one cell and I would like that value to update automatically in my spreadsheet when it is changed. For instance, I have $17.00 in cell A6...
November 12th 08 06:29 PM
by John C[_2_] Go to last post
2 214
IF AND statements by bob
I'm seeking a formula for the following problem: IF G2 = "a" or "a3" or "m" or "m3" or "ftm" AND H2 and K2 are populated with any value (that is, they are...
November 12th 08 06:26 PM
by John C[_2_] Go to last post
6 365
function for accessing a database by Paul
Is there a way for a function or some other method to access fields in a database (Filemaker) for the purpose of populating cells in a spreadsheet?
November 12th 08 06:21 PM
by Paul Go to last post
2 289
SUMIF and SUM.NUMBER by Rockbear
Hi I have two sum function that work as they should, but try to set another agrument and then it fails.. First one : =ANTALL.HVIS(E:E,N2), in english i thin...
November 12th 08 06:02 PM
by Bob Phillips[_3_] Go to last post
8 595
Lookup between two books by CSmith
I have 2 seperate books, not tabs within a book. In Book A, column H is a column of short 5 digit numeric codes in each cell. Keeping within Book A, I need...
November 12th 08 05:51 PM
by Shane Devenshire[_2_] Go to last post
2 501
Pivottable calculated item - how to suppress zero? by HMallen
I have created a basic pivottable in Office 2007. It has three row labels and a sum of the value of each of the row labels. I then created a calculated...
November 12th 08 05:40 PM
by HMallen Go to last post
4 756
Numerical value of logicals by hmm
As I understand it, when logicals are used in a formula, TRUE=1 and FALSE=0. If this is so, then why is Excel evaluating the formula below as 0 instead of...
November 12th 08 05:22 PM
by hmm Go to last post
4 439
vlook up two column by Hong
Hello! I have a set of data, Part# is 1001, 1002,.... Destionation is different A(Part#) B(Destination) Date1 Date2 Date3............... 1001 Canada ...
November 12th 08 05:18 PM
by Hong Go to last post
4 455
Circular by Christine[_3_]
my worksheet shows this message at the bottom. but I dont know where's the error. what should i do? thanks
November 12th 08 04:04 PM
by John C[_2_] Go to last post
3 271
Post New Thread


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