Excel Worksheet Functions - Page 1047

Thread / Thread Starter	Last Post	Replies	Views
Sheet won't reference a named cell Mike H	by Mike H	2	892
How to make a spreadsheet idiot-proof Howard	by Howard	6	1,932
Calculating hr/min format Lee Ann[_2_]	by Trev B	6	525
ADODB Connection fi.or.jp.de	by fi.or.jp.de	0	459
Create a complex formula Workin girl	by pogiman via OfficeKB.com	2	573
Truncate a series of numbers Carrie_Loos via OfficeKB.com	by Carrie_Loos via OfficeKB.com	3	556
Running total in blank cells RAZielinski	by Don Guillett	3	1,436
How do I check if a cell is formatted as a date in Excel VB? Alex@LM	by Alex@LM[_2_]	2	871
Is this formula possible in Excel 2003? anschutz.177[_2_]	by Pete_UK	1	377
Please explain YIELDMAT function JoeU2004	by Stephen Bye[_2_]	9	1,099
Translating Dates to a Visual english4518	by pshepard[_2_]	2	396
Hide a worksheet mac	by pshepard[_2_]	2	365
Need help tedious work... Soth	by Ashish Mathur[_2_]	4	426
Sum formulas Workin girl[_2_]	by T. Valko	3	403
Hours to Minutes Formula Ana24	by Ashish Mathur[_2_]	4	621
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,209
VLOOKUP Formulas Gayle B	by Dan DeHaven[_5_]	5	629
Can you have a value created by a function replace the function? xak1222	by Pete_UK	3	459
Line copy - Not just a simple copy paste Ninerref	by Normek	3	596
Pivot Table from linked spreadsheets Normek	by Normek	1	723
VBA Shapes NPell	by NPell	1	699
Customizing a dictionary Grant	by Dave Peterson	3	565
MATCH to ignore blank cells in array Tony Gardner	by Ashish Mathur[_2_]	3	5,708
Help with parameter substitution in formula (&value), vbScript circuit_breaker	by Don Guillett	1	1,336
Change workbook TAB text colour in excel Office 2000 Night Hawk	by Pete_UK	1	796
Formula to add depending upon value entered lheck77	by lheck77	4	439
Count values in column only if value of another column is true MikeB	by ryguy7272	4	2,668
Sum and percent in differrent worksheet and file finditsol	by finditsol	0	463
How can I have Excel conditionally copy a cell CA_stateworker	by CA_stateworker	2	549
Search adjacent cells in Column for sequence [email protected]	by T. Valko	3	969
Is there a character paste limit per cell? JAH	by JAH	4	1,886
Help with year to date comparison danny	by danny	4	1,027
IF(M2="","",(NETWORKDAYS(F2,M2))+TIME(17,0,0)-F2+M2-TIME(8,0,0)) catts22	by Luke M	7	551
Using formula-generated figures in excel in mail-merging [email protected]	by Luke M	1	601
Variable used in a =SUMIF() function? circuit_breaker	by Dave Peterson	3	565
How do I repeat rows at the top of SOME of the pages in Excel IM333	by Dave Peterson	2	4,901
Lookup in External Worksheet Lady Success	by JICDB	7	695
rota calculations eventhorse	by smartin	1	854
How to transpose and concatenate long list in one column? CSchwass	by Gord Dibben	12	3,374
"This cell is inconsistent with the column formula" error Nebulous	by Nebulous	4	7,052
multiple sheet lookup or match Vegas Sara	by Jacob Skaria	4	630
Need to replace one dynamic variable with another dynamic variable djreason	by Jacob Skaria	8	609
add data in column related to cell in another column - see full de Migty	by MS-Exl-Learner	1	739
multiple sheet looks up and match dinesh	by Ashish Mathur[_2_]	4	412
Using "COUNTIF" and "AND" functions together trevor	by Ashish Mathur[_2_]	6	840
SORT/FILTER ISSUE Munfarid	by Ashish Mathur[_2_]	4	507
Excel 2007: =DSUM not working as expected Dan	by Ashish Mathur[_2_]	4	843
Highest alphanumeric B. Liggett	by T. Valko	6	772
Normalizing data? pm	by Dana DeLouis[_3_]	2	1,053
Yieldmat function BarryHWhite	by JoeU2004	8	2,283
Formatting text Keyrookie	by Billy Liddel	3	444
Restricting Number of characters in a cell Colin Hayes	by Glenn	9	567
How to extract data from one column into two separate columns australand	by Max	5	1,063
If and Lookup bruster	by bruster	6	419
missing data w/ advanced filter Joe	by Joe	6	1,663
Missing Variables bob	by Eduardo	3	443
Create a drop down list which automatically inputs linked informat tooboogaloodooo	by L. Howard Kittle	3	478
Small Function Unique Values Basketball	by T. Valko	6	3,837
Spreadsheet columns are displayed numerically instead of alpha eddie	by Don Guillett	5	493
Can you have to many arguements in a formula CeeCee	by Sam Wilson	4	319
Date and Time Conversion Mikekap	by Mikekap	3	414
Alert if the travel activity is after the work activity Go Bucks!!!	by Go Bucks!!![_2_]	3	612
I'm a leaner wiht a headache!! Gary''s Student	by Gary''s Student	0	566
"IF" formula problem ssharp	by Gary''s Student	1	472
Sumif based on cell format Fun Dan[_2_]	by ryguy7272	2	2,410
IF Formula Porblems ssharp	by pogiman via OfficeKB.com	2	449
DATA VALIDATION/DROP DOWN LIST Anya Blue	by T. Valko	1	562
Advanced Filter Wildcard tpeter	by tpeter	2	880
Nesting workday and if Vegas Sara[_2_]	by Vegas Sara[_2_]	4	658
Sumproduct help again DSKR	by ryguy7272	7	619
Tangents Nick72	by Bernard Liengme[_3_]	1	486
Lose relative connection in formula on sort JICDB	by JICDB	2	816
how to fill radar charts with different colors sandy	by sandy	0	1,217
how to eliminate duplicate numbers OPer	by Bill Kuunders	5	623
Insert subtotal in a query database Excel 2007 Scotty Tibbs II	by Ashish Mathur[_2_]	3	1,874