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	893
How to make a spreadsheet idiot-proof Howard	by Howard	6	1,934
Calculating hr/min format Lee Ann[_2_]	by Trev B	6	526
ADODB Connection fi.or.jp.de	by fi.or.jp.de	0	464
Create a complex formula Workin girl	by pogiman via OfficeKB.com	2	579
Truncate a series of numbers Carrie_Loos via OfficeKB.com	by Carrie_Loos via OfficeKB.com	3	565
Running total in blank cells RAZielinski	by Don Guillett	3	1,455
How do I check if a cell is formatted as a date in Excel VB? Alex@LM	by Alex@LM[_2_]	2	874
Is this formula possible in Excel 2003? anschutz.177[_2_]	by Pete_UK	1	381
Please explain YIELDMAT function JoeU2004	by Stephen Bye[_2_]	9	1,100
Translating Dates to a Visual english4518	by pshepard[_2_]	2	397
Hide a worksheet mac	by pshepard[_2_]	2	373
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	626
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,214
VLOOKUP Formulas Gayle B	by Dan DeHaven[_5_]	5	633
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	601
Pivot Table from linked spreadsheets Normek	by Normek	1	725
VBA Shapes NPell	by NPell	1	699
Customizing a dictionary Grant	by Dave Peterson	3	567
MATCH to ignore blank cells in array Tony Gardner	by Ashish Mathur[_2_]	3	5,709
Help with parameter substitution in formula (&value), vbScript circuit_breaker	by Don Guillett	1	1,337
Change workbook TAB text colour in excel Office 2000 Night Hawk	by Pete_UK	1	798
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,671
Sum and percent in differrent worksheet and file finditsol	by finditsol	0	465
How can I have Excel conditionally copy a cell CA_stateworker	by CA_stateworker	2	554
Search adjacent cells in Column for sequence [email protected]	by T. Valko	3	970
Is there a character paste limit per cell? JAH	by JAH	4	1,888
Help with year to date comparison danny	by danny	4	1,031
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	602
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,905
Lookup in External Worksheet Lady Success	by JICDB	7	697
rota calculations eventhorse	by smartin	1	862
How to transpose and concatenate long list in one column? CSchwass	by Gord Dibben	12	3,376
"This cell is inconsistent with the column formula" error Nebulous	by Nebulous	4	7,059
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	633
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	416
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,054
Yieldmat function BarryHWhite	by JoeU2004	8	2,291
Formatting text Keyrookie	by Billy Liddel	3	444
Restricting Number of characters in a cell Colin Hayes	by Glenn	9	569
How to extract data from one column into two separate columns australand	by Max	5	1,067
If and Lookup bruster	by bruster	6	429
missing data w/ advanced filter Joe	by Joe	6	1,663
Missing Variables bob	by Eduardo	3	447
Create a drop down list which automatically inputs linked informat tooboogaloodooo	by L. Howard Kittle	3	482
Small Function Unique Values Basketball	by T. Valko	6	3,848
Spreadsheet columns are displayed numerically instead of alpha eddie	by Don Guillett	5	498
Can you have to many arguements in a formula CeeCee	by Sam Wilson	4	320
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	617
I'm a leaner wiht a headache!! Gary''s Student	by Gary''s Student	0	572
"IF" formula problem ssharp	by Gary''s Student	1	474
Sumif based on cell format Fun Dan[_2_]	by ryguy7272	2	2,417
IF Formula Porblems ssharp	by pogiman via OfficeKB.com	2	456
DATA VALIDATION/DROP DOWN LIST Anya Blue	by T. Valko	1	563
Advanced Filter Wildcard tpeter	by tpeter	2	880
Nesting workday and if Vegas Sara[_2_]	by Vegas Sara[_2_]	4	663
Sumproduct help again DSKR	by ryguy7272	7	623
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	624
Insert subtotal in a query database Excel 2007 Scotty Tibbs II	by Ashish Mathur[_2_]	3	1,875