Excel Worksheet Functions - Page 67

Thread / Thread Starter	Last Post	Replies	Views
Auto calculate Barb H	by Paul C	1	441
How to combine data from 2 separate workbooks onto 1 worksheet Kristen	by Iriemon	2	1,048
negative time summation calculation for a standard day Glamb	by Fred Smith[_4_]	2	696
leave sum of j7 at 40 or less put excess in k7 payroll function	by Fred Smith[_4_]	2	428
Access to a series, when it is assigned to an empty range Werner Rohrmoser	by Werner Rohrmoser	0	559
Add comment in protected worksheet Suju Thomas	by trip_to_tokyo[_3_]	3	6,609
Insert Picture McCBeth	by Gord Dibben	2	676
How do I recover the autosaved file? et	by Gord Dibben	1	766
How do you search within a document? Me2020	by Gord Dibben	2	462
Problem with subtotal function Constance	by Constance	0	759
Excel 2007: Conditional Formatting and Ribbon Data JJ[_4_]	by JJ[_4_]	0	463
Formulas B.G. - Canada[_2_]	by Pete_UK	2	456
text as value in pivot table Gerardo	by Gerardo	0	823
Summing Cells with Text and Numbers Trevor Little	by Max	11	1,014
Help needed with a formula for dates in excel 2007 dloc	by dloc	2	660
Auto filter sort ascending not working while sheet protected TommyB	by Dennis Tucker	6	3,292
placing people into age groups based on their DOB JSAUS	by JSAUS	3	1,626
i can't get this formula to work kyle	by kyle	3	419
The Tueday prior to a holiday... Steve	by Steve	10	745
implementing formulas in excel Ian	by Ian	0	498
How to replace formula with its result jclown	by jclown	2	1,366
actual row number climate	by climate	3	511
How can I test the text content of a cell catefaulkes	by macropod[_2_]	4	956
Importing cells frmom a calendar workbook AZSteve	by AZSteve	4	638
If and LOOKUP - results in multiple columns Joodle	by Teethless mama	6	561
Main Form - copy exact data from multiple worksheets with live lin uncreative	by IdiotZ42	1	1,271
SUMIF with multiple criteria GBExcel via OfficeKB.com	by T. Valko	5	550
find smallest positive number among datas Cerberus[_2_]	by Ashish Mathur[_2_]	6	3,031
Selecting rows with the same criteria Ruslan	by Ashish Mathur[_2_]	5	655
Cash Statement- Accruing balances cjarrar	by Fred Smith[_4_]	1	456
Help with formula: finding text Jonas Ornborg	by Gord Dibben	4	444
force alignment? Art	by Gord Dibben	7	509
return different values based on 4 criteria? Susie (SFAngelgirl)[_2_]	by Susan in Sacramento	4	532
don't want to have to change font in header and footer each time? rtur	by Gord Dibben	1	556
Using a cell's value to copy another cells info to another workshe badger2407	by Gord Dibben	1	538
formatting cells pat67	by Gord Dibben	1	489
vlookup(date, range,3) David	by T. Valko	3	3,989
Excel 2007 - worksheets macro version83	by Gord Dibben	1	570
Using spreadsheet to fill in forms Nicci	by Eva	2	2,207
Vlookup and Hlookup cadustin	by cadustin	4	939
Help: vlookup from multiple sheets and spreadhseets Mr Fujisawa[_2_]	by Herbert Seidenberg	1	452
auto populate unused rows from workbook to workbook JG	by JLatham	1	666
sorting grouped cells D$	by Bernie Deitrick	1	600
Excel Sorting Lori	by Gary Brown[_5_]	2	469
Looking for a Function? similar to LEFT KatieR	by Harlan Grove[_2_]	5	621
calculating % of a monthly budget on a daily basis DZ	by rzink	3	1,207
Copying values/formulas from only visable lines when filters are o excelchallenged	by excelchallenged	0	484
If function and a range mrsatroy	by Bob Phillips[_4_]	4	575
hiding/unhiding rows Art	by Paul C	1	596
Creating a Macro to autofill and save LauraB	by Gord Dibben	9	615
Need help with formulae comparing date-based numbers Dataslinger	by T. Valko	2	532
How do I turn off R1C1 reference type in Excel 2007? Mag	by Bob Phillips[_4_]	3	4,270
If Vlookup is error ( #NA) Steve	by T. Valko	5	2,407
Setting up a formula (when F2<11,000)=$25 Hawkeye	by trip_to_tokyo[_3_]	3	544
Delete Rows using If and Wildcard Max2073	by Don Guillett[_2_]	2	831
Vlookup-Doesn't return values under 1 Carolina	by Carolina	2	911
How to change numbers from positive to negative. tammy p[_2_]	by Luke M[_4_]	2	802
Delete Rows using Wildcard Max2073	by Luke M[_4_]	2	1,092
Yearly sum jam[_2_]	by Luke M[_4_]	3	820
autopopulate based on a cell value Art	by Art	2	1,075
delete columns in spreadsheet after data entered so it wont scroll Question	by Jacob Skaria	1	635
List top five Dazed&Confused	by Dazed&Confused	4	419
Vlookup-Doesn't return values under 1 Carolina	by Jacob Skaria	1	647
Help to create a formulae FredDave	by Don Guillett[_2_]	1	376
Sumproduct for Values over a certain Value eg 0.00 enna49	by Max	3	707
What-if-Analysis feature of spreadsheet LATA	by Jacob Skaria	1	594
How do I get drop-down list that includes, eg top10 RichardHouse	by trip_to_tokyo[_3_]	1	861
Macro Help Curtis[_2_]	by Jacob Skaria	1	461
excel sum values if cell matches a value Dennis	by Jacob Skaria	1	1,632
Help on percentages greater than 100 cil	by T. Valko	3	6,060
Calculating %'s with IF and Sum/SumIF Billy B	by Joe User[_2_]	12	970
Formula causing run-time error in Excel Programming cherman	by cherman	2	785
Is there a way to use a multiple column array in SUMPRODUCT? rk	by Teethless mama	2	1,307
Index/Lookup Function? jackie	by Max	4	505
Replace Function that uses lookup table? msnyc07	by Eva	1	4,693