Excel Worksheet Functions - Page 315

Thread / Thread Starter	Last Post	Replies	Views
Need help with Excel Formula Bob Barker	by JLatham	4	300
Excel Automatic Date Insert CJ	by Bob Phillips	1	1,163
Format of cells for VLOOKUP Cobaum	by Cobaum	2	521
How do I copy exact page counts in Excel? Lilly216	by Lilly216	0	453
EXCEL 2000 GA REDNECK & SIMBA	by Glenn	1	334
Counting Multiple Addresses Kate A.	by Kate A.[_2_]	3	452
Copying Named Range Blinkinhek	by RagDyeR	5	531
Formatting cells Our_T	by Duke Carey	1	364
Working an If formula Daleen	by Daleen	9	456
count instance Brad	by Brad	3	373
Lookup based on two variables and return a third Mark	by Mark	3	1,296
too many cell formats Gene[_4_]	by Glenn	1	329
Add cell "50+55+50+50" to give answer 205 shyboy2k	by PCLIVE	9	468
Creating pivot table to Existing worksheet Malvaro	by Malvaro	1	985
Vlookup on Dates LossManiac	by LossManiac	6	582
updating cell data and keep from overwriting Joe L	by Joe L	2	670
Using excel as a database Miree	by Miree	2	445
How do you rename table headers in a query using Offic 07? DFoster	by Duke Carey	3	1,029
Formula constants? Glenn L.[_2_]	by Glenn L.[_2_]	2	461
2008 East Coast US Excel User Conference - Regular registration ends Damon Longworth	by Damon Longworth	0	417
Match and Index for Tables LiAD	by Roger Govier[_3_]	4	460
Number of days in overlapping date ranges (using array formula?) ajnmx	by Ron Rosenfeld	7	2,306
Group a set of 'time' lelynx	by EddS	3	339
Need blank if no values in range getting value at the mo' Mifty	by Mifty	9	595
Lookup_returning any value.. Aline	by Max	1	410
Lookup_finding all the corresponding cell... Aline	by Max	5	646
Make a cell display the contents of a shape JasperBluto	by JasperBluto	0	634
how to find out if a row is hidden Ray	by Ray	3	454
VLOOKUP Me	by T. Valko	1	455
sum of range containing formula in blanks cc	by T. Valko	1	423
IF + IF? RoadKill	by JMB	7	298
IF question Stuart	by David Biddulph[_2_]	3	348
splitting and formating a number series into date/time CMG8401	by David Biddulph[_2_]	4	568
Offset formula Joe_Hunt	by Joe_Hunt via OfficeKB.com	2	528
Calendar List to Calendar format Kristin	by Pete_UK	3	1,496
How do I turn off format painter so it doesn't keep popping up? mcandrj	by Saylees	4	3,078
using a formula to create an ordered purchase order Jesse	by Max	5	2,752
vlookup returning zeros Cobaum	by Max	5	621
Percentage formula needed MJM	by MJM	5	336
need help with a formula freeman	by Bob Phillips[_3_]	8	404
#Missing Shirley	by JLatham	1	671
similar names - two spreadsheets jtkuehn	by dan dungan	3	635
Choose 2 of 6 optional units for grade - formula question xtrailer	by dan dungan	1	483
=SUMPRODUCT Col E = B, Col F = blank 77Debbie77	by Dave Peterson	7	516
how do I apply formatting from one worksheet to a whole workbook? amergerm35	by amergerm35	5	3,204
hyperlink to other sw(exe) and open with parameters L@ja	by ShaneDevenshire	2	3,119
weighted average elaine9412	by Duke Carey	6	995
#NAME? 77Debbie77	by 77Debbie77	5	450
URGENT! how count how often a vlaue occurs within a range of value elaine9412	by T. Valko	3	606
Finding last cell with a value and then adding to another KoolyHigh	by KoolyHigh	2	333
follow up to nested subtotal/sumproduct SteveDB1	by SteveDB1	0	456
If formula with two conditions to meet Carolina	by Carolina	7	2,539
"move tab sheets" Avinono1	by Pete_UK	1	421
Cumulative labor calculation MarkMcG	by MarkMcG	0	391
amortization schedule / Mortgage payments Bmac	by Bernie Deitrick	5	1,350
Complex SUMPRODUCT/VLOOKUP/SUMIF tigger	by tigger	1	686
how do i do interest roll up calculation in excel Steve Costello	by Spiky	2	1,845
How to restrict user to input only one of multiple cells James	by Gary''s Student	1	1,197
Calculation of an UDF Werner Rohrmoser	by Werner Rohrmoser	5	709
Keep all cells in a column unique? No cells identical phillr	by Gary''s Student	1	496
NEED INFO to the left of rqd cell CAPTGNVR[_2_]	by CAPTGNVR[_2_]	7	439
match with isna formula question Belinda7237	by Belinda7237	2	459
add If to formula to blank #n/a Diddy	by Max	3	423
Keep data in fields if no update while updating MS	by MS	2	405
=SUMPRODUCT(--(TRIM(A1:A10)<"")), what does the "--" mean? Ray	by T. Valko	2	1,823
Active Cell Color Taurien	by Taurien	5	456
Simple IF , maybe, for names in columns Steve	by Max	7	391
fromula to get data from multiple sheets GAK	by GAK	0	360
How do I set a static date? Shawn	by Dave Peterson	5	416
Multiple "IF"'s Solar Man[_2_]	by Solar Man[_2_]	6	312
Excel CCJ	by smartin	1	383
Convert to Binary and Break out results DCLittlejohn	by Rick Rothstein \(MVP - VB\)[_1209_]	10	907
Non-Array Play to Eliminate Blank Cells Peter	by Peter	5	468
nesting sumproduct with subtotal SteveDB1	by SteveDB1	9	587
Basing a range for a linked spreadsheet on internal criteria dstampor	by dstampor	6	397