Excel Worksheet Functions - Page 157

Thread / Thread Starter	Last Post	Replies	Views
Showing the entire text within a cell. lehigh46	by Bam	1	856
Counting number of rows between date range and meeting 2 string criteria Hii Sing Chung	by Hii Sing Chung	11	1,647
'Smart worksheet' Lorraine.vdWalt	by RagDyer	1	460
Identifying correct elements with Countif Lady Success	by T. Valko	3	620
Cell preservation or previous value. Paul	by Paul	0	600
Excel 2007 worksheet to WEB page JAW	by JAW	3	441
Multiple Criteria for Sumproduct Pam[_3_]	by Pam[_3_]	6	641
Return result of IF logical test in a different cell navyraine	by T. Valko	1	755
Create new workbook and new worksheet and close. Worksheet not sav Patrick Djo	by Patrick Djo	0	687
Spliting dimensions down PSM[_17_]	by Ron Rosenfeld	3	490
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet Nicole Hannington	by Bernie Deitrick	1	766
contest Cristina	by Cristina	0	517
How do I copy the page set up from one worksheet to another? Deb Raskob[_2_]	by Jacob Skaria	2	503
Multiple lookups and SUM function DevonDilema	by Teethless mama	4	553
Formula updates with SAVE AS JenG	by Bernie Deitrick	1	570
Need to Speed Up A Code LostInNY	by Per Jessen[_2_]	2	555
=SUMPRODUCT((C481:C507<"")/COUNTIF(C481:C507,C481:C507&"")) Jeff	by Eduardo	3	382
Determine Value based on criteria Jan S	by T. Valko	1	419
2003 colors in 2007? Scott A[_2_]	by Scott A[_2_]	0	442
How do I automatically select a Excel record randomly? Italian1	by Italian1	3	642
vlookup in different workbooks with dynamic ranges steph	by T. Valko	6	689
Excel 2003 - Help writing a formula to get time (w, d, h, m) Lady_Aleena	by Glenn	21	1,892
Fred Smith - Extracting data Yoli	by Luke M	1	495
Extract data from worksheet to worksheet Yoli	by Shane Devenshire[_2_]	6	498
copy & pasting automatic formulas AtlantaResearch	by Shane Devenshire[_2_]	3	611
NETWORKDAYS formula LJ[_2_]	by Fred Smith[_4_]	1	611
how do i change cell text colour based on value in other cell Oscarrot	by Max	2	1,224
VBA coding for expiry dates alert threw email Tia[_3_]	by Eduardo	1	1,292
National language function names Stefi	by Stefi	2	581
Show only future Dates Zebrageek	by Max	4	1,296
ALPHABETIZING! rebecca	by Luke M	2	620
Siva and surya siva	by Eduardo	2	449
Using Lookup Colette	by Colette	1	394
Help with formula Josh W	by JoeU2004	7	516
countif comparing two columns Johndb	by Ashish Mathur[_2_]	4	2,810
Unique data Shah Alam[_2_]	by Jacob Skaria	2	476
Sum If with two ranges Portiapuss	by Mike H	2	420
Give a sheet name from a Cell Hardeep Kanwar	by Rick Rothstein	5	1,062
Run a macro in active cell only. Want to place current date/time. time clock watcher	by Simon Lloyd[_319_]	3	1,397
Sumproduct Curtis	by David Biddulph[_2_]	5	511
formula for work rosters to deduct for different breaks vefl	by Liliana[_4_]	3	1,709
Formula for calculating YTD values Suan	by JoeU2004	3	2,003
display actual value Kenny	by Rick Rothstein	1	1,135
using dates for lookup Mal[_2_]	by Max	2	500
How to read value of a cell in a relative location AnatolyV	by T. Valko	1	582
excel neptune	by Shane Devenshire[_2_]	1	483
Won't copy formulas Sandra	by Shane Devenshire[_2_]	1	521
How to add traffice light Avadh	by MyVeryOwnSelf[_2_]	4	469
Excel Paul Rimmer[_2_]	by Simon Lloyd[_318_]	5	414
Expanding beyond "Very Hidden" Paul	by Paul	1	428
Figuring total # of hours between multiple times R P Wilson	by T. Valko	5	914
linking data from one worksheet to another Wilma	by Otto Moehrbach[_2_]	1	594
Finding the largest match XJSquared	by Don Guillett	9	492
How do I do an e-mail mail merge using an Excel spreadsheet? Gretchen	by Gretchen	0	1,133
Structured reference does not return correct value vsoler	by Teethless mama	5	907
Want more 256 column in 2007 Bachadega	by macropod[_2_]	3	522
VLookup needed to search one value and return multipe results Seth[_2_]	by Max	2	467
Conditional Formatting Hardeep Kanwar	by Hardeep Kanwar	8	534
Equal column widths Herb[_2_]	by Jacob Skaria	1	480
Excel 2angels	by Don Guillett	2	541
Excel : can a self updating table be created Darren	by smartin	1	941
Extracting Data klafert	by Rick Rothstein	9	491
excel formula digit	by Don Guillett	2	391
Want to open docs in two seperate windows..not the same screen. touchingrainbows	by FSt1	2	452
Extracting Data Don Guillett	by Don Guillett	0	425
Calculate age MarkN	by rh33a	5	873
Index lookup with multiple match criteria Vance K[_2_]	by haffa	5	1,098
Time and Date populates automatically newbie_010108	by newbie_010108	4	479
how do I delete cells concatenanted w/out loosing combined info mngirlintx	by Shane Devenshire[_2_]	2	445
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value be013fc	by Shane Devenshire[_2_]	4	608
If Formula When Contains Partial Word zeetoe04	by zeetoe04	5	1,575
insert Rajat Soni	by Ashish Mathur[_2_]	3	417
Calculation automatically capricorngirlone	by Shane Devenshire[_2_]	2	481
How do I set a formula, that add next cell reference in a Formula Gary	by Shane Devenshire[_2_]	2	557
Lock Unlock Cell Protection Mike Josephson	by Simon Lloyd[_312_]	3	742