Excel Worksheet Functions - Page 800

Thread / Thread Starter	Last Post	Replies	Views
Fix Simple #Div/0! error taxmom	by taxmom	4	1,093
How can I create a link between cells in two separate Excel sheet Dawnmarie	by Chip Pearson	1	851
Sum Count of Numeric Criterion for LAST 5 Rows Sam via OfficeKB.com	by Sam via OfficeKB.com	5	467
Creating formulas Lara Leigh	by Lara Leigh	6	579
how do I fix my 'if' statement? CBZ	by CBZ	2	436
Return a formula as text string to a cell Sharon	by Sharon	4	6,084
Hi people views once what I received: Money salary - program	by Money salary - program	0	365
Hi people views once what I received: Money salary - program	by Money salary - program	0	389
look up a value sjl	by sjl	4	382
Summing one column if two other columns' values appear in other sh JulieU	by Max	3	950
Carrying a balance forward Melanie Savasta	by Ardus Petus	2	758
Please help w/ nested IF that returns a #N/A. smoore	by smoore	2	312
how can i change my sprdsht to list info from colums into rows kate	by kate	0	448
Excel Help Needed...... Big Bad Nige	by Big Bad Nige	2	356
Count Records Between A-K and L-Z Leslie	by Leslie	3	566
Countif using the same cell on every sheet kmh987	by Ken Johnson	8	712
Conditional Concatenate ExcelMonkey	by ExcelMonkey	3	773
Advanced Filter w/ multiple sheet List Range stickandrock	by stickandrock	0	1,002
VLookup Error in Part of a Named Range Dallas64	by Dallas64	6	1,184
How paste text from note pad to excel w/o using (Text to column) f nginhong	by nginhong	0	1,656
lists lambertdarr	by lambertdarr	1	475
How do you dedupe a list in excel with parameter? mags	by Bob Phillips	1	802
Calculating p-value from Fisher's Exact Test for XYZ parameters paulinoluciano	by paulinoluciano	0	1,551
external data function error-MS Query Ken W	by Ken W	0	543
If Statement??? LoriM1	by LoriM1	11	762
Establish formula for multiple logical_tests Stephen Lim	by broro183	3	812
Excel User Conference - Registration winners Damon Longworth	by Damon Longworth	0	420
LOOKUP function not returning expected value - Using vector_lookup format JerichoForce	by paul	2	663
what is the problem, when value comes up in the total column penny	by paul	1	357
data from 1 sheet to the next dpatte601	by dpatte601	6	350
Correct answers like a quiz Penny Freeman	by Ardus Petus	1	608
how do i create a customised numbered list in excel Franw	by Franw	0	466
functions/formulas Lara Leigh	by Lara Leigh	2	380
Is there a fluctuating payment loan amortization template in XL? sandyfeatherston	by sandyfeatherston	0	1,142
Text manipulation paulinoluciano	by Harlan Grove	5	754
how do you setup a table Daryl	by Gord Dibben	2	390
Help needed with conditional formatting and adjacent text EboniDimplz	by Ken Johnson	3	675
one criteria/mult. values cherrynich	by L. Howard Kittle	1	371
create pivot table with master/detail data from 2 worksheets BarbaraT	by BarbaraT	0	1,518
Display missing Part Number if Column A does not match column B Erik T	by L. Howard Kittle	2	1,585
Ranking on basis of 3 Parameters junoon	by junoon	1	650
Option Button - multiple selected alanap	by Dave Peterson	1	1,190
Finding the date on the 'nth' Monday in this Month in this Year agarwaldvk	by Peo Sjoblom	1	952
Which formula? ExcelN00B06	by L. Howard Kittle	2	365
excel conditional formating decimal fractions Andy Dixon	by Andy Dixon	6	1,293
Returning value based on input data mtroute	by Mark Lincoln	2	556
Sum & VLookup Frank Menard	by Frank Menard	2	438
Dragging Conditional Formatting Frawst	by bpeltzer	6	666
Measure length of an AutoShape Line? John	by Greg Wilson	6	1,073
IF condition MIchel Khennafi	by Elkar	3	342
Sorting two columns (again) outwest via OfficeKB.com	by outwest via OfficeKB.com	2	432
centre across selection shortcut Martin B	by Don Guillett	3	6,663
Finding/removing duplicate names in a worksheet Dave	by Nick Hodge	1	1,113
How to pull cells from other worksheets including color/comments? wendy	by Dave Peterson	1	830
SQL.REQUEST not working in EXCEL 2003 MrSmiley	by MrSmiley	4	591
Changing date from =NOW() to Creation Date Kjell Forssen	by Kjell Forssen	4	838
Calculate 2 Standard Deviations Michael	by [email protected]	2	1,849
Ranking based on two columns sa02000	by sa02000	2	1,298
Count Unique Values with Multiple Criteria JohnV	by JohnV	3	2,939
AND in an array function? Vince	by Vince	2	422
formula for matching text kath_moi	by Ardus Petus	2	359
How to create a New system function NYExcel	by Bob Phillips	1	372
Deleting info from all cells at once days_crazed	by days_crazed	2	473
IF Cell Contents Start with STRING ConfusedNHouston	by MartinW	2	710
Switching Subcategories into Categories and Vice Versa [email protected]	by Ron Coderre	7	971
How do I get the largest number in a sheet to stand out on it own Salgar	by Salgar	3	323
list box Han	by Han	0	353
How to calculate "number of months" between two given date? nginhong	by John James	23	2,380
Returning a sum when looking up two different values 1stcoast	by Ardus Petus	1	540
Index and match among sheets umba-sr	by MartinW	4	601
Total width of several columns. Basher Bates	by Basher Bates	2	696
drop down lists [email protected]	by [email protected]	0	351
Answers needed for challenging formula Sum Limit and marking	by Ron Rosenfeld	16	1,406
How can I add 3 years to date 03/05/2003 mesh	by Ardus Petus	1	916
Pull information based on a range of numbers Styckz	by Styckz	0	456