Groups

Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

microsoft.public.excel.worksheetfunctinos

1–30 of 43

0 selected

Unknown Soldier, … Rich/rerat7

3/5/08

SORTING BETWEEN WORKSHEETS

Unknown Soldier, Try the following macro after you do the following: 1. On Sheet 1 & 2 Place the

unread,

SORTING BETWEEN WORKSHEETS

Unknown Soldier, Try the following macro after you do the following: 1. On Sheet 1 & 2 Place the

3/5/08

Richard, … NoodNutt3

2/23/08

Depending on what you are going to do after you have selected your range 10:250 you might consider

unread,

Depending on what you are going to do after you have selected your range 10:250 you might consider

2/23/08

1/29/08

SUMIF or SUMIFS

Here is what I have Col A Col B Col C 1310 3 3463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3

unread,

SUMIF or SUMIFS

Here is what I have Col A Col B Col C 1310 3 3463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3

1/29/08

1/28/08

text to the left and right of

I have a list of file names (Music), the format is "Beatles - Yellow Submarine" in cells a1

unread,

text to the left and right of

I have a list of file names (Music), the format is "Beatles - Yellow Submarine" in cells a1

1/28/08

tbraddy, roth...@gmail.com2

12/4/07

Data Selection and Averaging

Start 30 =offset($b$200,30,) End 60 =offset($b$200,60,) Average =average(offset($b$200,30,,60-30)) Of

unread,

Data Selection and Averaging

Start 30 =offset($b$200,30,) End 60 =offset($b$200,60,) Average =average(offset($b$200,30,,60-30)) Of

12/4/07

Richard, www.exciter.gr: Custom Excel Applications!2

10/28/07

