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
Search a named range by rhhince[_2_]
I have numbers in column E8:F65500 which I named RANGE1, N8:O65500 which I named RANGE2. Column A is numbered 1 to 65500 referencing RANGE1, Column J...
August 27th 09 06:19 AM
by Lars-Åke Aspelin[_2_] Go to last post
1 390
Count with two criteria in a second worksheet by bec
I'm trying to count columns in a second worksheet. 1) If column A is = apple, then I want to count the entries in column B which are greater than "0" sheet...
August 27th 09 04:27 AM
by T. Valko Go to last post
1 275
SUM IF question (daily rainfall totals) by RedDixieCup
I have two colums of data, the first is a time date stamp (mm/dd/yyy hh:mm) and the second is a rainfall total for each entry (0.00). I need to get a daily...
August 27th 09 03:14 AM
by Fred Smith[_4_] Go to last post
9 676
Go to cell below last entry in column and total by Donna[_2_]
I am doing a macro and I would like for it to automatically go to the cell below last entry in a column and total. (row count will be different each time I...
August 27th 09 02:48 AM
by Jacob Skaria Go to last post
1 526
coefficient of determination by Jene
In the EXCEL curve fit function for a single dependant variable should the coefficient of determination be upper case R-squared or lower case r-squared?
August 27th 09 02:39 AM
by Mike Middleton[_2_] Go to last post
2 2,754
Help with Excel VBA by Howard
-- I have a spread sheet as follows: In Column B1 thru B8, I have listed names of workers. In Column C1 thru C8 are cells to hold total hours work. In...
August 27th 09 02:36 AM
by Howard Go to last post
2 307
Rolling date looking 30 Days past by Chris
I'm logging data into a spreadsheet daily and keeping track of a rolling 30 days average and 1 std dev above the average. How do I easily create a way to...
August 27th 09 02:36 AM
by Max Go to last post
2 926
Converting Text into Values by Terry Bennett
I have a column of data in which recent test results are recorded. Column A specifies the shop and in column B the data is recorded in the format 'AARAGG'...
August 27th 09 02:03 AM
by T. Valko Go to last post
6 379
Cell Referencing by Kris W[_2_]
Is there a way to reference the nearest cell above the current cell that has text - distance is always going to be variable.
August 27th 09 01:45 AM
by Charabeuh[_4_] Go to last post
5 311
Excel Template naming option..... by Turbine Mechanic
I have a question...... I used to be able to set-up an Excel template to "auto-name" the worksheet when I clicked "Save As". I had a certain cell in the...
August 27th 09 12:09 AM
by Gord Dibben Go to last post
1 514
Need Excel count of 1 word if found in multi-word cells of column by Function_Challenged
I need a function that tests whether a cell containing multiple words includes certain text. For example, test for the occurrence of the string "alarm" and...
August 27th 09 12:08 AM
by T. Valko Go to last post
1 1,867
vlookup with multiple values by David
Hello, I have 2 worksheets. One with historical rents: it has 5 columns: A B C D ...
August 26th 09 09:35 PM
by T. Valko Go to last post
3 309
CountIf Formula by Redi
Hi all, i need your help with another formula column a..column b... column c....column d green..... banana... 1 5 orange... apple...... 2 ...
August 26th 09 09:10 PM
by Sean Timmons Go to last post
1 338
Inserting curly brackets within a formula by Romileyrunner1
Hi, anyone know which key strokes are needed to insert curly brackets within a...
August 26th 09 08:59 PM
by Romileyrunner1 Go to last post
4 1,980
count the # of times "name" is in E and "x" in F are in the same r by Nielly
Not exactly sure how to describe it best. Just need a tally of the times a two different names in two different columns are on the same row. Thanks!
August 26th 09 08:34 PM
by Shane Devenshire[_2_] Go to last post
2 272
Function shows repeating decimal? by Doug
I have two colums that have simple sum and imsub formulas in them. They return a repeating number. I would like to have a simple 0.00 number in these cells....
August 26th 09 08:27 PM
by JP Ronse Go to last post
3 848
Conditionally Formatting Cells based on Values in a Range (2007) by sreid64
Hi and thanks in advance. I have 2 columns of Data, A & B. Column A is a Named Range. I would like to lookup and format cells in cloumn B if the value in a...
August 26th 09 08:15 PM
by sreid64 Go to last post
3 793
Averaging by Hookette
If I have a column of data that I got using this formula: DATEDIF(B2,C2,"m") & " months " & DATEDIF(B2,C2,"md") & " days " & TEXT(C2-B2,"hh") & " hours " &...
August 26th 09 07:28 PM
by JoeU2004 Go to last post
6 277
Ouch! Inconsistent TEXT("hh:mm") rounding by JoeU2004
I have recommended using --TEXT(...,"hh:mm") to ensure that the resulting time value is identical to the binary form of the displayed time value. But...
August 26th 09 07:21 PM
by JoeU2004 Go to last post
0 331
vlookup cells thAT are `NOT EQUAL` to a value / text by Romileyrunner1
Hi , I`m currently using the following formula fine: =AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89="W")*($AB$10:$AB$89>-10),$AB$10:$AB$89)) This then selects only...
August 26th 09 07:08 PM
by Romileyrunner1 Go to last post
4 2,641
Post New Thread


Display Options
Showing threads 10001 to 10020 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:11 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.