Excel Worksheet Functions - Page 800

Thread / Thread Starter	Last Post	Replies	Views
Fix Simple #Div/0! error taxmom	by taxmom	4	1,074
How can I create a link between cells in two separate Excel sheet Dawnmarie	by Chip Pearson	1	825
Sum Count of Numeric Criterion for LAST 5 Rows Sam via OfficeKB.com	by Sam via OfficeKB.com	5	447
Creating formulas Lara Leigh	by Lara Leigh	6	557
how do I fix my 'if' statement? CBZ	by CBZ	2	430
Return a formula as text string to a cell Sharon	by Sharon	4	6,028
Hi people views once what I received: Money salary - program	by Money salary - program	0	362
Hi people views once what I received: Money salary - program	by Money salary - program	0	379
look up a value sjl	by sjl	4	377
Summing one column if two other columns' values appear in other sh JulieU	by Max	3	921
Carrying a balance forward Melanie Savasta	by Ardus Petus	2	735
Please help w/ nested IF that returns a #N/A. smoore	by smoore	2	307
how can i change my sprdsht to list info from colums into rows kate	by kate	0	431
Excel Help Needed...... Big Bad Nige	by Big Bad Nige	2	341
Count Records Between A-K and L-Z Leslie	by Leslie	3	549
Countif using the same cell on every sheet kmh987	by Ken Johnson	8	700
Conditional Concatenate ExcelMonkey	by ExcelMonkey	3	758
Advanced Filter w/ multiple sheet List Range stickandrock	by stickandrock	0	973
VLookup Error in Part of a Named Range Dallas64	by Dallas64	6	1,150
How paste text from note pad to excel w/o using (Text to column) f nginhong	by nginhong	0	1,556
lists lambertdarr	by lambertdarr	1	470
How do you dedupe a list in excel with parameter? mags	by Bob Phillips	1	775
Calculating p-value from Fisher's Exact Test for XYZ parameters paulinoluciano	by paulinoluciano	0	1,530
external data function error-MS Query Ken W	by Ken W	0	531
If Statement??? LoriM1	by LoriM1	11	755
Establish formula for multiple logical_tests Stephen Lim	by broro183	3	802
Excel User Conference - Registration winners Damon Longworth	by Damon Longworth	0	413
LOOKUP function not returning expected value - Using vector_lookup format JerichoForce	by paul	2	631
what is the problem, when value comes up in the total column penny	by paul	1	347
data from 1 sheet to the next dpatte601	by dpatte601	6	341
Correct answers like a quiz Penny Freeman	by Ardus Petus	1	593
how do i create a customised numbered list in excel Franw	by Franw	0	446
functions/formulas Lara Leigh	by Lara Leigh	2	372
Is there a fluctuating payment loan amortization template in XL? sandyfeatherston	by sandyfeatherston	0	1,128
Text manipulation paulinoluciano	by Harlan Grove	5	738
how do you setup a table Daryl	by Gord Dibben	2	384
Help needed with conditional formatting and adjacent text EboniDimplz	by Ken Johnson	3	649
one criteria/mult. values cherrynich	by L. Howard Kittle	1	359
create pivot table with master/detail data from 2 worksheets BarbaraT	by BarbaraT	0	1,500
Display missing Part Number if Column A does not match column B Erik T	by L. Howard Kittle	2	1,551
Ranking on basis of 3 Parameters junoon	by junoon	1	642
Option Button - multiple selected alanap	by Dave Peterson	1	1,169
Finding the date on the 'nth' Monday in this Month in this Year agarwaldvk	by Peo Sjoblom	1	927
Which formula? ExcelN00B06	by L. Howard Kittle	2	358
excel conditional formating decimal fractions Andy Dixon	by Andy Dixon	6	1,273
Returning value based on input data mtroute	by Mark Lincoln	2	538
Sum & VLookup Frank Menard	by Frank Menard	2	435
Dragging Conditional Formatting Frawst	by bpeltzer	6	645
Measure length of an AutoShape Line? John	by Greg Wilson	6	1,053
IF condition MIchel Khennafi	by Elkar	3	338
Sorting two columns (again) outwest via OfficeKB.com	by outwest via OfficeKB.com	2	414
centre across selection shortcut Martin B	by Don Guillett	3	6,630
Finding/removing duplicate names in a worksheet Dave	by Nick Hodge	1	1,083
How to pull cells from other worksheets including color/comments? wendy	by Dave Peterson	1	821
SQL.REQUEST not working in EXCEL 2003 MrSmiley	by MrSmiley	4	569
Changing date from =NOW() to Creation Date Kjell Forssen	by Kjell Forssen	4	799
Calculate 2 Standard Deviations Michael	by [email protected]	2	1,798
Ranking based on two columns sa02000	by sa02000	2	1,283
Count Unique Values with Multiple Criteria JohnV	by JohnV	3	2,891
AND in an array function? Vince	by Vince	2	414
formula for matching text kath_moi	by Ardus Petus	2	350
How to create a New system function NYExcel	by Bob Phillips	1	361
Deleting info from all cells at once days_crazed	by days_crazed	2	445
IF Cell Contents Start with STRING ConfusedNHouston	by MartinW	2	696
Switching Subcategories into Categories and Vice Versa [email protected]	by Ron Coderre	7	957
How do I get the largest number in a sheet to stand out on it own Salgar	by Salgar	3	317
list box Han	by Han	0	350
How to calculate "number of months" between two given date? nginhong	by John James	23	2,362
Returning a sum when looking up two different values 1stcoast	by Ardus Petus	1	522
Index and match among sheets umba-sr	by MartinW	4	587
Total width of several columns. Basher Bates	by Basher Bates	2	685
drop down lists [email protected]	by [email protected]	0	330
Answers needed for challenging formula Sum Limit and marking	by Ron Rosenfeld	16	1,374
How can I add 3 years to date 03/05/2003 mesh	by Ardus Petus	1	908
Pull information based on a range of numbers Styckz	by Styckz	0	447