Excel Worksheet Functions - Page 6

Thread / Thread Starter	Last Post	Replies	Views
using duplicate function RB[_2_]	by GS[_2_]	17	1,501
Round Function Philosophy [email protected]	by Harlan Grove[_2_]	17	848
Need to fix macro to list data underneath each other jeannie v	by jeannie v	17	953
VBE Help, when linked value change, color will not JVANWORTH	by JVANWORTH	17	1,178
Strange calculation in PivotTable Angus	by Roger Govier	17	899
replace all function - excel 2003 Rob	by diaare	17	1,674
Format and DDE..................Bet this can't be done. sonicscooter	by T. Valko	17	1,070
Count Unique Values Averitt Engineer[_2_]	by Bernd	17	1,559
To have this formula work with numbers & Text ='T(INDIRECT("'"& Fin Fang Foom	by Fin Fang Foom	17	1,114
Will excel generate one-tailed confidence intervals for Poisson distribution? Dora Smith	by Jerry W. Lewis	17	2,861
Data table function maestro	by Bruge	17	1,050
Referencing last cell Jean	by Alan	17	1,357
Formula for a 4 day work week tamarade	by T. Valko	17	3,301
Macro-I think Inspector	by Inspector	17	1,053
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	7,995
Time in Minutes Karen	by David Biddulph	17	953
Simpler Formula ... 2nd lowest value? Ken	by Ken	17	973
How to extract right-most word? [email protected]	by T. Valko	17	3,588
Is there a formula to capture data between "Tabs" on a spreadsheet Dan the Man[_2_]	by Pete_UK	17	971
Long formula Sandy	by Sandy	17	1,223
Changing function name in formula kittronald	by kittronald	17	1,468
to CONCATENATE from the smallest date with at least 2 criteria Andri	by Andri	17	1,508
Count filled cells in range if they are one after the other lopina	by T. Valko	17	1,345
Logical Test: Text Against Number rslaughter5	by Joe User[_2_]	17	1,377
Combine sheets into one Eva	by GS[_6_]	17	2,384
how do i replace #n/a in a vlookup? infinite1013	by [email protected]	17	4,173
Calculating age of death Annie	by ExcelBanter AI	17	8,304
Counting unique entries across two or three columns [email protected]	by Harlan Grove[_2_]	17	1,377
Dates smooney	by Harlan Grove[_2_]	17	1,017
macro help [email protected]	by [email protected]	17	818
Informational Search zoomzoom632	by T. Valko	17	834
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,977
How to read the value of a cell Hell-fire[_3_]	by Max	17	1,175
Data validation with a fixed amount of decimal places [email protected]	by [email protected]	17	2,440
How do I delete everything after a / in a column? henderson	by Harlan Grove[_2_]	17	4,069
Formula not working Excluxe	by T. Valko	17	1,325
SUMIF with AutoFilter Gustavo Strabeli	by Arvi Laanemets	17	1,511
Number of Staff per Hour Clocked in Sean	by Sean	17	896
Function Key for Calculating Average? robin	by Epinn	17	2,749
Return Numerical Label for LAST value Subtracted to reach Sum Target Value Sam via OfficeKB.com	by Ron Rosenfeld	17	2,083
How to insert a value in one cell into many cells Thomas	by Max	17	2,098
problem with =isnumber(match(right(... Luke	by Bob Phillips	17	1,345
Calendar Array-formula [email protected]	by [email protected]	17	862
SUMIF Function Inside SUMPRODUCT Function Abdul Waheed	by Domenic	17	3,046
Locate and retrivie data in table/matrix stefan7219	by Dave Peterson	17	980
last number array from string Michael	by Harlan Grove	17	1,562
two worksheet linking MINAL ZUNKE	by Mangesh Yadav	17	1,191
Problem With Reference Update Egon	by Dave Peterson	17	2,073
3rd friday in month [email protected]	by [email protected]	17	1,681
Still need help brandyda	by Gord Dibben	17	913
how do i get a list of different formulas CHICOALLEN	by Bob Phillips	17	1,136
How can I enter 8 digits in excel (eg 19710625) and get it to dis. Moira	by Ron Rosenfeld	17	1,390
Looking up values in a table LesLdh	by jwh	17	1,086
Geo average Stephen	by Harlan Grove	17	1,161
Sumif Rainfall Kay	by Kay	17	1,368
Formula Problem - interrupted by #VALUE! in other cells!? Ted	by Roger Govier	17	4,001
nested if function Louise	by Niek Otten	17	926
Interest Functions dwe	by Bruno Campanini	17	1,956
Does EVALUATE( ) still exist in V. 2003? Epinn	by Epinn	17	798
How can I find the greatest possible sum within 12 months? A newbie... [email protected]	by [email protected]	17	1,040
sumif to return an intersection? EllenG	by Franz Verga	17	1,279
Create multiple sheet tabs from multiple cells. Robert Maddox	by Gord Dibben	17	1,729
Excel Vlookup Problems Help! Hero_honda	by Hero_honda	17	950
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,466
returning header row as a result... mj	by mj	17	1,186
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,181
Selecting Last Sheet Bonbon	by Bonbon	17	2,200
SumProduct with criteria list Sige	by Sige	17	1,740
Reference milkman	by Max	17	746
Match formula bob	by Max	17	883
Need help with this formula... Dan B	by Bob Phillips	17	976
Converting Dates to 8 digits jermsalerms	by Pete	17	1,282
My Formula Changes on it's own? EARL	by Max	17	1,116
Complicated If Then / V Lookup / Match Statement... ryesworld	by Ron Coderre	17	2,046
listing data without blank rows Shooter	by Dannycol	17	1,876