i dont know if this suits you, it is not sumif but it works =SUM(A1:A6)-COUNTIF(A1:A6;">8

unread,

i dont know if this suits you, it is not sumif but it works =SUM(A1:A6)-COUNTIF(A1:A6;">8

10/28/07

bao...@my-deja.com, JW2

9/20/07

What function returns the sheet name?

On Aug 6, 1:12 am, bao...@my-deja.com wrote: > Oh sher, I know I can always parse CELL("

unread,

What function returns the sheet name?

On Aug 6, 1:12 am, bao...@my-deja.com wrote: > Oh sher, I know I can always parse CELL("

9/20/07

melvin....@gmail.com

9/19/07

count with two criterias

I need a formula that will count the the number of rows that meet the criteria from two different

unread,

count with two criterias

I need a formula that will count the the number of rows that meet the criteria from two different

9/19/07

9/5/07

Using IF & AND and getting #NAME?

To determine if a date falls within a time period, I created this function, but keep getting #NAME?

unread,

Using IF & AND and getting #NAME?

To determine if a date falls within a time period, I created this function, but keep getting #NAME?

9/5/07

8/2/07

CopyFromRecordset Problem

Here is the code piece... With ThisWorkbook.Sheets("XX XX") .Range(.Cells(4, 2), .Cells(

unread,

CopyFromRecordset Problem

Here is the code piece... With ThisWorkbook.Sheets("XX XX") .Range(.Cells(4, 2), .Cells(

8/2/07

7/20/07

Combine two worksheets into PivotTable

I have one worksheet with employee numbers as the rows and product catagories in the columns. That

unread,

Combine two worksheets into PivotTable

I have one worksheet with employee numbers as the rows and product catagories in the columns. That

7/20/07

Epoh Rio, D Hilberg2

7/8/07

Error with Four Item Conditional Statement

Change Sheet1!2 to Sheet1!F2 both places in the final IF. On Jun 18, 1:09 pm, Epoh Rio <epohxc...@

unread,

Error with Four Item Conditional Statement

Change Sheet1!2 to Sheet1!F2 both places in the final IF. On Jun 18, 1:09 pm, Epoh Rio <epohxc...@

7/8/07

6/20/07

Data from Pivot table breaks

Basically I have a tab that I pull in data from a pivot table. When I copy out a sheet to a new

unread,

Data from Pivot table breaks

Basically I have a tab that I pull in data from a pivot table. When I copy out a sheet to a new

6/20/07

5/4/07

list, search, and display

Name Test Grade RACE Peter 89 B BLACK Jason 74 C WHITE Tom 98 A ASIAN John 56 F WHITE Susan 86 B

unread,

list, search, and display

Name Test Grade RACE Peter 89 B BLACK Jason 74 C WHITE Tom 98 A ASIAN John 56 F WHITE Susan 86 B

5/4/07

5/4/07

How to identify if value is trending up or down

I have a row of values M1—M2—M3—M4—M5—M6—M7  M12 123—201—52—75—244—277—288—etc I'm trying to

unread,

How to identify if value is trending up or down

I have a row of values M1—M2—M3—M4—M5—M6—M7  M12 123—201—52—75—244—277—288—etc I'm trying to

5/4/07

4/26/07

recalculating excel paste value

hi everybody - does anyone know whether the paste value command causes the formulas in the cells to

unread,

recalculating excel paste value

hi everybody - does anyone know whether the paste value command causes the formulas in the cells to

4/26/07

Richard, merjet2

4/6/07

formula a value in a formula

Yes. Let X be your formula w/o the 1st =. Then =IF(X>6, X-0.5,X) will do what you want. Hth,

unread,

formula a value in a formula

Yes. Let X be your formula w/o the 1st =. Then =IF(X>6, X-0.5,X) will do what you want. Hth,

4/6/07

Richard, … Don Guillett4

4/1/07

TESTING A RANGE OF CELLS

No formula Sub checklist() For Each c In Range("b2:b10") On Error Resume Next x = Range(

unread,

TESTING A RANGE OF CELLS

No formula Sub checklist() For Each c In Range("b2:b10") On Error Resume Next x = Range(

4/1/07

Richard, JE McGimpsey2

3/29/07

Take a look at the "The difference between relative and absolute references" topic in the

unread,

Take a look at the "The difference between relative and absolute references" topic in the

3/29/07

3/27/07

array function instread of IF

this question was answered at http://groups.google.com/group/microsoft.public.excel/browse_thread/

unread,

array function instread of IF

this question was answered at http://groups.google.com/group/microsoft.public.excel/browse_thread/

3/27/07

mahadev...@gmail.com

3/12/07

Use of OFFSET function

Hi, I have two workbooks (Book 3 and Report 3) where Report 4 is heavily linked to Book 3. In Report

unread,

Use of OFFSET function

Hi, I have two workbooks (Book 3 and Report 3) where Report 4 is heavily linked to Book 3. In Report

3/12/07

1/19/07

Vlookup on partially sorthed lists

Hi, I am using a vlookup function without the false argument on a list (2400 items) that is mostly

unread,

Vlookup on partially sorthed lists

Hi, I am using a vlookup function without the false argument on a list (2400 items) that is mostly

1/19/07

ant...@swbell.net

1/4/07

Index Match lookup formula causes #N/A error ... sometimes

Hello, I have a file A with a list of item numbers in column A and corresponding quantities in column

unread,

Index Match lookup formula causes #N/A error ... sometimes

Hello, I have a file A with a list of item numbers in column A and corresponding quantities in column

1/4/07

sonyaw...@gmail.com

12/21/06

How do prevent duplicate numbers in a range of validated cells?

I have a validation rule for a series of cells. The 3 cells are only allowed to have a value of 3, 5,

unread,

How do prevent duplicate numbers in a range of validated cells?

I have a validation rule for a series of cells. The 3 cells are only allowed to have a value of 3, 5,

12/21/06

Joe Farruggio, Ivyleaf2

12/18/06

excell macro calls spreadsheet function

On Nov 21, 8:29 am, Joe Farruggio <jfar...@optonline.net> wrote: > Hi > I have written a

unread,

excell macro calls spreadsheet function

On Nov 21, 8:29 am, Joe Farruggio <jfar...@optonline.net> wrote: > Hi > I have written a

12/18/06

aj_g...@yahoo.com

11/16/06

cell updating question

Sorry know this is pretty basic stuff here I think. I have a formated price sheet called sheet A

unread,

cell updating question

Sorry know this is pretty basic stuff here I think. I have a formated price sheet called sheet A

11/16/06

pwi...@global-aero.com, AndrewArmstrong3

11/10/06

Returning Text from a group of cells based on the value of another cell

Cheetah, What happens at the limits of the range, for example 1500? I assumed next class higher. Also

unread,

Returning Text from a group of cells based on the value of another cell

Cheetah, What happens at the limits of the range, for example 1500? I assumed next class higher. Also

11/10/06

rsch...@gmail.com

11/2/06

How would I create a formula that uses 'User input' as the criteria to find the designated

unread,

How would I create a formula that uses 'User input' as the criteria to find the designated

11/2/06

alecgreen, Karitaat2

10/17/06

Rounding up & down

Alec, 5 * INT((X + 2.5) / 5) That rounds 872 to 870; 874 to 875 but 1056 to 1055 (and NOT 1060) Hope

unread,

Rounding up & down

Alec, 5 * INT((X + 2.5) / 5) That rounds 872 to 870; 874 to 875 but 1056 to 1055 (and NOT 1060) Hope

10/17/06

jorda...@gmail.com, demec...@yahoo.com3

10/4/06

find text from one column in another

jorda...@gmail.com wrote: > Or, a simple IF/search formula would work, but I can't get that

unread,

find text from one column in another

jorda...@gmail.com wrote: > Or, a simple IF/search formula would work, but I can't get that

10/4/06

Search

Clear search

Close search

Google apps

Main menu