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,181
Format of cells for VLOOKUP Cobaum	by Cobaum	2	527
How do I copy exact page counts in Excel? Lilly216	by Lilly216	0	468
EXCEL 2000 GA REDNECK & SIMBA	by Glenn	1	341
Counting Multiple Addresses Kate A.	by Kate A.[_2_]	3	459
Copying Named Range Blinkinhek	by RagDyeR	5	568
Formatting cells Our_T	by Duke Carey	1	371
Working an If formula Daleen	by Daleen	9	463
count instance Brad	by Brad	3	380
Lookup based on two variables and return a third Mark	by Mark	3	1,345
too many cell formats Gene[_4_]	by Glenn	1	349
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,002
Vlookup on Dates LossManiac	by LossManiac	6	599
updating cell data and keep from overwriting Joe L	by Joe L	2	688
Using excel as a database Miree	by Miree	2	452
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	472
2008 East Coast US Excel User Conference - Regular registration ends Damon Longworth	by Damon Longworth	0	429
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,340
Group a set of 'time' lelynx	by EddS	3	352
Need blank if no values in range getting value at the mo' Mifty	by Mifty	9	614
Lookup_returning any value.. Aline	by Max	1	417
Lookup_finding all the corresponding cell... Aline	by Max	5	661
Make a cell display the contents of a shape JasperBluto	by JasperBluto	0	663
how to find out if a row is hidden Ray	by Ray	3	465
VLOOKUP Me	by T. Valko	1	465
sum of range containing formula in blanks cc	by T. Valko	1	428
IF + IF? RoadKill	by JMB	7	310
IF question Stuart	by David Biddulph[_2_]	3	359
splitting and formating a number series into date/time CMG8401	by David Biddulph[_2_]	4	601
Offset formula Joe_Hunt	by Joe_Hunt via OfficeKB.com	2	554
Calendar List to Calendar format Kristin	by Pete_UK	3	1,519
How do I turn off format painter so it doesn't keep popping up? mcandrj	by Saylees	4	3,095
using a formula to create an ordered purchase order Jesse	by Max	5	2,772
vlookup returning zeros Cobaum	by Max	5	626
Percentage formula needed MJM	by MJM	5	342
need help with a formula freeman	by Bob Phillips[_3_]	8	414
#Missing Shirley	by JLatham	1	701
similar names - two spreadsheets jtkuehn	by dan dungan	3	655
Choose 2 of 6 optional units for grade - formula question xtrailer	by dan dungan	1	503
=SUMPRODUCT Col E = B, Col F = blank 77Debbie77	by Dave Peterson	7	533
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,142
weighted average elaine9412	by Duke Carey	6	1,051
#NAME? 77Debbie77	by 77Debbie77	5	457
URGENT! how count how often a vlaue occurs within a range of value elaine9412	by T. Valko	3	635
Finding last cell with a value and then adding to another KoolyHigh	by KoolyHigh	2	346
follow up to nested subtotal/sumproduct SteveDB1	by SteveDB1	0	472
If formula with two conditions to meet Carolina	by Carolina	7	2,584
"move tab sheets" Avinono1	by Pete_UK	1	432
Cumulative labor calculation MarkMcG	by MarkMcG	0	412
amortization schedule / Mortgage payments Bmac	by Bernie Deitrick	5	1,407
Complex SUMPRODUCT/VLOOKUP/SUMIF tigger	by tigger	1	701
how do i do interest roll up calculation in excel Steve Costello	by Spiky	2	1,869
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	736
Keep all cells in a column unique? No cells identical phillr	by Gary''s Student	1	550
NEED INFO to the left of rqd cell CAPTGNVR[_2_]	by CAPTGNVR[_2_]	7	446
match with isna formula question Belinda7237	by Belinda7237	2	473
add If to formula to blank #n/a Diddy	by Max	3	430
Keep data in fields if no update while updating MS	by MS	2	419
=SUMPRODUCT(--(TRIM(A1:A10)<"")), what does the "--" mean? Ray	by T. Valko	2	1,843
Active Cell Color Taurien	by Taurien	5	472
Simple IF , maybe, for names in columns Steve	by Max	7	400
fromula to get data from multiple sheets GAK	by GAK	0	388
How do I set a static date? Shawn	by Dave Peterson	5	436
Multiple "IF"'s Solar Man[_2_]	by Solar Man[_2_]	6	318
Excel CCJ	by smartin	1	387
Convert to Binary and Break out results DCLittlejohn	by Rick Rothstein \(MVP - VB\)[_1209_]	10	945
Non-Array Play to Eliminate Blank Cells Peter	by Peter	5	481
nesting sumproduct with subtotal SteveDB1	by SteveDB1	9	604
Basing a range for a linked spreadsheet on internal criteria dstampor	by dstampor	6	403