Excel Worksheet Functions - Page 100

Thread / Thread Starter	Last Post	Replies	Views
program tab button Bhiravi	by Don Guillett	1	389
Conditional Calculation bhofsetz	by bhofsetz	3	468
Calculating Time elapsed bhomer	by Bernie Deitrick	1	610
condition formatting with formula BHOOI	by JE McGimpsey	1	504
excel function to give the area of a circle? bhoward425	by ExcelBanter AI	4	50,377
If Function BHUD	by Jason Morin	1	395
combining information from several sheets into one sheet [email protected]	by Ron de Bruin	1	318
Omit the first word from a cell contain text Bhupinder Rayat	by Roger Govier	8	1,208
Searching for codes in text strings Bhupinder Rayat	by Ron Rosenfeld	9	706
Change the text format for weekend days (Sat, Sun) Bhupinder Rayat	by Bhupinder Rayat	3	688
Circular Reference... Help! Bhupinder Rayat	by Bhupinder Rayat	3	760
Finding 13 character codes in text strings Bhupinder Rayat	by Bhupinder Rayat	2	475
REmid function Bhupinder Rayat	by Ron Rosenfeld	5	524
Finding the date using the number of the week in a year Bhupinder Rayat	by Bhupinder Rayat	2	873
Keyboard Shortcut for right-click on sheet tab Bhupinder Rayat	by Bhupinder Rayat	2	6,938
IF condition using GMT and BST times Bhupinder Rayat	by Bhupinder Rayat	4	1,260
Link excel comments to cells Bhupinder Rayat	by Mike H	1	1,735
Validation Procedure with a worksheet change event Bhupinder Rayat	by Bhupinder Rayat	2	622
using a cell's reference to return a value. Bhupinder Rayat	by Max	3	778
No. of Saturdays between 2 dates Bhupinder Rayat	by Ron Rosenfeld	5	940
Using MATCH / LOOKUP to find the next highest value. Bhupinder Rayat	by FrankM	10	5,561
Interrogating cells by cell formatting Bhupinder Rayat	by Bhupinder Rayat	2	587
Not including blank fields in pivot tables Bhupinder Rayat	by John Michl	1	1,354
Extracting integers from a text string. Bhupinder Rayat	by Gord Dibben	10	1,215
How to multiple conditions to validate more than 2 conditions to . Bhuvana Govind	by Peo Sjoblom	1	1,537
Functions which can be used any number of times in excel-2003 BHUVANESWARI.P	by Bob Phillips	1	349
Please Help! Bianca	by Dave	3	421
column is hidden in normal view but not print view Bianca	by Norman Jones	2	1,365
Can anyone figure a formula for this?? Please? Bianca	by Bob Phillips	2	779
International number separator bibi	by Jon Quixley	1	688
International number separator bibi	by bibi	0	643
Array Lookup to Find Closest Date and Next Closest Date [email protected]	by RagDyer	7	2,256
Vlookup+ Select Next Earliest Value (Array formula?) [email protected]	by RagDyeR	1	738
Entering numbers to get the time biegs	by vezerid	3	357
Transposing data Biff	by Biff	3	338
Counting Dates - Not Text Biff	by Biff	0	344
Cummulative Return Biff	by Steve G	4	549
Unexpected result Biff	by Biff	5	539
Optimize simple macro Biff	by Biff	7	727
compound rate of return calculation Biff	by Biff	6	1,899
3D reference with multiple criteria Biff	by Biff	2	428
Pass an array to Rank Biff	by Domenic	12	1,564
23:00 <> 23:00 Biff	by Ron Rosenfeld	16	840
Workdays (Including Saturdays) Formula Biff	by Myrna Larson	1	554
Mirror formating changes in seperate worksheet Biff	by Shane Devenshire	1	686
VLookUP with multiple reference columns Biff	by Biff	6	1,616
Vlookup Function with Multiple Reference Columns Biff	by T. Valko	4	1,911
Sum Function w/ #DIV/0! Biff	by Ashish Mathur[_2_]	13	1,007
OR Function in VLookup Biff	by T. Valko	9	523
Unlocking Protected Cells Biff	by Gord Dibben	1	652
Or Function and #NA Biff	by Biff	2	647
Vlookup with If condition Biff	by Luke M[_4_]	1	1,207
Another rounding issue Biff	by Jerry W. Lewis	2	589
List of Names, Dates, Durations ... Biff	by Roger Govier	2	417
Restricting entry in B1 on the basis of entry in A1 Biff	by Biff	0	559
Using Index(A:A,.........) Biff	by Biff	2	569
vlookup:same lookup_value, different returns Biff	by javino	2	622
Formula for Ratios Biff	by Biff	0	435
More elegant method? Biff	by Biff	0	343
Complex countif of array elements Biff	by Biff	1	701
GET.CELL Biff	by Biff	2	6,050
Format for degrees Biff	by Biff	9	620
INDIRECT function inside AND function Biff	by andy62	3	1,290
char(160) -   Biff	by Bob Phillips	8	912
Not getting messages in OE Biff	by Biff	2	705
Explain return of #N/A Biff	by Biff	12	1,142
I need to calculate a Geometric mean Biff	by ExcelBanter AI	8	14,256
I want any date 90 days or older from current date change color Big Abalone	by Ragdyer	5	1,471
need Excel function like INDIRECT but can't open all spreadsheets Big Al	by Bob Phillips	1	394
Excel Help Needed...... Big Bad Nige	by Big Bad Nige	2	340
Rounding up/down problems ? Big Bad Nige	by Big Bad Nige	2	470
Help needed !! Look Up Table function ?? Big Bad Nige	by Max	6	503
Prefix Big Boss	by Ron Rosenfeld	4	570
printing problems Big Buck 31	by Anne Troy	1	469
Type in m/d/y in one column and have day automatically in next col Big Building 2008	by Dave Peterson	4	422