Excel Worksheet Functions - Page 39

Thread / Thread Starter	Last Post	Replies	Views
Using MATCH / LOOKUP to find the next highest value. Bhupinder Rayat	by FrankM	10	5,566
lookup in ta tabel with ttwo variables Palle korsholm	by Ron Coderre	10	1,009
Lost columns in formated text (space delimited) save Jeff Clark	by Dave Peterson	10	1,166
sum formulas based on date Jia	by T. Valko	10	762
Where am I going wrong? - Date type function. mr tom	by Tyro[_2_]	10	1,090
Formula gives unwanted result jeannie v	by jeannie v	10	834
COUNTING DAYS WITHIN A PERIODE Jan T.[_3_]	by Ron Coderre[_2_]	10	853
IF function JP	by T. Valko	10	781
Date Formula Brooke	by Ron Rosenfeld	10	774
Count within a Range Q Sean	by Bob Phillips	10	775
Average Cells in Multiple Worksheets Karen	by Teethless mama	10	1,130
counting blocks of 1's Bryan De-Lara	by Bryan De-Lara	10	1,110
aconcat UDF throwing a #NAME error Josh Rogers	by Josh Rogers	10	1,681
IF formula help - incorporate greater than & smaller than Aaron Hodson \(Coversure\)	by PCLIVE	10	1,619
Date help please Terry	by Terry	10	595
Embedded If Limitation Gaffnr	by Bob Phillips	10	738
Nesting sumif functions JT	by Max	10	957
Populate Order worksheet from Quote worksheet Veronica Johnson	by JP[_4_]	10	968
Do I use "IF" or something else? klg	by Tyro[_2_]	10	574
Cell reference within array [email protected]	by Lori Miller	10	1,583
Indirect reference causes statistical function to throw up a #NUM! JoCa	by Lori	10	845
Rounding Of Concatenated Costs Field Caldo	by Caldo	10	989
Autofill issue Jean	by Jean	10	841
Formula problems that keep producing a #Value! Error!! Danny Boy	by T. Valko	10	1,533
Sumproduct with blanks EZ[_2_]	by EZ[_2_]	10	985
sumproduct/sum not working with multiple variables Nelson	by Teethless mama	10	952
does any one know to copy cells within an IF statement in Excel DonE	by Gord Dibben	10	982
Summing Values/Outputs of IF formulae shadesoflife	by T. Valko	10	734
"copy" hsfnwa	by JLatham	10	706
Returning an array of unique values? Blue Max	by Blue Max	10	985
Countif range contains part of a value antwaan	by Glenn	10	2,128
Insert a cell value into a link to another worksheet. bsharp	by bsharp	10	1,400
Conditional Formatting Using Min/Max CE	by T. Valko	10	1,601
Calculate # days from today in a Pivot Table Orrin	by ryguy7272	10	1,920
How does on report site bugs for the newsgroup sites to microsoft? Shane Devenshire[_2_]	by Gord Dibben	10	790
find in reverse smw	by jaf	10	1,059
Matching columns and removing duplicates Adam	by Adam	10	1,040
Deleting LF Characters in cells BillH	by Dave Peterson	10	1,000
How to show sheet tabs in Microsoft Excel Shenda	by Don Guillett	10	1,515
summarize data from one spreadsheet to other spreadsheet sa02000	by JonR	10	2,049
Date referencing Barry Clark	by Barry Clark	10	775
Date and Text in one formula CarolineHedges	by Franz Verga	10	931
How to SUM #N/A Looking-for-a-brainiac	by Franz Verga	10	1,980
Dissecting the contents of a cell Doug	by Ron Coderre	10	868
how can i use concatenate to create a linking formula? DRandolph	by Biff	10	1,266
Counting Function MAB	by Kevin Vaughn	10	822
Averages from 2 columns Deb Pingel	by Domenic	10	1,008
Daily Totals on a summary sheet Allewyn	by JOUIOUI	10	1,740
formula for a # in a column of #'s that's closest to a certain val Don	by Domenic	10	655
Sum cells based on a row variable and seperate column variable CheeseHeadTransplant	by Deeds	10	1,891
copy and paste code problem bigdaddy3	by bigdaddy3	10	1,087
How do you convert text to rows? Shannyduck	by Morrigan	10	935
Extend series using ref cell formula transposed Gnomie	by ejscrib	10	1,402
Please help with formula Eamon	by Mangesh Yadav	10	966
How can I look up data in a different workbook in an excel spread. DoctorG	by TheDude	10	1,615
business days between 2 date feilds JRS	by Biff	10	1,808
How do I use a pivot table value to reference a worksheet neoschenker	by JulieD	10	1,530
Concatenate cells, replacing blanks with cell contents from other rows [email protected]	by [email protected]	10	967
If with Vlookup Looping through	by Carim	10	856
Excel 2007 Not Responding Terri	by [email protected]	10	1,311
Worksheets Tabs ub	by David McRitchie	10	911
INDIRECT Agent Ting	by pshepard	10	826
Count consecutive occurances [email protected]	by Robert Dunham	10	973
Need Sumif help.... Dan B[_2_]	by Toppers	10	690
Can this be done in Excel? Zilla[_2_]	by Debra Dalgleish	10	641
Why doesn't the INDIRECT function work when nested in FREQUENCY? Philip J Smith	by T. Valko	10	1,130
Can it be done Luke Dallman	by Luke Dallman	10	1,569
How to hide/unhide sheet Tabs in Excel 2007? Smibes	by Grant[_2_]	10	2,999
Converting Dates to Weeks Kurt	by nsv	10	1,708
Combining information from multiple tabs [email protected]	by BobS9895	10	1,077
get a count from multiple lookups andy62	by Max	10	1,007
adding conditional rows Deepak Varde	by Bob Phillips	10	786
1,4,1,3,3,1,2=1,4,3,2 bridgerbell	by Max	10	574
Return Row Number of LAST Numeric Consecutive Duplicate in Column Sam via OfficeKB.com	by Sam via OfficeKB.com	10	1,069
index match offset? denise	by Biff	10	1,368