Excel Worksheet Functions - Page 1173

Thread / Thread Starter	Last Post	Replies	Views
compare -neg and +pos number that cancel each other in a column chom krusopon	by Casper	14	2,205
Vertical lookup of pictures DJDKAL	by Gord Dibben	14	918
Count cells based upon criteria in other cells JT	by JT	14	1,087
how do i retrieve the largest value from several records/rows in e Louis	by Max	14	1,072
Help Steve	by T. Valko	14	971
concentrate muli cells Dylan @ UAFC[_2_]	by [email protected]	14	1,118
Fun with SUMPRODUCT rweiss	by rweiss	14	873
VLookup L.Mathe	by Max	14	903
Why does it display #### in my cell? Lindsey-Star	by Joe User[_2_]	14	2,421
Date Function Jen_T	by Rick Rothstein	14	1,144
Advanced Filter Question Pieyed Piper	by MeowSayTongue	14	1,031
Id'ing tabs that contain #REF!'s Steve	by Steve	14	906
how to remove all formatting Tom	by XLGeek[_2_]	14	1,099
formula to return value from a matrix - I know hor and vert values UKMAN	by Don Guillett[_2_]	14	2,218
Fixing date of entry Colin Hayes	by Gord Dibben[_2_]	14	1,130
Combine Rows Based on Capitalization dogplayingpoker	by Don Guillett[_2_]	14	1,465
Calculating number of workdays between 2 dates Gibbyky2	by Tariq[_2_]	15	2,735
Transfer data from a cell to another workbook if certain criteria breezy	by mdrizwan81	15	3,333
Macro for HEAT chart - THANKS IN ADVANCE! Rachel Costanza	by Gord Dibben	15	1,438
Use RANDBETWEEN form & include certain #'s in the range texas7186	by Joe User[_2_]	15	2,048
Nested COUNTIF? Astro	by Fred Smith[_4_]	15	1,754
COUNTIF question Jock	by Dave Peterson	15	1,692
Please help with splitting column??? TotallyConfused	by Gord Dibben	15	821
excel function that reads a value than 0 jcheko	by T. Valko	15	955
Create a 12 month rolling average forest8	by Max	15	6,606
Multiple Rows Into One PR[_2_]	by Don Guillett	15	747
Help with a Sum and an Array Pablo	by T. Valko	15	906
Need help with INDEX lookup Vegas Sara[_2_]	by T. Valko	15	998
Summing a Formula Debbie[_4_]	by Debbie[_4_]	15	850
Sum the last 21 cells David	by David	15	926
IF Connie Martin	by David Biddulph[_2_]	15	942
Edit Multiple Cells Jenn	by Jenn	15	1,005
multiple V-lookup Julie	by Ashish Mathur[_2_]	15	1,013
SUM all Instances Q Seanie	by Dave Peterson	15	1,394
Formatting Phone Numbers in Excel 2007 Help MrMike	by MrMike	15	3,345
How do I have a cell value define a dynamic named range? CellShocked	by CellShocked	15	1,594
Average Time Not Calculating JPP	by Ron Rosenfeld[_2_]	15	1,726
What does this formulea mean? Waa	by Bruno Campanini[_2_]	15	2,046
Return cell contents based on conditional lookup jarviscars	by Krishnakumar	15	2,181
Round time to quarter hour pdberger	by Rick Rothstein \(MVP - VB\)	15	2,001
How do I find the length of time (Years & Months) between 2 dates David Picken	by daddylonglegs	15	4,044
need help with this formula Joan	by Joan	15	1,019
Problem with Formula John	by Aladin Akyurek	15	1,408
If typed 12805 then 12/8/05 Steved	by Steved	15	1,051
How do I return a blank for VLOOKUP instead of #N/A? ExcelBee	by nowfal	15	1,677
IF statements/formula problem Admiral70	by Sandy Mann	15	900
Number of paychecks in a month? jkh1978	by RagDyer	15	941
Extract only items not on previous list Leslie Coover	by Ron Rosenfeld	15	969
#DIV/0! How do I remove this answer?!?!? Rebekah	by Rebekah	15	835
SUM of Hex? GeeB	by GeeB	15	2,076
sumproduct bombs out JN	by Sandy Mann	15	748
Vlookup Count confusion ! Andy787878	by Andy787878	15	928
Get aveages for last few days Sick Puppy	by Domenic	15	977
Number of semi-monthly periods between 2 dates sforr	by Ron Rosenfeld	15	2,653
IF Statement Question Scott	by Bob Phillips	15	963
NETWORKDAYS gives #NAME even though Analysis Toolpak is installed Stan Brown	by Stan Brown	15	1,716
sum by cell color Kim via OfficeKB.com	by JulieD	15	1,101
Conditional Sum Incorrect FAI_Judge	by Ed Ferrero	15	981
how do I use vlookup for multiple occurrences of the same value Edith F	by Alan Beban	15	2,693
Create a Command Button to Send E-Mails to selected recipients MeMe	by MeMe	15	1,300
calculating probabilty of x number of successes with multiple tria mk9999999	by Jerry W. Lewis	15	1,899
Excel Formula Error Griffey5	by David Biddulph[_2_]	15	1,227
Formula Help Please Ken	by Ragdyer	15	847
Sum all Values in a changing Column RyanH	by RyanH	15	930
need help :D dc04wrightl	by dc04wrightl	15	950
How do I calculate simultaneous equations? RL	by Niek Otten	15	2,435
NETWORKDAYS() saved as =#N/A in XL2007 Sean	by amcnelis	15	1,095
Lookup Whitney	by T. Valko	15	815
COUNTIF Karen	by Dave Peterson	15	1,033
Assign a code to a range of time Elizabeth	by Pete_UK	15	989
Custom Number Format CNB Cheryl	by ·!¦[··ï¡†¡ï·»Gen°Digger«·ï¡†¡ï··]¦!·	15	1,080
Ranges and Arrays in Excel VBA a.riva@UCL	by Chip Pearson	15	3,803
Time formulas Blazingsaddles	by T. Valko	15	962
IF(ISTEXT Concatenate formula question SCrowley	by SCrowley	15	1,070
CF help needed with cell color NealMed	by OssieMac	15	749