Excel Worksheet Functions - Page 934

Thread / Thread Starter	Last Post	Replies	Views
Adding columns using dates, but getting wrong data Griffey5	by T. Valko	3	481
SUMIF / SUMPRODUCT PetalNyeri	by T. Valko	1	469
value of first visible cell Eddy Stan	by T. Valko	4	3,022
Advanced Filter used with merged cells? davisk	by JBeaucaire[_64_]	3	2,208
Pivot tables Suresh	by Suresh	0	579
Change from american date entry format The Fru Fru	by Gaby[_2_]	1	1,153
Index & Match Dewayne	by Max	3	370
How to Copy range of Row heights from one sheet to another in XL? Suby Mathews	by Max	1	1,041
sumproduct with duplicates in two columns MAANI	by Bob Phillips[_3_]	7	966
Printing Marianne	by LiAD	4	606
Printing LiAD	by LiAD	1	429
Automatically incrementing number for each print Nefermet	by LiAD	7	981
use date formula to update workbook in real time Michael	by Niek Otten	1	712
How Can I Unblock Registry Settings to allow .wk1 Files gbarofavn	by David Biddulph[_2_]	1	1,536
searching for a function Noha	by Pete_UK	7	529
Count occurences of a letter in a cell Jair Batista	by Jair Batista	2	501
Fill Lock! SteffenAndreassen	by Luke M	1	360
Conditional sum wizard Martin G[_2_]	by Pete_UK	1	483
Creating Spreadsheets terry	by terry	2	334
Cross Reference Formula mjsam	by Pete_UK	2	517
Help with percentages Excelnew	by Pete_UK	1	398
Automatic invoicing numbers Riaan Welman	by xlm[_2_]	2	691
Calculate the number of weeksdays based on a cell value [email protected]	by T. Valko	10	1,224
data JAY	by Gary''s Student	1	490
Get "####" when use alpha char in a cell referenced by a formula Leo	by Chip Pearson	5	603
deleting the first 2 digits of number in a cell NoviceMALGER	by Pete_UK	2	1,061
How to freeze 1 or more CELLS in spreadsheet? Bigdog	by Gord Dibben	5	683
Format cells and font by content/whether formula present LJT87	by Gord Dibben	2	508
Abrupt change in formula results using sumproduct mbeemom	by mbeemom	4	716
Formula to look up from another tab Voodoo	by Shane Devenshire[_2_]	3	983
automatic formula samus	by Gord Dibben	2	402
Arithmatic functions with date format...angry results chris23892 via OfficeKB.com	by Pete_UK	7	497
Cross Reference Formula mjsam	by Mike H	2	453
in the drop down filter box how do you increase font size? Stevie	by Gord Dibben	1	1,494
How do I get rid of expired links Dave Schreffler	by Gord Dibben	3	469
Can I create a 3-D reference from multiple workbooks Jennifer	by Gord Dibben	2	425
Function Formatting OC	by Luke M	1	333
Read-only PAL	by PAL	2	409
Conditional Formatting Formula Not Working Steve B	by Luke M	1	1,285
Execute Multiple Hyperlinks in Excel Biocellguy	by Biocellguy	0	999
'If' problem Kanga 85	by Kanga 85	7	428
help with formula Soth	by PCLIVE	6	743
Adding data from different workbooks Bev	by Luke M	3	389
I think I need to use Index, Match, and IsNumber but am confused grateful	by T. Valko	13	912
Tough problem adding cells from different sheets, in random order Darcy	by WilD	4	544
Cross Reference Formula mjsam	by JNW	1	723
conditional formating Brent	by Rick Rothstein	6	443
Cross Reference Formula mjsam	by Shane Devenshire[_2_]	1	453
Concatenated formula help JimT	by JimT	3	431
Finding questions I have posted kevan	by Pete_UK	5	603
Pivot Table - Row subtotals Alex Mackenzie	by Debra Dalgleish	3	371
Data Validation Lists Problem Steve	by Debra Dalgleish	3	348
Cell change event causing EXCEL to crash Ashish	by Ashish	3	1,319
Showing formula references in other worksheets Daz	by Daz	0	458
Indirect.EXT download dosn't exist DontPanic	by David Biddulph[_2_]	3	2,157
counting the number of attributes/numbers in a cell Mortir	by Mortir	3	329
make sumproduct lookup case sensitive PBcorn	by Pete_UK	1	738
excell'de grafik gÃ¶rÃ¼ntÃ¼ deÄŸerini artÄ±rma Ramazan	by Ramazan	0	362
Using the RANK function question. Skip	by LiAD	4	631
increment cell reference in a formula MarkW1307	by Pete_UK	3	2,049
Ranking Equal Values LiAD	by LiAD	1	584
Need help with formula WLMPilot	by WLMPilot	3	462
Format dates from English to Spanish FA	by David Biddulph[_2_]	2	2,745
IF funtion to result in cell colouring Peta	by Eduardo	1	421
Conditional formatting Q Seanie	by Seanie	2	356
Auto Ranking a 2x2 table with equal values LiAD	by LiAD	6	580
Date sensitive calculation refresh Dave_in_gva	by Dave_in_gva	7	554
Find and replace in a different cell PointerMan	by Luke M	1	724
Returning Sorted Values Kevin Mulvaney	by Pete_UK	3	447
Finding Problems in Comma Separated List Daren	by Daren	5	623
How do I calculate a difference in work days? Work Days	by Gord Dibben	17	1,403
next row formula emm	by T. Valko	7	3,545
How do I permanently remove external data connections? DOUBLEB	by DOUBLEB	0	3,065
Vlookup Richard	by Pete_UK	3	460
count entries based on criteria in a different column ccKennedy	by ccKennedy	2	768