Excel Worksheet Functions - Page 67

Thread / Thread Starter	Last Post	Replies	Views
Auto calculate Barb H	by Paul C	1	436
How to combine data from 2 separate workbooks onto 1 worksheet Kristen	by Iriemon	2	1,045
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	549
Add comment in protected worksheet Suju Thomas	by trip_to_tokyo[_3_]	3	6,604
Insert Picture McCBeth	by Gord Dibben	2	672
How do I recover the autosaved file? et	by Gord Dibben	1	765
How do you search within a document? Me2020	by Gord Dibben	2	462
Problem with subtotal function Constance	by Constance	0	749
Excel 2007: Conditional Formatting and Ribbon Data JJ[_4_]	by JJ[_4_]	0	462
Formulas B.G. - Canada[_2_]	by Pete_UK	2	455
text as value in pivot table Gerardo	by Gerardo	0	823
Summing Cells with Text and Numbers Trevor Little	by Max	11	1,008
Help needed with a formula for dates in excel 2007 dloc	by dloc	2	650
Auto filter sort ascending not working while sheet protected TommyB	by Dennis Tucker	6	3,290
placing people into age groups based on their DOB JSAUS	by JSAUS	3	1,625
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	489
How to replace formula with its result jclown	by jclown	2	1,366
actual row number climate	by climate	3	510
How can I test the text content of a cell catefaulkes	by macropod[_2_]	4	952
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	549
find smallest positive number among datas Cerberus[_2_]	by Ashish Mathur[_2_]	6	3,030
Selecting rows with the same criteria Ruslan	by Ashish Mathur[_2_]	5	644
Cash Statement- Accruing balances cjarrar	by Fred Smith[_4_]	1	456
Help with formula: finding text Jonas Ornborg	by Gord Dibben	4	436
force alignment? Art	by Gord Dibben	7	509
return different values based on 4 criteria? Susie (SFAngelgirl)[_2_]	by Susan in Sacramento	4	527
don't want to have to change font in header and footer each time? rtur	by Gord Dibben	1	551
Using a cell's value to copy another cells info to another workshe badger2407	by Gord Dibben	1	527
formatting cells pat67	by Gord Dibben	1	489
vlookup(date, range,3) David	by T. Valko	3	3,981
Excel 2007 - worksheets macro version83	by Gord Dibben	1	570
Using spreadsheet to fill in forms Nicci	by Eva	2	2,197
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	661
sorting grouped cells D$	by Bernie Deitrick	1	590
Excel Sorting Lori	by Gary Brown[_5_]	2	469
Looking for a Function? similar to LEFT KatieR	by Harlan Grove[_2_]	5	615
calculating % of a monthly budget on a daily basis DZ	by rzink	3	1,198
Copying values/formulas from only visable lines when filters are o excelchallenged	by excelchallenged	0	473
If function and a range mrsatroy	by Bob Phillips[_4_]	4	565
hiding/unhiding rows Art	by Paul C	1	596
Creating a Macro to autofill and save LauraB	by Gord Dibben	9	614
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,265
If Vlookup is error ( #NA) Steve	by T. Valko	5	2,397
Setting up a formula (when F2<11,000)=$25 Hawkeye	by trip_to_tokyo[_3_]	3	537
Delete Rows using If and Wildcard Max2073	by Don Guillett[_2_]	2	820
Vlookup-Doesn't return values under 1 Carolina	by Carolina	2	903
How to change numbers from positive to negative. tammy p[_2_]	by Luke M[_4_]	2	795
Delete Rows using Wildcard Max2073	by Luke M[_4_]	2	1,081
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	630
List top five Dazed&Confused	by Dazed&Confused	4	418
Vlookup-Doesn't return values under 1 Carolina	by Jacob Skaria	1	637
Help to create a formulae FredDave	by Don Guillett[_2_]	1	366
Sumproduct for Values over a certain Value eg 0.00 enna49	by Max	3	699
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	851
Macro Help Curtis[_2_]	by Jacob Skaria	1	461
excel sum values if cell matches a value Dennis	by Jacob Skaria	1	1,622
Help on percentages greater than 100 cil	by T. Valko	3	6,059
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	777
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,686