Excel Worksheet Functions - Page 48

Thread / Thread Starter	Last Post	Replies	Views
drop down JS[_3_]	by Ernst Schuurman	9	347
cell referencing problems when sorting data am	by D Zandveld	9	610
Calculations with date fields Cassidy1	by David Biddulph[_2_]	9	621
Why does Concatenate formula show but not produce a cell result? Tom@WardAir	by chelle12	9	4,144
Masking out characters in a cell dnardi	by Rick Rothstein \(MVP - VB\)	9	5,008
cell value based on combo box entry rdwngr23	by rdwngr23	9	1,918
Creating a list of job numbers, missing out irrelevant items DDawson	by Max	9	693
Excel should allow clicking on a linked cell to jump to source Hayk	by ilia	9	929
Convert State abbreviations color coded cell exceluser	by exceluser	9	2,395
getting XL to recognize lower from upper case in IF formula stef	by stef	9	931
Lookup value based on 2 cell values BorderMaster	by T. Valko	9	2,356
How can I add down a list a specified number of cells? porbeagle	by David Biddulph[_2_]	9	546
Overlaping conditions....may be Gaurav[_2_]	by Gaurav[_2_]	9	495
Find next occupied row up in another column Greg Lovern	by T. Valko	9	637
#Value Being Returned for Blank or Non Zero Value Jack	by RagDyeR	9	616
Formatting dollar values in text LabrGuy Bob R	by Pete_UK	9	740
Old DOS to Excel ? Steve	by Steve	9	450
Extracting duplicates with row ref's to a list Mac	by Max	9	368
INDEX FORMULAS & MULTIPLE TABLES Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	9	760
Conditional Formats to Find Words in Text String Daren	by Ashish Mathur[_2_]	9	651
Formula for selecting a Leap Year. BadBoy	by Glenn	9	334
PASTE DOESNT WORK robin l	by Ken Wright	9	489
display first or second match instead of #REF in INDEX ROW formula seapilot	by T. Valko	9	407
IF function question Dutilbug	by Bob Phillips[_3_]	9	470
How to get my total back? Earleb	by T. Valko	9	395
Array with multiple selection criteria Robert Robinson	by Ashish Mathur[_2_]	9	575
Ctrl+shift+enter [email protected]	by [email protected]	9	1,075
How to look up 2 Cell Values PR[_2_]	by PR[_2_]	9	549
Formula needed: argument changes as more data is added BK	by Ashish Mathur[_2_]	9	542
Using the returned value to look up an item Frankd410	by Dana DeLouis	9	480
RAND() Charles W	by T. Valko	9	697
Consistantly average 180 data cells tiggs96	by Pete_UK	9	389
Simple INDEX MATCH Question FJ	by Max	9	687
IF Statement Modifications Workbook	by Glenn	9	471
Returning 2nd smallest value in a range Rachel7	by Ashish Mathur[_2_]	9	668
typing (c) in excell Jake	by David McRitchie	9	427
Is there an Excel formula to show the highest letter in a row? DaniMa	by DaniMa	9	729
turn a cel a color based o todays date Mark	by Mark	9	563
How do you count data that matches more than one condition? ryesworld	by Jarek Kujawa[_3_]	9	668
omit a negative number LD6892	by LD6892	9	569
repeating columnar data jack	by asas	9	748
Multiple Sums Depending on a description. Hanzo	by Hanzo	9	415
Crossreferencing values between 2 spreadsheets wolfsburg2	by Max	9	451
Average a set of figures which ignores 0 entries Lorraine	by Peo Sjoblom	9	617
Importing Data Jillian	by CLR	9	1,329
CountIf formula results in the formula itself being displayed. NewKid	by Gord Dibben	9	971
Indentify value from multiple values in a single cell Dave	by Biff	9	819
Nesting-Don't use Blanks inside formula Angela	by Angela	9	784
Newbie post - help with Subtotal please! Alison1016	by Alison1016	9	452
Can I delete blank rows from excel without selecting them? rgtest	by Don Guillett	9	1,752
Nesting excel greater than 7 arguments Chris Berding	by Chris Berding	9	439
sumproduct wildcats Mosqui	by Aladin Akyurek	9	458
Summing a variable range of columns Richard Buttrey	by Ron Rosenfeld	9	827
Weeknum MickeW	by hhalle	9	613
Excluding cells with no value in calculation Teri	by Harlan Grove	9	871
Simple statistical analysis Steve Wylie	by Jerry W. Lewis	9	704
Validate cells have data WendyUK	by Jim Simpson	9	704
Array Offset() formula with height of 1 returns duplicates? Uhl	by Uhl	9	1,248
COUNT formula help GeorgeG	by Rick Rothstein \(MVP - VB\)	9	462
How do I round a number to the nearest 600 in Excel? Barcelona	by Bob Phillips	9	993
Cut & Paste visible cells on same row YP	by ShaneDevenshire	9	1,119
Formula Replication fredmr	by fredmr	9	481
get data from a cell in each named range Shazzer	by Shazzer	9	581
Extract email addresses	by RichardSchollar	9	1,429
custom autofilter in excel custom autofilter in excel	by custom autofilter in excel	9	833
How to use HLOOKUP for different sheets depending on results from 2 cells [email protected]	by tankervet	9	1,233
=SUMIF He4Giv	by Biff	9	465
name range from absolute to relative WCO	by Charles Williams	9	1,053
How do I get a worksheet reference to increment when copied Raf	by Ashish Mathur[_2_]	9	1,294
sum of multiple IF statements Snap	by Snap	9	520
Translation Exercise ... Rebecca	by Roger Govier	9	760
Upcoming Date alerts Trenton	by Trenton	9	1,018
Displaying certain coloured cell fomula problems	by fomula problems	9	529
including two ranges of cells in an IF formaula Mark	by	9	444
macros and protection SYBS	by Dave Peterson	9	433