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
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) by Red Herald
I have a sorted column of account numbers that I want to count. I don't want to count more than one occurence of an account number if it has the same work...
November 13th 08 01:11 AM
by Ashish Mathur[_2_] Go to last post
2 829
Countif with criteria by NM
Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column...
(Multi-page thread 1 2)
November 13th 08 12:57 AM
by Ashish Mathur[_2_] Go to last post
11 411
Count Function by Mickey
I need to be able to count an item if a key word is in a different columns. ex: Count the cells that contain "F17000" (Columns B & C) only if it is "Out of...
November 13th 08 12:55 AM
by Gary''s Student Go to last post
5 336
Conditional formatting if a cell contains a formula by tsbarr
I would like to apply conditional formatting if a cell contains a formula as opposed to an entered number. I would think that is doable somehow using a...
November 13th 08 12:54 AM
by Ashish Mathur[_2_] Go to last post
2 574
First Non-Blank Cell by FrankM
I found this formula somewhere else on these boards ... The VALUE of the last NON-BLANK cell in a COLUMN range =LOOKUP(2,1/(A1:A100<>""),A1:A100) .......
November 13th 08 12:33 AM
by Gary''s Student Go to last post
6 385
Query Wizard - Choose Columns by MichaelRobert
I hope that this is the correct list for questions on MS Query, and Query Wizard in particular. From Excel Import External Data and connecting successfully...
November 12th 08 11:55 PM
by MichaelRobert Go to last post
3 834
Solver by Alonso[_2_]
Hi everybody i'm trying that Solver finds the best way to schedule several machines I have a table with 15 rows (4-18) the machines and 21 columns for the 7...
November 12th 08 11:41 PM
by Dana DeLouis[_3_] Go to last post
4 546
Run data analysis by Papergal
I don't know if this is possible or not: I import data from a manufacturing process. Column A - Date Column B - Product Name I want to have a table that...
November 12th 08 11:30 PM
by Dana DeLouis[_3_] Go to last post
3 308
If 5th character="-" delete everything to the left otherwise do no by Mike R.
Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike
November 12th 08 11:00 PM
by Rick Rothstein Go to last post
6 841
Summarizing data assigned to a label by Al Davis
I have a table of information, like this one... Name Box Bag Total Red 12 8 20 Blue 3 3 6 Green 41 41 82 Red 2 19 21 Blue 16 3 19 Green 1 8 9 ...
November 12th 08 10:55 PM
by T. Valko Go to last post
2 376
how do I round a column of numbers to the nearest by Suzy
How do I round a column of numbers up or down? ei. $27.51 = $27.50 and $29.24 = $29.25?
November 12th 08 10:49 PM
by T. Valko Go to last post
3 1,327
Pivot table help by Yossy
please I want to do a calculation Individual cost/Total cost. Let say I have: A1 100 A2 20 A3 40 Total 160 Calculate for A2 = 20/160. Can I do this...
November 12th 08 09:54 PM
by Shane Devenshire[_2_] Go to last post
1 303
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 312
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,304
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 339
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 340
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,348
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,284
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 456
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 508
Post New Thread


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