Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
HOW CAN DUPLICATES BE DELETED,NOT FILTERED? naminel	by Dan	17	1,178
find a value in a table based on 2 different criteria Picman	by ~L	17	1,037
retrieve data from two columns and sort Joe	by Joe	17	1,455
Converting time to decimal format dwhapp	by dwhapp	17	1,022
How to set the formula - part 2? Eric	by Rick Rothstein	17	1,427
vLookup with dates Jodi Macy	by T. Valko	17	923
MATCH() Function and Blanks Gary''s Student	by Gary''s Student	17	1,141
Sum Indirect Using R1C1 Style Bam	by Harlan Grove[_2_]	17	4,779
Determining the text mode from a variety of data types matt3542	by RagDyer	17	1,063
Sumproduct with If Angie	by Marcelo	17	838
Calculate how much time falls between set start and stop times Polly	by Robin	17	1,953
Highest 3 in 10 Consecutive Numbers Dan	by Harlan Grove[_2_]	17	2,395
Sumif with multiple columns in sum_range dza7	by Ron Coderre	17	1,213
how to put quotation mark in each cell of the column crazyfisher	by Led_A_Muck[_2_]	17	2,514
U.S. Holidays that the date moves top.jimmy	by T. Valko	17	1,228
Concatencation and formatting Bengt[_3_]	by Ron Rosenfeld	17	963
Is there a formula for.... gueyo	by gueyo	17	757
Formula to get number of days excluding Fridays in a given period Abdul[_2_]	by Bernd P	17	1,736
Complex Count formula GoBucks[_2_]	by David Biddulph[_2_]	17	1,220
Convert text to rows Radrays	by Glenn	17	3,136
Special count.,, Flemming[_2_]	by Flemming[_2_]	17	1,038
Building Dynamic SUMIF statement Nancy Taylor	by Nancy Taylor[_2_]	17	1,038
? IF & GOTO ? Karen D	by Gord Dibben	17	1,788
How do I create multiple workbooks within one workbook Ken C[_2_]	by Gord Dibben	17	1,530
Sum of a column from nth row to end itsAchint	by T. Valko	17	1,891
How do I calculate a difference in work days? Work Days	by Gord Dibben	17	1,396
VLOOKUP not returning data in some (but not all) records Pete	by Dave Peterson	17	1,770
I need a february 29th row, but only if the day of year actually exists FatBytestard	by Rich/rerat	17	1,244
How to record time in Excel in military (0730) format? fontana	by David Biddulph[_2_]	17	2,247
Crazy Hard Function Chris	by Chris	17	949
IF then statements-Tiered PRicing Jackiec21	by Epinn	16	2,068
array formulas Nader	by Bob Phillips	16	1,199
help to build a list of holidays for 6 years dribler2	by dribler2	16	1,173
Getting around 'IF" Dr Traffic	by Don Guillett	16	845
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,524
Count unique if text Mike Fogleman	by Epinn	16	1,193
Can excel find a sequence of numbers from a known total? efandango	by efandango	16	1,518
search multiple worksheets for an item and return the Wsheets name Chris	by Chris	16	2,582
Apply green to current date, red to 2 days overdue and none if pai vpschas	by vpschas	16	1,662
Combining VLOOKUP functions Jay	by Pete_UK	16	1,599
Array constant issue Sige	by Sige	16	1,370
dos from excel vba? Jason	by Jason	16	1,944
Convert feet/inches to decimal dingy101	by Biff	16	3,351
SUMPRODUCT - Help ceemo	by SteveG	16	808
Column() to return a letter instead of a number? cKBoy	by hightide	16	1,318
Function help please! R.P.McMurphy	by R.P.McMurphy	16	877
how do I find prime factors of a number Jeff	by Ron Rosenfeld	16	3,202
Pulling a Letter from a cell and filling another cell with info nick s	by nick s	16	1,536
IF/THEN Average Problem raspywench	by Bob Phillips	16	912
Finding the average across multiple sheets quailhunter	by Fin Fang Foom	16	2,610
SumIf function nc	by Domenic	16	1,051
how do I write a formula that will figure weekly overtime? jasperPcuccumber	by CLR	16	1,680
How do I sum numbers from cells that contain text nicklissa	by Harlan Grove	16	1,630
23:00 <> 23:00 Biff	by Ron Rosenfeld	16	836
Extracting data from multiple worksheets into a list mnirula	by Peo Sjoblom	16	4,488
Sum delimited values in cell Andy Brown	by Max	16	1,176
Average of Last 10 GaryC	by Ron Coderre	16	729
Match 3 Criteria and Return Lowest Numeric Value Sam via OfficeKB.com	by Sam via OfficeKB.com	16	1,804
Searching for a value in an Array Farah	by Jaybisco	16	1,017
Round Len Function Help [email protected]	by Slashman	16	983
What function? Dipwind	by Franz Verga	16	819
If A3=alpha numeric,"X", if A3=text,"Y", Blank Gary	by Ron Rosenfeld	16	2,114
Is there a way to prevent pasting data into an Excel worksheet? Rod from Corrections	by [email protected]	16	1,478
Indirect and Dynamic Range Graham Haughs	by Biff	16	2,544
how to get formula content of a cell? muster	by Kevin Vaughn	16	5,256
Help With Formula Homerj24	by Greg Wilson	16	950
Summing HLookup Values TomCat	by Max	16	1,470
Leauge Table....Help!!! ronaldo444	by Dav	16	895
How do I display all conditional formatting in Excel? Kit	by Kit	16	2,012
Combining COUNTIF and AND functions david	by Max	16	1,311
Is this possible? phat al	by phat al	16	726
Finding the Last Working Day junoon	by junoon	16	903
Find Multiple instances of Single Criterion in Row & Return To a Single Col Sam via OfficeKB.com	by Peo Sjoblom	16	1,944
Answers needed for challenging formula Sum Limit and marking	by Ron Rosenfeld	16	1,369
formula too long, not sure how to shorten Jane	by Jane	16	1,577