Excel Worksheet Functions - Page 205

Thread / Thread Starter	Last Post	Replies	Views
Concatenation with leading zeros Laura K	by David McRitchie	6	1,228
How do you reference another cell in the criteria of a SUMIF funct Hold the Onions	by Aladin Akyurek	2	598
Less i column Steved	by Steved	2	299
IF function trouble raye	by raye	2	418
how do I calculate hours using one cell only James Fullmer	by Biff	2	547
Please make it easier to access the IS functions (e.g., isblank) . melyndac2005	by Blue Hornet	9	695
validation-list Keyvan	by Debra Dalgleish	1	325
sum / lookup w error correction Robert	by Peo Sjoblom	4	362
Editing Array Formula [email protected]	by Harlan Grove	7	722
How can I match data about countries drawn from two database queries? tettrick	by Harlan Grove	3	487
overtime formula based on dynamic date range? kalika	by kalika	2	1,364
I cannot edit a graph F.C	by F.C	0	499
can i store percentage formulas to reuse them? Jess	by Bob Phillips	2	435
how to get the name of the sheet in a cell? Alexandra	by Jack Sons	8	344
import text and sort data into excel Boozman	by Boozman	0	561
Any MVP to try this .. Mubeen	by Mubeen	0	274
How to consolidate data from multiple worksheets. SAR	by SAR	0	1,133
how to count the number of decimal places in a cell? Warren Smith	by KL	7	1,556
Index function works in A2, but not in A10, Why is that? Cant figure it out. sonar	by Biff	8	565
Complicated Formulas Andy (Hypnotic_Monkey_Scratcher)	by Ian	7	450
Count down formula Foss	by Foss	4	650
variable as a cell reference? jim sturtz	by jim sturtz	5	546
Need Help abdul hanan a via OfficeKB.com	by Bob Phillips	2	333
How do a lock a picture to the rest of the spread sheet row entry Captain Paul	by bill k	1	747
Excell Check Digit Formula tnelson	by Ian	1	3,080
Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA Daniel	by Daniel	2	592
Making a drop down list/column Kim	by Max	1	548
Creating a formula for down and distance Cecil	by Conrad Carlberg	3	436
how to save/copy data in cell to a series of cells on another pg Azrael	by Azrael	0	598
Complicated sort function with sort and sum Matz	by Ian	3	480
Database type Formulas Smejk	by Duke Carey	1	632
Signifcant digits Daniel Bonallack	by Jerry W. Lewis	3	446
import text and sort data into excel Boozman	by Stefi	2	787
Comments Dave 2005	by bj	1	338
Sort function or macro for the first 4 letters Matz	by Dave Peterson	5	320
Paste Link Freshman	by Max	7	660
Lookup across multiple worksheets DCSwearingen	by DCSwearingen	2	481
Figuring hours scott45	by scott45	0	480
is date can be filtered to a different cell? Morphyus C via OfficeKB.com	by Morphyus C via OfficeKB.com	2	309
Counting rows containing data (both numbers and text) mconnolly	by Duke Carey	4	478
functions with nonadjacent cells PCdummy	by JE McGimpsey	1	515
Reference an identical cell on a different page using copy/paste? Radar	by Radar	4	797
SUMPRODUCT Help Sam via OfficeKB.com	by Sam via OfficeKB.com	2	569
function vba Joost	by Don Guillett	1	275
Comments Help Dave 2005	by Dave 2005	0	414
Sum of a row minus two smallest numbers Philippe	by Ron Rosenfeld	2	606
STPCScut STPCScopy macro missing?? Gerhard Silbermann	by Dave Peterson	3	370
How...? Davor ®upaniæ	by Davor ®upaniæ	0	313
SUMIF with multiple criteria stacyjhaskins	by JE McGimpsey	4	519
Formula does not work with 13 digit numbers sonar	by sonar	4	646
how to change formula bar settings eccentric	by Gord Dibben	1	834
Linking Spreadsheets Missy	by Missy	0	586
HYPERLINK SALIMBENE	by SALIMBENE	0	276
Calculating Percentage mconnolly	by ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ	1	720
How do I display a graph from one workbook to another Susan	by Susan	0	430
Worksheet Selections in Macros Duke Carey	by Duke Carey	0	404
Figuring hours scott45	by scott45	6	526
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ	by ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ	0	819
Exl: how to? If column N value =R, then copyentir rowto sheet 2 Cynthia	by Cynthia	0	364
Worksheet Selections in Macros Karen	by Karen	0	331
Excel Lookup with If victorcab	by bill k	2	368
Hightlighting Numbers & then all Cells to the right of these Numbers. Dave	by Dave 2005	4	650
Adding columns to a worksheet Traci	by Traci	3	552
GETPIVOTDATA - return cell reference, not value Slider	by Slider	0	1,231
Can I sum only highlighted cells in a worksheet? Mr Harlow	by Gord Dibben	2	1,464
Round function that rounds down if 5 Mikus	by Ron Rosenfeld	5	853
convert date of birth to mos. old now, 30 and 60 days Samantha	by Ron Rosenfeld	1	682
Comparing Cells EXCEL101	by Dave Peterson	3	446
How to protect sheet but allow grouping to work dwsmha	by Dave Peterson	1	609
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH CHARI	by Gord Dibben	4	663
Add more than 65536 rows? Roby36	by Gord Dibben	3	1,261
words means numbers Zack	by Gord Dibben	5	474
Change number to text formula Fesk	by Domenic	1	632
Find last occurance of text in range farutherford	by farutherford	5	1,691
SUMPRODUCT Help Sam via OfficeKB.com	by Sam via OfficeKB.com	2	493