Excel Worksheet Functions - Page 137

Thread / Thread Starter	Last Post	Replies	Views
Yieldmat function BarryHWhite	by JoeU2004	8	2,342
Normalizing data? pm	by Dana DeLouis[_3_]	2	1,068
Highest alphanumeric B. Liggett	by T. Valko	6	783
Excel 2007: =DSUM not working as expected Dan	by Ashish Mathur[_2_]	4	853
SORT/FILTER ISSUE Munfarid	by Ashish Mathur[_2_]	4	513
Using "COUNTIF" and "AND" functions together trevor	by Ashish Mathur[_2_]	6	845
multiple sheet looks up and match dinesh	by Ashish Mathur[_2_]	4	427
add data in column related to cell in another column - see full de Migty	by MS-Exl-Learner	1	747
Need to replace one dynamic variable with another dynamic variable djreason	by Jacob Skaria	8	654
multiple sheet lookup or match Vegas Sara	by Jacob Skaria	4	643
"This cell is inconsistent with the column formula" error Nebulous	by Nebulous	4	7,099
How to transpose and concatenate long list in one column? CSchwass	by Gord Dibben	12	3,407
rota calculations eventhorse	by smartin	1	903
Lookup in External Worksheet Lady Success	by JICDB	7	711
How do I repeat rows at the top of SOME of the pages in Excel IM333	by Dave Peterson	2	4,942
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	559
Help with year to date comparison danny	by danny	4	1,042
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	983
How can I have Excel conditionally copy a cell CA_stateworker	by CA_stateworker	2	569
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,686
Formula to add depending upon value entered lheck77	by lheck77	4	446
Change workbook TAB text colour in excel Office 2000 Night Hawk	by Pete_UK	1	811
Help with parameter substitution in formula (&value), vbScript circuit_breaker	by Don Guillett	1	1,355
MATCH to ignore blank cells in array Tony Gardner	by Ashish Mathur[_2_]	3	5,734
Customizing a dictionary Grant	by Dave Peterson	3	584
VBA Shapes NPell	by NPell	1	714
Pivot Table from linked spreadsheets Normek	by Normek	1	753
Line copy - Not just a simple copy paste Ninerref	by Normek	3	630
Can you have a value created by a function replace the function? xak1222	by Pete_UK	3	468
VLOOKUP Formulas Gayle B	by Dan DeHaven[_5_]	5	642
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,220
Hours to Minutes Formula Ana24	by Ashish Mathur[_2_]	4	634
Sum formulas Workin girl[_2_]	by T. Valko	3	407
Need help tedious work... Soth	by Ashish Mathur[_2_]	4	430
Hide a worksheet mac	by pshepard[_2_]	2	381
Translating Dates to a Visual english4518	by pshepard[_2_]	2	407
Please explain YIELDMAT function JoeU2004	by Stephen Bye[_2_]	9	1,126
Is this formula possible in Excel 2003? anschutz.177[_2_]	by Pete_UK	1	398
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,467
Truncate a series of numbers Carrie_Loos via OfficeKB.com	by Carrie_Loos via OfficeKB.com	3	576
Create a complex formula Workin girl	by pogiman via OfficeKB.com	2	595
ADODB Connection fi.or.jp.de	by fi.or.jp.de	0	486
Calculating hr/min format Lee Ann[_2_]	by Trev B	6	536
How to make a spreadsheet idiot-proof Howard	by Howard	6	1,958
Sheet won't reference a named cell Mike H	by Mike H	2	913
VLOOKUP and Concatenation PAL	by pshepard[_2_]	5	677
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	529
formula Kris	by Kris	6	390
date/time average Hookette	by Jacob Skaria	2	437
Use match function to add different item in Combobox Leonard Lan	by Leonard Lan	2	762
LOOK UP AND SUM AC	by Teethless mama	2	512
IRR, with cash flows in non-adjacent cells Nick Ng	by JoeU2004	6	1,844
Excel - How do I make a cell calculate from another page or tab Mitch Harrison	by Luke M	1	1,616
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	600
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,031
Hiding tabs for just some sheets. Romileyrunner1	by Ashish Mathur[_2_]	4	480
sum and if Dave	by Ashish Mathur[_2_]	4	679
Need Help to do the following - new to references mmonti	by Ashish Mathur[_2_]	3	349
How do I copy and paste only the sub-total from a list Klutz	by Ashish Mathur[_2_]	3	1,119
Prevent Tab from User Delete Ardy	by ardy	2	935
how do i delete spaces in multiple cells thoughout the workbook? Starr	by ryguy7272	3	1,703
File error: data may have been lost Karl	by ryguy7272	1	931
Circular reference, Indirect, and Sum cmrandom22	by ryguy7272	3	2,606
Getting 2 different answers for simple count Access Joe	by Pete_UK	3	623