Excel Worksheet Functions - Page 3

Thread / Thread Starter	Last Post	Replies	Views
SUMIF with 2 conditions JBoyer	by T. Valko	22	1,746
Allocating Intergers based on Relative Percentage Jim Thomlinson	by JoeU2004	22	1,699
Divide by the minimum non-zero number in a range of cells Opus	by JoeU2004	22	3,104
Microsoft Responds to the Evolution of Online Communities [email protected]	by GS	22	2,615
Bob P. and Roger G. -- IF(and(...IF(OR( vs. IF(Boolean Epinn	by Epinn	21	1,802
Array help Part 2 driller	by Max	21	1,656
Copy line if Kcope8302	by Kcope8302	21	1,809
average of 5 mrbob16	by Spiky	21	1,378
If Then Dilemma Excel Confused	by JMB	21	1,814
how to count easily dribler2	by dribler2	21	1,448
How do I show only the whole number w/o eliminating four decimals? kell~0	by wizman	21	2,725
Sum totals based on product name jana	by T. Valko	21	2,516
days of the week formulas Bob	by Bob	21	1,649
Concatenate values IF() Nikki	by Ron Rosenfeld	21	1,390
Need Period After Initials Susan	by Susan	21	2,318
Average a list with high and low ignored Shu of AZ	by T. Valko	21	3,229
"IF" Function Boblink	by Boblink	21	1,463
adding numbers with letters [email protected]	by Rick Rothstein \(MVP - VB\)	21	2,020
Counting Civette	by Pete_UK	21	1,128
Alphanumeric hardeep via OfficeKB.com	by T. Valko	21	1,479
countif on cells with formula's won't work correctly JusMe	by JusMe	21	2,716
Date + 365 in New Column ace214	by Sandy Mann	21	1,795
The 4th column D to be filler. Steved	by ryguy7272	21	1,156
Using VLOOKUP with a reference to a different file... beeblemonster	by Peo Sjoblom[_2_]	21	5,540
How can I extract the second half of addition ? Gilbert DE CEULAER	by Bernd P	21	1,652
One of lifes little mystery? JethroUK©	by PBalmanno	21	1,319
COUNTIF problem with NOW() Spreadsheet	by SteveG	21	1,414
Copying forumla for vlook up but changing the column Index # klafert	by Biff	21	2,069
VBA function for "Mean" using Array as argument ASokolik	by vandenberg p	21	5,999
BIN2DEC conversion for large binary numbers ahmedmidany	by ExcelBanter AI	21	11,811
Excel 2003 - Help writing a formula to get time (w, d, h, m) Lady_Aleena	by Glenn	21	1,881
3D Ranges David	by David	21	1,793
date from sheet name JBoulton	by T. Valko	21	1,631
trying to write a formula ivolving data validation melben	by mangesh_yadav	21	1,468
Copy cell format to cell on another worksht and update automatical kevinm	by paul	21	5,175
Averages and Counts from different columns sonofroy	by sonofroy	21	1,557
Referencing another workbook using a variable for the sheet? Doug	by Doug	21	2,625
Searching for text within formula kittronald	by kittronald	21	2,329
sumif with or C Glenn	by C Glenn	21	1,629
Countdiff with more criteria JP Ronse	by T. Valko	21	3,466
IF AND OR functions Rondia	by Bearacade	21	1,319
Adding Round funciton to handful of numbers Jamie	by Bernd P	21	1,614
An oddity if not a bug Harlan Grove	by Harlan Grove	21	1,420
SumIf query ... muchacho	by muchacho	21	1,438
Need help with Countif function Mary-Lou	by Mary-Lou	21	1,549
IF just STOPS WORKING Gee	by JoeU2004	21	1,964
calculate a formula instead of returning text Jonrey	by Harlan Grove	21	1,605
Count Blanks in a Filtered Column Gos-C	by Aladin Akyurek	21	2,055
count colored cells? DKY	by [email protected]	21	2,554
Decimal to 24 hour clock please. Steved	by Steved	21	2,025
Vlookup from 2 different sheets WorkerBee	by Ken Wright	20	3,073
Return horizontal and vertical values karl	by T. Valko	20	1,685
Get Data From Closed Workbook Minitman	by T. Valko	20	3,321
SumProduct but sometimes don't test some criteria Aaron	by Rick Rothstein \(MVP - VB\)[_121_]	20	1,181
Return Min & Max value of Conditional Formatted cells Sam via OfficeKB.com	by Domenic	20	1,943
Intersection point return data tvtime	by Biff	20	3,275
Count the number of unique Numbers in a column ajajmannen	by Domenic	20	1,616
Removing Rows for Printing Frick	by Ron de Bruin	20	2,373
How many similar functions can be put in one cell? Forrest	by Ron Rosenfeld	20	1,778
vlookup function return all values j2thea	by Domenic	20	1,878
lookup more than one cell andrewm	by mangesh_yadav	20	2,313
How do I validate data from another validation cell? Bo	by Max	20	1,944
Updating master workbook from source that may/may not exist [email protected]	by Dave Peterson	20	3,382
SMALL(IF( across multiple worksheets Fin Fang Foom	by Fin Fang Foom	20	1,560
copy a list and skipping blanks Art	by Art	20	1,481
Suming Cells that contain text data Wayne	by T. Valko	20	1,752
vlookup formula Gemz	by Gemz	20	1,247
Modifying only the worksheet when draging down a cell reference [email protected]	by Max	20	1,476
Date Conversion Formula Needed Titanium	by Titanium	20	1,508
Tricky IF/Then Date based formula needed Titanium	by Titanium	20	1,328
My Final #DIV/0! that I'd like to say Goodbye to! Dan the Man[_2_]	by Harlan Grove[_2_]	20	1,213
Showing Top 30 with array-formula? [email protected]	by Dave Peterson	20	1,727
COUNTIF in between rows Vasilis Tergen	by Vasilis Tergen	20	2,306
Find a range of values in a range of cells Jack Taylor	by Ron Coderre	20	2,274
Focus David Unger	by Harlan Grove	20	1,780