Excel Worksheet Functions - Page 137

Thread / Thread Starter	Last Post	Replies	Views
Yieldmat function BarryHWhite	by JoeU2004	8	2,352
Normalizing data? pm	by Dana DeLouis[_3_]	2	1,078
Highest alphanumeric B. Liggett	by T. Valko	6	784
Excel 2007: =DSUM not working as expected Dan	by Ashish Mathur[_2_]	4	853
SORT/FILTER ISSUE Munfarid	by Ashish Mathur[_2_]	4	518
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	756
Need to replace one dynamic variable with another dynamic variable djreason	by Jacob Skaria	8	655
multiple sheet lookup or match Vegas Sara	by Jacob Skaria	4	644
"This cell is inconsistent with the column formula" error Nebulous	by Nebulous	4	7,110
How to transpose and concatenate long list in one column? CSchwass	by Gord Dibben	12	3,417
rota calculations eventhorse	by smartin	1	904
Lookup in External Worksheet Lady Success	by JICDB	7	712
How do I repeat rows at the top of SOME of the pages in Excel IM333	by Dave Peterson	2	4,953
Variable used in a =SUMIF() function? circuit_breaker	by Dave Peterson	3	577
Using formula-generated figures in excel in mail-merging [email protected]	by Luke M	1	618
IF(M2="","",(NETWORKDAYS(F2,M2))+TIME(17,0,0)-F2+M2-TIME(8,0,0)) catts22	by Luke M	7	560
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,895
Search adjacent cells in Column for sequence [email protected]	by T. Valko	3	993
How can I have Excel conditionally copy a cell CA_stateworker	by CA_stateworker	2	576
Sum and percent in differrent worksheet and file finditsol	by finditsol	0	469
Count values in column only if value of another column is true MikeB	by ryguy7272	4	2,695
Formula to add depending upon value entered lheck77	by lheck77	4	456
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,366
MATCH to ignore blank cells in array Tony Gardner	by Ashish Mathur[_2_]	3	5,744
Customizing a dictionary Grant	by Dave Peterson	3	595
VBA Shapes NPell	by NPell	1	715
Pivot Table from linked spreadsheets Normek	by Normek	1	763
Line copy - Not just a simple copy paste Ninerref	by Normek	3	641
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	652
Sort Columns of data at the same time, without regard to order. Herc	by Ashish Mathur[_2_]	3	1,230
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	382
Translating Dates to a Visual english4518	by pshepard[_2_]	2	417
Please explain YIELDMAT function JoeU2004	by Stephen Bye[_2_]	9	1,132
Is this formula possible in Excel 2003? anschutz.177[_2_]	by Pete_UK	1	406
How do I check if a cell is formatted as a date in Excel VB? Alex@LM	by Alex@LM[_2_]	2	898
Running total in blank cells RAZielinski	by Don Guillett	3	1,477
Truncate a series of numbers Carrie_Loos via OfficeKB.com	by Carrie_Loos via OfficeKB.com	3	581
Create a complex formula Workin girl	by pogiman via OfficeKB.com	2	605
ADODB Connection fi.or.jp.de	by fi.or.jp.de	0	491
Calculating hr/min format Lee Ann[_2_]	by Trev B	6	536
How to make a spreadsheet idiot-proof Howard	by Howard	6	1,963
Sheet won't reference a named cell Mike H	by Mike H	2	923
VLOOKUP and Concatenation PAL	by pshepard[_2_]	5	687
Select Case ignored Preschool Mike	by Dave Peterson	4	593
Mutliply rows in big amounts vb43	by Luke M	4	444
match and extract Dinesh	by dinesh	5	534
formula Kris	by Kris	6	391
date/time average Hookette	by Jacob Skaria	2	437
Use match function to add different item in Combobox Leonard Lan	by Leonard Lan	2	768
LOOK UP AND SUM AC	by Teethless mama	2	512
IRR, with cash flows in non-adjacent cells Nick Ng	by JoeU2004	6	1,845
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	749
formula for separating parts of cells Jamie	by confused!!	18	1,248
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	488
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	945
how do i delete spaces in multiple cells thoughout the workbook? Starr	by ryguy7272	3	1,713
File error: data may have been lost Karl	by ryguy7272	1	941
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