Excel Worksheet Functions - Page 1045

Thread / Thread Starter	Last Post	Replies	Views
Identifying non-returning formula (blank Cell) Vibeke	by Pete_UK	9	638
COnfidence Intervals in Multiple Regression FredZack	by Jerry W. Lewis	4	1,426
Sumproduct error caused by too many curly brackets? Romileyrunner1	by Ashish Mathur[_2_]	7	1,000
dispay numbers as minutes and seconds in excel neilandko	by David Biddulph[_2_]	2	2,161
Time lines, Gantt charts and auto-populating cells: possible? Karl	by Karl	0	1,305
Preventing data input until a particular cell is used R	by Susan	3	560
Macro help: moving specific cells based upon content Scheetsky	by Don Guillett	7	923
XIRR versus IRR help! Seth M	by JoeU2004	6	3,083
Search for number after specific text in string AMH	by AMH	8	626
Create new sheet for each row and include header Sabosis	by Don Guillett	1	949
Coloring the row and column numbering bars in Exce2003 arasan77	by Kassie	2	670
Convert worksheet string name to date format in cell Sabosis	by Sabosis	2	1,244
Need reference for max and [#this row] functions SCC	by Shane Devenshire[_2_]	1	853
Need different formula in table cells SCC	by SCC	2	505
ISERROR on GETPIVOTDATA Sarah (OGI)	by Shane Devenshire[_2_]	1	1,274
Need reference for max and [#this row] function SCC	by SCC	2	519
formula help needed stevenkeen	by Shane Devenshire[_2_]	2	404
count hemusta	by Shane Devenshire[_2_]	3	420
Is it possible to sort data within a password protected worksheet Romileyrunner1	by Romileyrunner1	0	557
SORT DATA ON A PROTECTED WORKSHEET! Romileyrunner1	by Romileyrunner1	2	602
Average Calculation Munchkin	by JP Ronse	4	653
VLookup with 2 criteria Meredith	by Ben Webman	6	1,186
Extend the number of arguments of a function JP Ronse	by JP Ronse	9	651
linking data from 2 wrksheets using a common cell value jmasterton	by Sean Timmons	3	671
E-mail Addresses Won't Hyperlink in Excel 2007 Gretchen	by Gord Dibben	5	1,339
Why won't target cell data changes trigger formula evaluation? laura_in_abq	by Gord Dibben	3	1,212
Combine and display values in range in 1 cell but skip blank cells Swiss	by Swiss	3	1,312
MRound Formula LauraLee	by Shane Devenshire[_2_]	3	639
Combining If, Vlookup in formula HR_Payroll	by Shane Devenshire[_2_]	2	564
Finding last used column ken	by ken	7	416
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS NewBee@excel2007[_2_]	by JLatham	7	920
How do I group text from cells into categories bseeley	by Shane Devenshire[_2_]	3	954
Vlookup CARFL97	by Hardeep Kanwar	3	486
Search for specific text within last non blank cell in a range Bevo	by Bevo	2	1,033
Question on my Case of grouping the SW Blue Fish[_2_]	by winnie123	1	630
copy an exact formula without changing cell reference Vidal	by pshepard[_2_]	1	1,743
Coloring the row and column numbering bars in Excel 2003€ arasan77	by bill kuunders	2	622
page break with auto sub total Sudipta Sen[_2_]	by Sudipta Sen[_2_]	0	1,273
Obtain Middle vlaue of text with unknow length Abdul Shakeel[_2_]	by Teethless mama	3	582
Conditional Format based upon if statement and max CARFL97	by T. Valko	11	1,613
List Management ??? Daphtg	by Shane Devenshire[_2_]	2	455
SUM only Cells where there is text in Another cell MCook	by Ashish Mathur[_2_]	1	460
index, sumproduct, or other JustBreathe	by Ashish Mathur[_2_]	3	592
Complex SUM vsoler	by JP Ronse	4	506
Vlookup Match Problem Hardeep Kanwar	by JP Ronse	5	641
Total numbers in column where the row cell matches the search crit Kane	by Jacob Skaria	1	570
max-ing excel out Tami	by Gord Dibben	3	518
I am using a macro and it cancels my formula Nelly	by Don Guillett	3	512
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" MAHMOUD	by T. Valko	5	1,506
List Management Question- Combining into one Daphtg	by Shane Devenshire[_2_]	2	479
How do I make GRID LINES print LIGTHER dee	by Shane Devenshire[_2_]	3	5,194
Complex SUM *** Variant of previous post vsoler	by Shane Devenshire[_2_]	8	745
Netwrokdays in VBA fi.or.jp.de	by Shane Devenshire[_2_]	1	552
Two columns Data Validation and Password Recovery Khalil	by Shane Devenshire[_2_]	1	667
In Office 07, how do I format my pivot table data? Razzberryzing	by Debra Dalgleish	1	575
Unique Footer for each page in worksheet with a page number Keys2thecitY	by Keys2thecitY	0	789
Wild Cards in Vlookup Hardeep Kanwar	by pshepard[_2_]	3	612
Getting a cell to state 1 thing if another cell states something Crimzon07	by Jacob Skaria	1	709
Unique values ksel	by Harlan Grove[_2_]	1	457
Fixing the date format in a macro or VBA Geoff B	by Sam Wilson	1	1,677
Sub total Sudipta Sen[_2_]	by Sudipta Sen[_2_]	0	496
Total Gratuity Leave Please help Tia[_3_]	by pogiman via OfficeKB.com	3	695
RANDBETWEEN Jerm	by JE McGimpsey	15	1,290
Particulars data Filter from sheet 1 to sheet 2 automatically Sudipta Sen[_2_]	by Shane Devenshire[_2_]	4	983
cursor mvmt w/in Excel 2007 using arrows Chris	by Chris	4	948
Stock Maintence Sudipta Sen[_2_]	by Shane Devenshire[_2_]	2	500
referencing a range in Sumproduct function caroline	by T. Valko	6	476
SUMPRODUCT across several sheets Sonny	by Sonny	5	977
text in linked cell (between workbooks) wont transfer Niamh	by Niamh	0	456
checking two different cells Stefan - AW	by DonkeyOte[_3_]	1	564
Format painter maltagirl	by maltagirl	0	563
How to reference entire worksheet in new worksheet mmonti	by mmonti	0	1,686
Saving TODAY function to keep the date accurate. (when it was done) donuts	by Niek Otten	2	479
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1? grateful	by grateful	14	1,327
Deleting Rows with a macro based on a date value Max2073	by Max2073	2	756