Excel Worksheet Functions - Page 169

Thread / Thread Starter	Last Post	Replies	Views
formula that strips the first letter of the first name in a cell Cluce	by Mike H	4	916
Function based on blank cell and date past due Paul	by Paul	11	1,219
IF ERROR Formula Denver	by Denver	3	770
Protected cells can't be grouped Cara	by Shane Devenshire[_2_]	1	614
Format a cell based on incremental numbers MurrayBarn	by MurrayBarn	3	575
using autofilter data edward	by Don Guillett	2	730
Adding 2weeks and rounding up to EOM Micki	by Micki	3	619
vlookup Mike	by Mike	6	563
If question tss	by Per Jessen	4	469
how do I clear #DIV/0!but leave the formula in cell bc	by Fred Smith[_4_]	3	1,388
Subtotals - is there a way to include more information on the line Acanesfan	by Dave Peterson	2	923
General Excel question dolpandotcom	by dolpandotcom via OfficeKB.com	24	1,828
Multiple sear criteria Shah Alam[_2_]	by Shah Alam[_2_]	2	449
How can I delete the rulers from my worksheet in 2007 Excel? Dee	by Sheeloo	1	2,549
select ever other line [email protected]	by Ron@Buy	1	494
SUMIF on a collection of individual cells Fred Holmes	by Fred Holmes	9	3,313
counting values ignoring duplicates matt3542	by Gary	12	1,706
CountIf question Stuck	by T. Valko	2	466
Rental yeild formula? Scoober	by Teethless mama	1	854
extract cusotmer name from test string Dinesh	by Ashish Mathur[_2_]	5	606
Macros Noxzema	by Noxzema	7	446
Autopopulating formulass horizontally? Leonhardtk	by Bassman62	4	601
Last "non-blank" value in a Row... Leonhardtk	by T. Valko	2	716
desperate.. convert to number column... triple	by Sean Timmons	1	502
One workbook with 62 worksheets Colts41	by Colts41	11	959
If statements refering to data validated ranges skimark	by Tom Hutchins	2	530
Sumif based on dates IlliniEric	by Teethless mama	3	538
Formular Function Kanmi	by Teethless mama	2	570
How to VLOOKUP in XCEL across different workbooks each named diffe kool	by kool	4	1,147
SumProduct judith	by Steve	3	508
Autofill Colour Kanmi	by Kanmi	2	433
Why is there no Freeze Panes option in the Windows drop-down box? PortNatal	by Gord Dibben	2	1,201
Re : How to lock a cell once the value is entered Andy	by Gord Dibben	2	1,614
sumproduct issues Steve	by Steve	2	638
varying a cell and seeing the outcome mikebo	by mikebo	2	713
Autofill issue Jean	by Jean	10	854
Time management OKY	by Luke M	1	616
Automatic Colour Control Kanmi	by Kanmi	0	452
How to link different worksheets into the 1 menu on a septerate sh cregs	by Luke M	1	686
Auto update between two workbooks Kanmi	by Gav123	1	1,549
Excel "Exact" Function Bryan Gnidrah[_2_]	by T. Valko	3	831
Auto update between two workbooks. Kanmi	by Kanmi	4	983
Ranking with duplication and gaps Goody	by Bernie Deitrick	5	600
Validation Data and Looking Up Cells FredK	by FredK	1	484
Max Value - based on a time period Chris26	by JoeU2004	3	1,093
auto update function from workbook to another worksheet Kanmi	by Kanmi	3	1,275
Formula to auto calculate based on other variables Scott A[_2_]	by Scott A[_2_]	8	723
Locking data between worksheets mamorellana	by mamorellana	0	522
formula to lookup data in cell NEXT to another cell TraderXL	by Ashish Mathur[_2_]	3	1,553
is there any built in function to draw lines krishnan	by Joel	2	675
Delet Duplicate Blanks rows hardeep.kanwar[_16_]	by Ashish Mathur[_2_]	6	770
Header Row with Option to Shrink/Expand Rows Beneath kippers	by Jacob Skaria	2	5,232
Lookup to return multiple matching values olssonj	by olssonj	5	765
Compare multiple columns-----siva and surya siva	by siva	0	463
How do I get the sum of vlookup? jiffy	by Jacob Skaria	3	1,979
Error result for link formula tj	by tj	4	565
Using Cell Contents to Select Worksheet with Same Name as Cell Con Alan Sexter	by Simon Lloyd[_281_]	14	2,610
HLookUp function Jbig	by Jacob Skaria	2	660
Filter by Color Chin via OfficeKB.com	by Chin via OfficeKB.com	0	651
Summarising information from different sheets in a summary sheet Naida T	by Max	2	814
Pivot table - Change default summarise value field. YY san.[_2_]	by Dave Peterson	2	1,193
Can any help with CUBESET function? Janie	by Janie	0	1,436
Formula problems that keep producing a #Value! Error!! Danny Boy	by T. Valko	10	1,552
over time in a sheet chilson	by Rick Rothstein	2	400
how can i "transfer data next row every day automatically" in XL Nisar	by Don Guillett	1	461
custom field with custom formula in pivot table! Sedaghat Nejad	by Sedaghat Nejad[_2_]	2	2,096
Conditional Formatting - Times kristy_6278	by Bernard Liengme[_3_]	1	517
? excel not generate the sensitivy, answer and limits report meke	by Bernard Liengme[_3_]	1	662
Forecast IF Error Formula Denver	by Denver	2	717
How would I eliminate the $0.00/column & keep formula Ro1	by FSt1	1	511
Pasting formats and values without formulas Rae	by Gord Dibben	3	867
Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP PJ Murph[_2_]	by PJ Murph[_2_]	3	2,143
å«æœ‰è¨ˆç®—å…¬å¼çš„æ–‡å—å¥å rg88	by rg88	0	607
General ledger spreadsheet continued Mark C[_2_]	by JoeU2004	1	999
sumproduct with partial charcter matching Matt	by Max	3	1,224