Excel Worksheet Functions - Page 157

Thread / Thread Starter	Last Post	Replies	Views
Showing the entire text within a cell. lehigh46	by Bam	1	867
Counting number of rows between date range and meeting 2 string criteria Hii Sing Chung	by Hii Sing Chung	11	1,655
'Smart worksheet' Lorraine.vdWalt	by RagDyer	1	462
Identifying correct elements with Countif Lady Success	by T. Valko	3	623
Cell preservation or previous value. Paul	by Paul	0	605
Excel 2007 worksheet to WEB page JAW	by JAW	3	442
Multiple Criteria for Sumproduct Pam[_3_]	by Pam[_3_]	6	652
Return result of IF logical test in a different cell navyraine	by T. Valko	1	768
Create new workbook and new worksheet and close. Worksheet not sav Patrick Djo	by Patrick Djo	0	689
Spliting dimensions down PSM[_17_]	by Ron Rosenfeld	3	497
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet Nicole Hannington	by Bernie Deitrick	1	776
contest Cristina	by Cristina	0	518
How do I copy the page set up from one worksheet to another? Deb Raskob[_2_]	by Jacob Skaria	2	510
Multiple lookups and SUM function DevonDilema	by Teethless mama	4	555
Formula updates with SAVE AS JenG	by Bernie Deitrick	1	576
Need to Speed Up A Code LostInNY	by Per Jessen[_2_]	2	569
=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	446
How do I automatically select a Excel record randomly? Italian1	by Italian1	3	655
vlookup in different workbooks with dynamic ranges steph	by T. Valko	6	714
Excel 2003 - Help writing a formula to get time (w, d, h, m) Lady_Aleena	by Glenn	21	1,898
Fred Smith - Extracting data Yoli	by Luke M	1	495
Extract data from worksheet to worksheet Yoli	by Shane Devenshire[_2_]	6	500
copy & pasting automatic formulas AtlantaResearch	by Shane Devenshire[_2_]	3	646
NETWORKDAYS formula LJ[_2_]	by Fred Smith[_4_]	1	613
how do i change cell text colour based on value in other cell Oscarrot	by Max	2	1,235
VBA coding for expiry dates alert threw email Tia[_3_]	by Eduardo	1	1,301
National language function names Stefi	by Stefi	2	590
Show only future Dates Zebrageek	by Max	4	1,308
ALPHABETIZING! rebecca	by Luke M	2	626
Siva and surya siva	by Eduardo	2	452
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,821
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,067
Run a macro in active cell only. Want to place current date/time. time clock watcher	by Simon Lloyd[_319_]	3	1,411
Sumproduct Curtis	by David Biddulph[_2_]	5	511
formula for work rosters to deduct for different breaks vefl	by Liliana[_4_]	3	1,713
Formula for calculating YTD values Suan	by JoeU2004	3	2,004
display actual value Kenny	by Rick Rothstein	1	1,136
using dates for lookup Mal[_2_]	by Max	2	516
How to read value of a cell in a relative location AnatolyV	by T. Valko	1	596
excel neptune	by Shane Devenshire[_2_]	1	483
Won't copy formulas Sandra	by Shane Devenshire[_2_]	1	529
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	429
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	602
Finding the largest match XJSquared	by Don Guillett	9	504
How do I do an e-mail mail merge using an Excel spreadsheet? Gretchen	by Gretchen	0	1,150
Structured reference does not return correct value vsoler	by Teethless mama	5	918
Want more 256 column in 2007 Bachadega	by macropod[_2_]	3	523
VLookup needed to search one value and return multipe results Seth[_2_]	by Max	2	481
Conditional Formatting Hardeep Kanwar	by Hardeep Kanwar	8	536
Equal column widths Herb[_2_]	by Jacob Skaria	1	489
Excel 2angels	by Don Guillett	2	541
Excel : can a self updating table be created Darren	by smartin	1	952
Extracting Data klafert	by Rick Rothstein	9	500
excel formula digit	by Don Guillett	2	391
Want to open docs in two seperate windows..not the same screen. touchingrainbows	by FSt1	2	455
Extracting Data Don Guillett	by Don Guillett	0	425
Calculate age MarkN	by rh33a	5	886
Index lookup with multiple match criteria Vance K[_2_]	by haffa	5	1,108
Time and Date populates automatically newbie_010108	by newbie_010108	4	486
how do I delete cells concatenanted w/out loosing combined info mngirlintx	by Shane Devenshire[_2_]	2	446
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value be013fc	by Shane Devenshire[_2_]	4	616
If Formula When Contains Partial Word zeetoe04	by zeetoe04	5	1,584
insert Rajat Soni	by Ashish Mathur[_2_]	3	417
Calculation automatically capricorngirlone	by Shane Devenshire[_2_]	2	484
How do I set a formula, that add next cell reference in a Formula Gary	by Shane Devenshire[_2_]	2	560
Lock Unlock Cell Protection Mike Josephson	by Simon Lloyd[_312_]	3	742