Excel Worksheet Functions - Page 81

Thread / Thread Starter	Last Post	Replies	Views
Search for multiple criteria, and return yet another JMG	by Ron Coderre	5	1,885
minimum value in a column, which row no? Darius	by T. Valko	6	1,885
Non-contiguous range and Sumproduct to average Mifty	by T. Valko	5	1,884
cannot use ISEVEN or ISODD functions in Conditional Formatting Scott Paine	by Scott Paine	6	1,884
convert time imported as text to time format for calculations batfish	by batfish	3	1,884
Pivot Tables - Text From Source Being Truncated Kathie	by Debra Dalgleish	1	1,884
Keep text matching a wildcard spec in replace/substitute Hershmab	by Hershmab	3	1,883
Excel 2003 - Help writing a formula to get time (w, d, h, m) Lady_Aleena	by Glenn	21	1,883
automatic carriage return Tbledsoe	by L. Howard Kittle	3	1,883
Insert new ROW if cell equals value Jeremn	by Jeremn	6	1,883
How to stop "Synchronized Scrolling" in Excel Workbook comparing sagorb	by Dave Peterson	1	1,883
negative log Ebotoks	by Jerry W. Lewis	2	1,883
freeze pane option not available dave f	by Gord Dibben	1	1,883
Pulling cell information from one workbook to another Quinci	by Quinci	3	1,882
Formula in DCounta Criteria dcwood57	by dcwood57	12	1,882
How do I count frequency based on 2 criteria (including month) RS	by RS	18	1,882
How do I get the filter mode to show the good row count? vera	by vera	2	1,882
Change colour of Text if number in cell exceed limit Lewis Koh	by Rowan	2	1,882
How do I duplicate a sheet 20 times in an excel spreadsheet danzil	by Gord Dibben	4	1,882
sum the current month tleehh	by tleehh	2	1,882
Can I create a line graph based on a formula Damo447	by Jon Peltier	2	1,881
I want to generate random times (every couple of hours) for dates Daniel Hartman	by Gary''s Student	1	1,881
Cross referencing with VLookup ? Steve	by Steve	10	1,881
NOT equal to Neon520	by Claus Busch	9	1,881
sumproduct returns zero vacation	by vacation	7	1,881
Using the Indirect function with a sheet number instead of a sheet name JDB	by JDB	5	1,881
Need Help for win, loss, tie score sheet Parillamaster	by Pete_UK	1	1,881
Points Ranking Formulas Cabo Wabo Jim	by Max	22	1,881
Calculating my work hours minus lunch break and then adding forweekly total [email protected]	by Alfred Heiligenbrunner	2	1,880
Drop Down/List w/Code and Definition, only code entered when selec Spiritdancer	by Debra Dalgleish	2	1,880
Using SUM & VLOOKUP together?? Steven	by T. Valko	1	1,880
how do i remove unwanted AutoRecover exceptions? Ree	by Ree	0	1,880
sumif with a lookup formula Chas	by T. Valko	4	1,880
HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES? suec4	by Richard Buttrey	1	1,880
convert "15000" to "Fifteen thousand" in excel cell? anurag	by Niek Otten	1	1,880
How to divide array formula? Guntars	by Héctor Miguel	2	1,879
Product Function in Pivot Tables from Multiple Consolidation Range bbishop222	by bbishop222	0	1,879
Signature question ElaineT	by martincrow	1	1,879
Excel-only average cells if two cells in same row, meet two condit Eulie-Denver	by Bob Phillips	5	1,879
ALTERNATIVE TO SUMPRODUCT NEEDED Rog	by Rog	26	1,879
how do i calculate the difference in time? Roze	by Silver Lady	15	1,879
use more than 7 if condition in a cell Montu	by [email protected]	8	1,879
Sum (throw out highest and lowest) Timothy Garrison	by minyeh	3	1,879
How do I compare two Excel columns of numbers and see non-matches Tcom	by George Nicholson	1	1,879
How do I import/convert tab delimited text files into Excel? jim	by Jim	10	1,878
LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT? dperalta	by M Kan	3	1,878
excel formula to convert lat/lon degrees to DDD MM SS.SS? cbm	by Paul B	1	1,878
Using (SUM(IF(FREQUENCY....to determine unique values Ivor Davies[_2_]	by Herbert Seidenberg	2	1,878
SUM UP DIFFERENT CURRENCIES Irfan	by Irfan	4	1,878
Can a function return a Null (blank ) value? Maybe a custom functi colin_e	by colin_e	2	1,878
How to arrange worksheets in alphabetical order? Rohit Rathi	by royUK[_20_]	2	1,878
Excel formula timestamp for a data entry of a referenced cell jmasaki	by Max	1	1,878
Count up each day of the week mmartens12	by Bob Phillips	10	1,878
create blank/empty cell - don't want a zero to be plotted in chart GJS001	by Ashish Mathur[_2_]	6	1,877
dropdown value from range in other sheet mango	by Dave Peterson	11	1,876
=amtinwords() Master	by Gary''s Student	1	1,876
create a top 10 list of sales figures Davidy	by macropod	4	1,876
Dialog box upon opening workbook Anthony[_5_]	by Anthony[_5_]	13	1,876
SUM until blank cell JasonUT	by Aladin Akyurek	1	1,876
Setup Purchase Order Template to have a automatic number system? LynnB	by LynnB	2	1,876
Excel 2010 countifs for date range puck1263	by Spencer101	4	1,876
Insert subtotal in a query database Excel 2007 Scotty Tibbs II	by Ashish Mathur[_2_]	3	1,875
how to get name of worksheet in a workbook? ramsdesk	by Frank Kabel	2	1,875
I want to enter a figure &excel makes last two digits decimals Jude	by Gord Dibben	4	1,875
DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE LoriK	by Frank Kabel	1	1,875
Wat formula shuld i use to find the details in the cell? Cloud Strife	by Glenn	25	1,875
Cell borders and fill Marietta	by Debra Dalgleish	4	1,875
How can I write an if-then formula for 0 or less than 0 in cell t. Baz1	by JE McGimpsey	1	1,874
Countdown days In Excel with conditional formating JR[_2_]	by Otto Moehrbach[_2_]	2	1,874
Copy/paste data across filtered rows jday	by Peo Sjoblom[_3_]	1	1,874
Daily compound interest Karen	by Fred Smith[_4_]	2	1,874
Sharepoint Linked File Causing #Value Error PatK	by PatK	3	1,874
JIS / ASC Functions in Excel 2007 JC3	by NickHK	3	1,874
Auto Fill days of the month (not including weekends) John Krsulic[_2_]	by Peo Sjoblom	6	1,874
Macro Request: Fill in empty cells with previous Filled cell in column Artis	by bj	2	1,874