Excel Worksheet Functions - Page 315

Thread / Thread Starter	Last Post	Replies	Views
Need help with Excel Formula Bob Barker	by JLatham	4	312
Excel Automatic Date Insert CJ	by Bob Phillips	1	1,183
Format of cells for VLOOKUP Cobaum	by Cobaum	2	527
How do I copy exact page counts in Excel? Lilly216	by Lilly216	0	475
EXCEL 2000 GA REDNECK & SIMBA	by Glenn	1	349
Counting Multiple Addresses Kate A.	by Kate A.[_2_]	3	469
Copying Named Range Blinkinhek	by RagDyeR	5	569
Formatting cells Our_T	by Duke Carey	1	371
Working an If formula Daleen	by Daleen	9	473
count instance Brad	by Brad	3	389
Lookup based on two variables and return a third Mark	by Mark	3	1,355
too many cell formats Gene[_4_]	by Glenn	1	359
Add cell "50+55+50+50" to give answer 205 shyboy2k	by PCLIVE	9	480
Creating pivot table to Existing worksheet Malvaro	by Malvaro	1	1,009
Vlookup on Dates LossManiac	by LossManiac	6	604
updating cell data and keep from overwriting Joe L	by Joe L	2	698
Using excel as a database Miree	by Miree	2	460
How do you rename table headers in a query using Offic 07? DFoster	by Duke Carey	3	1,061
Formula constants? Glenn L.[_2_]	by Glenn L.[_2_]	2	477
2008 East Coast US Excel User Conference - Regular registration ends Damon Longworth	by Damon Longworth	0	430
Match and Index for Tables LiAD	by Roger Govier[_3_]	4	483
Number of days in overlapping date ranges (using array formula?) ajnmx	by Ron Rosenfeld	7	2,348
Group a set of 'time' lelynx	by EddS	3	358
Need blank if no values in range getting value at the mo' Mifty	by Mifty	9	621
Lookup_returning any value.. Aline	by Max	1	417
Lookup_finding all the corresponding cell... Aline	by Max	5	673
Make a cell display the contents of a shape JasperBluto	by JasperBluto	0	665
how to find out if a row is hidden Ray	by Ray	3	475
VLOOKUP Me	by T. Valko	1	470
sum of range containing formula in blanks cc	by T. Valko	1	440
IF + IF? RoadKill	by JMB	7	320
IF question Stuart	by David Biddulph[_2_]	3	369
splitting and formating a number series into date/time CMG8401	by David Biddulph[_2_]	4	608
Offset formula Joe_Hunt	by Joe_Hunt via OfficeKB.com	2	563
Calendar List to Calendar format Kristin	by Pete_UK	3	1,522
How do I turn off format painter so it doesn't keep popping up? mcandrj	by Saylees	4	3,103
using a formula to create an ordered purchase order Jesse	by Max	5	2,782
vlookup returning zeros Cobaum	by Max	5	634
Percentage formula needed MJM	by MJM	5	345
need help with a formula freeman	by Bob Phillips[_3_]	8	425
#Missing Shirley	by JLatham	1	703
similar names - two spreadsheets jtkuehn	by dan dungan	3	660
Choose 2 of 6 optional units for grade - formula question xtrailer	by dan dungan	1	506
=SUMPRODUCT Col E = B, Col F = blank 77Debbie77	by Dave Peterson	7	535
how do I apply formatting from one worksheet to a whole workbook? amergerm35	by amergerm35	5	3,261
hyperlink to other sw(exe) and open with parameters L@ja	by ShaneDevenshire	2	3,150
weighted average elaine9412	by Duke Carey	6	1,051
#NAME? 77Debbie77	by 77Debbie77	5	467
URGENT! how count how often a vlaue occurs within a range of value elaine9412	by T. Valko	3	637
Finding last cell with a value and then adding to another KoolyHigh	by KoolyHigh	2	355
follow up to nested subtotal/sumproduct SteveDB1	by SteveDB1	0	478
If formula with two conditions to meet Carolina	by Carolina	7	2,592
"move tab sheets" Avinono1	by Pete_UK	1	442
Cumulative labor calculation MarkMcG	by MarkMcG	0	419
amortization schedule / Mortgage payments Bmac	by Bernie Deitrick	5	1,413
Complex SUMPRODUCT/VLOOKUP/SUMIF tigger	by tigger	1	710
how do i do interest roll up calculation in excel Steve Costello	by Spiky	2	1,880
How to restrict user to input only one of multiple cells James	by Gary''s Student	1	1,225
Calculation of an UDF Werner Rohrmoser	by Werner Rohrmoser	5	746
Keep all cells in a column unique? No cells identical phillr	by Gary''s Student	1	560
NEED INFO to the left of rqd cell CAPTGNVR[_2_]	by CAPTGNVR[_2_]	7	447
match with isna formula question Belinda7237	by Belinda7237	2	480
add If to formula to blank #n/a Diddy	by Max	3	440
Keep data in fields if no update while updating MS	by MS	2	427
=SUMPRODUCT(--(TRIM(A1:A10)<"")), what does the "--" mean? Ray	by T. Valko	2	1,845
Active Cell Color Taurien	by Taurien	5	477
Simple IF , maybe, for names in columns Steve	by Max	7	409
fromula to get data from multiple sheets GAK	by GAK	0	398
How do I set a static date? Shawn	by Dave Peterson	5	441
Multiple "IF"'s Solar Man[_2_]	by Solar Man[_2_]	6	324
Excel CCJ	by smartin	1	397
Convert to Binary and Break out results DCLittlejohn	by Rick Rothstein \(MVP - VB\)[_1209_]	10	956
Non-Array Play to Eliminate Blank Cells Peter	by Peter	5	486
nesting sumproduct with subtotal SteveDB1	by SteveDB1	9	614
Basing a range for a linked spreadsheet on internal criteria dstampor	by dstampor	6	413