Excel Worksheet Functions - Page 137

Thread / Thread Starter	Last Post	Replies	Views
Yieldmat function BarryHWhite	by JoeU2004	8	2,341
Normalizing data? pm	by Dana DeLouis[_3_]	2	1,068
Highest alphanumeric B. Liggett	by T. Valko	6	780
Excel 2007: =DSUM not working as expected Dan	by Ashish Mathur[_2_]	4	852
SORT/FILTER ISSUE Munfarid	by Ashish Mathur[_2_]	4	513
Using "COUNTIF" and "AND" functions together trevor	by Ashish Mathur[_2_]	6	844
multiple sheet looks up and match dinesh	by Ashish Mathur[_2_]	4	426
add data in column related to cell in another column - see full de Migty	by MS-Exl-Learner	1	746
Need to replace one dynamic variable with another dynamic variable djreason	by Jacob Skaria	8	651
multiple sheet lookup or match Vegas Sara	by Jacob Skaria	4	641
"This cell is inconsistent with the column formula" error Nebulous	by Nebulous	4	7,098
How to transpose and concatenate long list in one column? CSchwass	by Gord Dibben	12	3,401
rota calculations eventhorse	by smartin	1	869
Lookup in External Worksheet Lady Success	by JICDB	7	710
How do I repeat rows at the top of SOME of the pages in Excel IM333	by Dave Peterson	2	4,936
Variable used in a =SUMIF() function? circuit_breaker	by Dave Peterson	3	575
Using formula-generated figures in excel in mail-merging [email protected]	by Luke M	1	611
IF(M2="","",(NETWORKDAYS(F2,M2))+TIME(17,0,0)-F2+M2-TIME(8,0,0)) catts22	by Luke M	7	557
Help with year to date comparison danny	by danny	4	1,039
Is there a character paste limit per cell? JAH	by JAH	4	1,894
Search adjacent cells in Column for sequence [email protected]	by T. Valko	3	982
How can I have Excel conditionally copy a cell CA_stateworker	by CA_stateworker	2	564
Sum and percent in differrent worksheet and file finditsol	by finditsol	0	468
Count values in column only if value of another column is true MikeB	by ryguy7272	4	2,680
Formula to add depending upon value entered lheck77	by lheck77	4	445
Change workbook TAB text colour in excel Office 2000 Night Hawk	by Pete_UK	1	810
Help with parameter substitution in formula (&value), vbScript circuit_breaker	by Don Guillett	1	1,354
MATCH to ignore blank cells in array Tony Gardner	by Ashish Mathur[_2_]	3	5,730
Customizing a dictionary Grant	by Dave Peterson	3	578
VBA Shapes NPell	by NPell	1	710
Pivot Table from linked spreadsheets Normek	by Normek	1	736
Line copy - Not just a simple copy paste Ninerref	by Normek	3	624
Can you have a value created by a function replace the function? xak1222	by Pete_UK	3	466
VLOOKUP Formulas Gayle B	by Dan DeHaven[_5_]	5	641
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,219
Hours to Minutes Formula Ana24	by Ashish Mathur[_2_]	4	633
Sum formulas Workin girl[_2_]	by T. Valko	3	407
Need help tedious work... Soth	by Ashish Mathur[_2_]	4	429
Hide a worksheet mac	by pshepard[_2_]	2	376
Translating Dates to a Visual english4518	by pshepard[_2_]	2	407
Please explain YIELDMAT function JoeU2004	by Stephen Bye[_2_]	9	1,120
Is this formula possible in Excel 2003? anschutz.177[_2_]	by Pete_UK	1	397
How do I check if a cell is formatted as a date in Excel VB? Alex@LM	by Alex@LM[_2_]	2	888
Running total in blank cells RAZielinski	by Don Guillett	3	1,466
Truncate a series of numbers Carrie_Loos via OfficeKB.com	by Carrie_Loos via OfficeKB.com	3	575
Create a complex formula Workin girl	by pogiman via OfficeKB.com	2	594
ADODB Connection fi.or.jp.de	by fi.or.jp.de	0	481
Calculating hr/min format Lee Ann[_2_]	by Trev B	6	535
How to make a spreadsheet idiot-proof Howard	by Howard	6	1,957
Sheet won't reference a named cell Mike H	by Mike H	2	911
VLOOKUP and Concatenation PAL	by pshepard[_2_]	5	675
Select Case ignored Preschool Mike	by Dave Peterson	4	586
Mutliply rows in big amounts vb43	by Luke M	4	444
match and extract Dinesh	by dinesh	5	528
formula Kris	by Kris	6	389
date/time average Hookette	by Jacob Skaria	2	436
Use match function to add different item in Combobox Leonard Lan	by Leonard Lan	2	759
LOOK UP AND SUM AC	by Teethless mama	2	511
IRR, with cash flows in non-adjacent cells Nick Ng	by JoeU2004	6	1,843
Excel - How do I make a cell calculate from another page or tab Mitch Harrison	by Luke M	1	1,615
Multiple sheets!!! mptx	by Luke M	1	412
Find last column matching criteria KCK	by KCK	2	446
How do I perform a calculation on a 20 digit number in an excel ? vaishali	by Hans Terkelsen	1	599
A little VBA help please: collect row value not column Preschool Mike	by Preschool Mike	5	740
formula for separating parts of cells Jamie	by confused!!	18	1,245
why does a sumproduct formula return a #div/0! goonie	by Max	6	1,030
Hiding tabs for just some sheets. Romileyrunner1	by Ashish Mathur[_2_]	4	480
sum and if Dave	by Ashish Mathur[_2_]	4	678
Need Help to do the following - new to references mmonti	by Ashish Mathur[_2_]	3	348
How do I copy and paste only the sub-total from a list Klutz	by Ashish Mathur[_2_]	3	1,118
Prevent Tab from User Delete Ardy	by ardy	2	933
how do i delete spaces in multiple cells thoughout the workbook? Starr	by ryguy7272	3	1,701
File error: data may have been lost Karl	by ryguy7272	1	931
Circular reference, Indirect, and Sum cmrandom22	by ryguy7272	3	2,605
Getting 2 different answers for simple count Access Joe	by Pete_UK	3	623