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	919
Function based on blank cell and date past due Paul	by Paul	11	1,232
IF ERROR Formula Denver	by Denver	3	782
Protected cells can't be grouped Cara	by Shane Devenshire[_2_]	1	621
Format a cell based on incremental numbers MurrayBarn	by MurrayBarn	3	586
using autofilter data edward	by Don Guillett	2	742
Adding 2weeks and rounding up to EOM Micki	by Micki	3	629
vlookup Mike	by Mike	6	567
If question tss	by Per Jessen	4	480
how do I clear #DIV/0!but leave the formula in cell bc	by Fred Smith[_4_]	3	1,391
Subtotals - is there a way to include more information on the line Acanesfan	by Dave Peterson	2	934
General Excel question dolpandotcom	by dolpandotcom via OfficeKB.com	24	1,840
Multiple sear criteria Shah Alam[_2_]	by Shah Alam[_2_]	2	458
How can I delete the rulers from my worksheet in 2007 Excel? Dee	by Sheeloo	1	2,557
select ever other line [email protected]	by Ron@Buy	1	496
SUMIF on a collection of individual cells Fred Holmes	by Fred Holmes	9	3,316
counting values ignoring duplicates matt3542	by Gary	12	1,720
CountIf question Stuck	by T. Valko	2	477
Rental yeild formula? Scoober	by Teethless mama	1	854
extract cusotmer name from test string Dinesh	by Ashish Mathur[_2_]	5	616
Macros Noxzema	by Noxzema	7	456
Autopopulating formulass horizontally? Leonhardtk	by Bassman62	4	607
Last "non-blank" value in a Row... Leonhardtk	by T. Valko	2	731
desperate.. convert to number column... triple	by Sean Timmons	1	515
One workbook with 62 worksheets Colts41	by Colts41	11	959
If statements refering to data validated ranges skimark	by Tom Hutchins	2	544
Sumif based on dates IlliniEric	by Teethless mama	3	551
Formular Function Kanmi	by Teethless mama	2	582
How to VLOOKUP in XCEL across different workbooks each named diffe kool	by kool	4	1,160
SumProduct judith	by Steve	3	513
Autofill Colour Kanmi	by Kanmi	2	438
Why is there no Freeze Panes option in the Windows drop-down box? PortNatal	by Gord Dibben	2	1,205
Re : How to lock a cell once the value is entered Andy	by Gord Dibben	2	1,618
sumproduct issues Steve	by Steve	2	646
varying a cell and seeing the outcome mikebo	by mikebo	2	716
Autofill issue Jean	by Jean	10	857
Time management OKY	by Luke M	1	619
Automatic Colour Control Kanmi	by Kanmi	0	455
How to link different worksheets into the 1 menu on a septerate sh cregs	by Luke M	1	687
Auto update between two workbooks Kanmi	by Gav123	1	1,553
Excel "Exact" Function Bryan Gnidrah[_2_]	by T. Valko	3	841
Auto update between two workbooks. Kanmi	by Kanmi	4	983
Ranking with duplication and gaps Goody	by Bernie Deitrick	5	604
Validation Data and Looking Up Cells FredK	by FredK	1	497
Max Value - based on a time period Chris26	by JoeU2004	3	1,104
auto update function from workbook to another worksheet Kanmi	by Kanmi	3	1,287
Formula to auto calculate based on other variables Scott A[_2_]	by Scott A[_2_]	8	731
Locking data between worksheets mamorellana	by mamorellana	0	527
formula to lookup data in cell NEXT to another cell TraderXL	by Ashish Mathur[_2_]	3	1,561
is there any built in function to draw lines krishnan	by Joel	2	687
Delet Duplicate Blanks rows hardeep.kanwar[_16_]	by Ashish Mathur[_2_]	6	788
Header Row with Option to Shrink/Expand Rows Beneath kippers	by Jacob Skaria	2	5,244
Lookup to return multiple matching values olssonj	by olssonj	5	777
Compare multiple columns-----siva and surya siva	by siva	0	474
How do I get the sum of vlookup? jiffy	by Jacob Skaria	3	1,986
Error result for link formula tj	by tj	4	577
Using Cell Contents to Select Worksheet with Same Name as Cell Con Alan Sexter	by Simon Lloyd[_281_]	14	2,622
HLookUp function Jbig	by Jacob Skaria	2	672
Filter by Color Chin via OfficeKB.com	by Chin via OfficeKB.com	0	654
Summarising information from different sheets in a summary sheet Naida T	by Max	2	828
Pivot table - Change default summarise value field. YY san.[_2_]	by Dave Peterson	2	1,202
Can any help with CUBESET function? Janie	by Janie	0	1,439
Formula problems that keep producing a #Value! Error!! Danny Boy	by T. Valko	10	1,564
over time in a sheet chilson	by Rick Rothstein	2	403
how can i "transfer data next row every day automatically" in XL Nisar	by Don Guillett	1	471
custom field with custom formula in pivot table! Sedaghat Nejad	by Sedaghat Nejad[_2_]	2	2,110
Conditional Formatting - Times kristy_6278	by Bernard Liengme[_3_]	1	529
? excel not generate the sensitivy, answer and limits report meke	by Bernard Liengme[_3_]	1	674
Forecast IF Error Formula Denver	by Denver	2	730
How would I eliminate the $0.00/column & keep formula Ro1	by FSt1	1	518
Pasting formats and values without formulas Rae	by Gord Dibben	3	883
Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP PJ Murph[_2_]	by PJ Murph[_2_]	3	2,146
å«æœ‰è¨ˆç®—å…¬å¼çš„æ–‡å—å¥å rg88	by rg88	0	607
General ledger spreadsheet continued Mark C[_2_]	by JoeU2004	1	1,005
sumproduct with partial charcter matching Matt	by Max	3	1,232