Excel Worksheet Functions - Page 157

Thread / Thread Starter	Last Post	Replies	Views
Showing the entire text within a cell. lehigh46	by Bam	1	844
Counting number of rows between date range and meeting 2 string criteria Hii Sing Chung	by Hii Sing Chung	11	1,627
'Smart worksheet' Lorraine.vdWalt	by RagDyer	1	452
Identifying correct elements with Countif Lady Success	by T. Valko	3	608
Cell preservation or previous value. Paul	by Paul	0	591
Excel 2007 worksheet to WEB page JAW	by JAW	3	432
Multiple Criteria for Sumproduct Pam[_3_]	by Pam[_3_]	6	632
Return result of IF logical test in a different cell navyraine	by T. Valko	1	733
Create new workbook and new worksheet and close. Worksheet not sav Patrick Djo	by Patrick Djo	0	679
Spliting dimensions down PSM[_17_]	by Ron Rosenfeld	3	476
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet Nicole Hannington	by Bernie Deitrick	1	754
contest Cristina	by Cristina	0	512
How do I copy the page set up from one worksheet to another? Deb Raskob[_2_]	by Jacob Skaria	2	489
Multiple lookups and SUM function DevonDilema	by Teethless mama	4	544
Formula updates with SAVE AS JenG	by Bernie Deitrick	1	551
Need to Speed Up A Code LostInNY	by Per Jessen[_2_]	2	536
=SUMPRODUCT((C481:C507<"")/COUNTIF(C481:C507,C481:C507&"")) Jeff	by Eduardo	3	345
Determine Value based on criteria Jan S	by T. Valko	1	413
2003 colors in 2007? Scott A[_2_]	by Scott A[_2_]	0	429
How do I automatically select a Excel record randomly? Italian1	by Italian1	3	626
vlookup in different workbooks with dynamic ranges steph	by T. Valko	6	671
Excel 2003 - Help writing a formula to get time (w, d, h, m) Lady_Aleena	by Glenn	21	1,881
Fred Smith - Extracting data Yoli	by Luke M	1	483
Extract data from worksheet to worksheet Yoli	by Shane Devenshire[_2_]	6	483
copy & pasting automatic formulas AtlantaResearch	by Shane Devenshire[_2_]	3	594
NETWORKDAYS formula LJ[_2_]	by Fred Smith[_4_]	1	596
how do i change cell text colour based on value in other cell Oscarrot	by Max	2	1,209
VBA coding for expiry dates alert threw email Tia[_3_]	by Eduardo	1	1,279
National language function names Stefi	by Stefi	2	559
Show only future Dates Zebrageek	by Max	4	1,280
ALPHABETIZING! rebecca	by Luke M	2	607
Siva and surya siva	by Eduardo	2	423
Using Lookup Colette	by Colette	1	378
Help with formula Josh W	by JoeU2004	7	507
countif comparing two columns Johndb	by Ashish Mathur[_2_]	4	2,798
Unique data Shah Alam[_2_]	by Jacob Skaria	2	458
Sum If with two ranges Portiapuss	by Mike H	2	407
Give a sheet name from a Cell Hardeep Kanwar	by Rick Rothstein	5	1,045
Run a macro in active cell only. Want to place current date/time. time clock watcher	by Simon Lloyd[_319_]	3	1,386
Sumproduct Curtis	by David Biddulph[_2_]	5	504
formula for work rosters to deduct for different breaks vefl	by Liliana[_4_]	3	1,685
Formula for calculating YTD values Suan	by JoeU2004	3	1,983
display actual value Kenny	by Rick Rothstein	1	1,122
using dates for lookup Mal[_2_]	by Max	2	490
How to read value of a cell in a relative location AnatolyV	by T. Valko	1	564
excel neptune	by Shane Devenshire[_2_]	1	476
Won't copy formulas Sandra	by Shane Devenshire[_2_]	1	504
How to add traffice light Avadh	by MyVeryOwnSelf[_2_]	4	453
Excel Paul Rimmer[_2_]	by Simon Lloyd[_318_]	5	406
Expanding beyond "Very Hidden" Paul	by Paul	1	412
Figuring total # of hours between multiple times R P Wilson	by T. Valko	5	903
linking data from one worksheet to another Wilma	by Otto Moehrbach[_2_]	1	583
Finding the largest match XJSquared	by Don Guillett	9	481
How do I do an e-mail mail merge using an Excel spreadsheet? Gretchen	by Gretchen	0	1,122
Structured reference does not return correct value vsoler	by Teethless mama	5	892
Want more 256 column in 2007 Bachadega	by macropod[_2_]	3	511
VLookup needed to search one value and return multipe results Seth[_2_]	by Max	2	450
Conditional Formatting Hardeep Kanwar	by Hardeep Kanwar	8	524
Equal column widths Herb[_2_]	by Jacob Skaria	1	473
Excel 2angels	by Don Guillett	2	530
Excel : can a self updating table be created Darren	by smartin	1	924
Extracting Data klafert	by Rick Rothstein	9	464
excel formula digit	by Don Guillett	2	380
Want to open docs in two seperate windows..not the same screen. touchingrainbows	by FSt1	2	445
Extracting Data Don Guillett	by Don Guillett	0	413
Calculate age MarkN	by rh33a	5	852
Index lookup with multiple match criteria Vance K[_2_]	by haffa	5	1,084
Time and Date populates automatically newbie_010108	by newbie_010108	4	465
how do I delete cells concatenanted w/out loosing combined info mngirlintx	by Shane Devenshire[_2_]	2	431
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value be013fc	by Shane Devenshire[_2_]	4	583
If Formula When Contains Partial Word zeetoe04	by zeetoe04	5	1,559
insert Rajat Soni	by Ashish Mathur[_2_]	3	401
Calculation automatically capricorngirlone	by Shane Devenshire[_2_]	2	473
How do I set a formula, that add next cell reference in a Formula Gary	by Shane Devenshire[_2_]	2	542
Lock Unlock Cell Protection Mike Josephson	by Simon Lloyd[_312_]	3	716