Excel Worksheet Functions - Page 892

Thread / Thread Starter	Last Post	Replies	Views
Copy rows from one worksheet automatically, ignore rows that are b Kris	by Kris	2	896
Help with Function Helpmeeee	by Sean Timmons	5	689
how to split cells Rockbear	by Rockbear	6	480
Compare and copy/paste Rockbear	by Rockbear	1	329
multivariate regression John	by Jerry W. Lewis	1	739
lookup function?? Atishoo	by Atishoo	2	330
reference to worksheet fails if row deleted GISJane	by Sean Timmons	7	831
=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B 4),(VLOOKUP(B4,B RWD715	by RWD715	9	887
drop down list autocomplete mikelmendit	by Spiky	6	1,276
look up functions? Kelly	by Sheeloo[_2_]	4	363
Help with VBA in Excel 2007 harwookf	by harwookf	2	639
Lookup Using Part of a Text Rod	by Teethless mama	1	562
Lookup data in a variable table & retrieve data from a pivot table Shawna	by Max	3	1,777
sumif and translate annual hours into weekly quarter hours se7098	by T. Valko	23	1,998
Change Font Color Based on Conditional Formatting tj	by Pete_UK	8	2,365
Vertical worksheet tabs in 2003 mmccoog	by mmccoog	3	875
How can I show the current file name in a cell. Patrick	by Héctor Miguel	3	861
Count occurance of a leter in a text string justaman	by justaman	3	735
Trying to average the top ten lists from several people Eddie L.	by Sheeloo[_2_]	1	409
=INT(0+(1-0+1)*RAND()) wtf? Robert Blass	by Robert Blass	4	528
Dynamically changing cell's formula CW[_2_]	by Gary''s Student	1	762
paste link malfunction antony	by antony	0	348
erase dates over 1 year mblhmlbrldll	by Gary''s Student	4	427
Interest Earned?? over time? Robert Blass	by Fred Smith[_4_]	6	579
count for numbers one and < another in a row of cells bobselff	by T. Valko	9	553
Sum the number of days between dates by Month GavinD	by GavinD	16	1,021
RANDOM NUMBERS? Robert Blass	by Robert Blass	4	375
ENCRYPTION in excel? Robert Blass	by Chip Pearson	1	482
templates 2003, drawing tools in 2007 TTJ	by TTJ	0	837
Matching Values Ed[_4_]	by Ed[_4_]	1	365
How do I refer to cell in another worksheet in a formula Jim	by Harry Hockenlocker	2	874
keyboard shortcut to move between protected worksheets Joe	by Joe	2	720
HOW DO I TURN SPREADSHEET HORIZANTAL? tlf	by JNW	2	461
Exporting to excel from NotePad Hardeep_kanwar[_2_]	by Peo Sjoblom	2	1,086
Premium Solver does not work with Vista OT	by Peo Sjoblom	2	1,000
My Apologies For An Incorrect Date On My Computer Danno	by Danno	0	477
row selecting climate	by climate	3	400
How do I link all worksheets so that a chg in one will change all MarciaPhx	by Sheeloo[_2_]	1	459
Password required in VBA to open the sheet Tia[_3_]	by Tia[_3_]	2	758
Worksheet function needed Euan Ritchie	by Teethless mama	4	413
Copying a formula JFO	by Bernard Liengme	2	407
Using a template with an automatic Number Systen gigglygover	by nexor63	4	330
adding subject when emailing with macro BIGBOY1974AA	by Mike H	1	462
IRR Lookback and Solver Scott M	by Dana DeLouis	6	6,604
Hide formulas that = 0 Sandy	by Roger	10	838
Formula printing in cell Doehead	by T. Valko	6	373
creating a pivot table from 4 pivot tables phyllis W	by phyllis W	0	458
Input dollar amount into a cell that updates another cell and more Bill	by Bill	7	548
Why can't I see the colored fills in Excel normal view? Shirley	by T. Valko	3	400
Changing the format of a phone number scr	by scr	2	527
INTERMIDIATE VALUE OF A CURVE (PRECISION 1 MICRON) HARSHAWARDHAN. S .SHASTRI[_2_]	by MartinW[_2_]	13	850
Consolidate Lists from Multiple Sheets on another Sheet Lemmesee	by Lemmesee	9	643
Manipulating ranges in a different excel file Lenchik	by Sheeloo[_3_]	3	547
Search For A Column Width in Conditional Formatting ml	by Sheeloo[_3_]	3	623
Getting the Sum from months noreaster	by Noreaster	6	473
tenure Janice Reid	by Doehead	14	2,735
Search and replace Rockbear	by Rockbear	0	453
changing the Duplicate entries Nitin Kapoor	by Stefi	1	391
lookup database ellebelle	by Pete_UK	3	482
How to extract anitials from an email adresse? Tippo22	by Tippo22	4	554
SUMPRODUCT arguments Chris T-M	by Bob Phillips[_3_]	3	1,001
Contitional Formatting - Can I Make One Cell React To A Range? IanC[_2_]	by Bob Phillips[_3_]	1	483
Validation Formula only worked once. Rick Arends[_2_]	by Max	2	453
Identifying and totaling up duplicate cells in Excel Paul	by Paul	2	903
Totaling functions in Excel SueL	by SueL	2	440
Problem w/vlookup Sandy	by John C[_2_]	5	568
Simultaneously use VLOOKUP and HLOOKUP in EXCEL 2003 Nicky	by Nicky	3	1,046
SumIf conditional to date range IlliniDan	by IlliniDan	5	1,448
how to change one valuta ex. doller to euro Frost	by Sheeloo[_3_]	1	1,656
Countif based on two criteria MJKelly	by MJKelly	4	696
Automating search and replace Wellman	by Sheeloo[_3_]	2	413
Adding suffix to column entries NCdesigner	by NCdesigner	5	2,315
Hyperlink imported data into worksheet with dated formate Derro	by Derro	0	668
VLOOKUP with a Named Range argument modernminstrel	by John C[_2_]	1	765
How do I unprotect a spreadsheet? Sofiya	by John C[_2_]	1	710