Excel Worksheet Functions - Page 915

Thread / Thread Starter	Last Post	Replies	Views
Indirect Formula fullers	by Bob Phillips	3	458
How do I convert a text string into a date? JJMCDD02	by JJMCDD02	4	1,404
convert numercials into words Younus Khatri	by Paul B	1	681
calculate ranges Bob Bedford	by Bob Bedford	6	519
Validation List Dilip Mistry	by	3	433
Find max date philcud	by philcud	6	534
Help with formula Ben	by Ben	2	456
In Excel: select the last 20 rows of data in a column Tad Blanchard	by Bob Phillips	2	1,179
Problems with setting up a billing budjet JoeStL	by Roger Govier	1	485
how to change absolute path to relative path hwijgerse	by hwijgerse	0	2,197
vlookup using two lookup values? tjb	by Krishnakumar	10	1,601
Find last non-blank row with a worksheet function Bruce	by Bruce	2	970
complex amortization cfspahn24	by Fred Smith	1	866
Rounding Bud	by [email protected]	3	475
Count cell ecohen1	by Ashish Mathur	3	538
How easy is it to loop in VBA based on cell contents? Lee Harris	by Gord Dibben	3	990
best formula to use raw	by Gord Dibben	2	427
How to summarize the first 4 numbers greater than 0 from a list. Antonio	by Peo Sjoblom	7	834
Selecting a range of values for another function Sergun	by Sergun	4	782
How do I extract data from graph (i.e. interpolaton) TauBrewer	by Gary''s Student	1	590
Error in "IF" formula reloanpro	by reloanpro	4	523
Why is my printer printing white fonts as black? Howie	by Gord Dibben	2	1,693
Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats DORI	by DORI	2	2,660
returning a cell's value and a corresponding value Force Flow	by Force Flow	2	465
Two dimensional lookup CDog	by CDog	6	1,168
Help! BradleyLawrence	by BradleyLawrence	5	514
Is this possible please someone help me ?? spuds	by Roger Govier	2	438
Hour and minute MaryK	by Peo Sjoblom	3	512
Time code cell format pauls510	by Bob Phillips	1	570
Matrix Dimension Michelle	by Peo Sjoblom	1	569
How do I do an amortization schedule knowing the princ, int rate,. cfspahn24	by cfspahn24	5	1,318
Calculating percentages in pivot tables on subtotals David Ruderman - Chapman University	by cs02000	1	1,672
Click button to automatically add row yirawan	by Ron de Bruin	1	5,175
Excel - need a function to compare lists JerryMatson	by Niek Otten	1	903
VLOOKUP Problem uplink600	by Roger Govier	2	456
how to fetch a row and post the row into another sheelt ananthmca2004	by Roland	1	413
I would like the worksheet auto name itself with a formula SJA	by Barb Reinhardt	1	458
Active cell counting in particular print page (one sheet having different print area) ananthmca2004	by antoka05	1	1,384
Part of text as criteria irresistible007	by Bruno Campanini	2	451
Visual Basic I/O error when opening Excel file SK Low	by SK Low	0	709
Help with SUMPRODUCT Robo	by Robo	4	422
lock tab in sheet 2 until cell in sheet one is completed john tempest	by john tempest	7	1,209
populating empty cell with value from above PY & Associates	by PY & Associates	4	534
Autofilter Locks??? cybermrt	by cybermrt	2	549
How to tackle Division by zero for DAVERAGE function Sharma	by Biff	1	941
formula looking up multiple information. Tamara	by Biff	4	414
select based on word CDS being in description field Joe D	by Joe D	2	463
GETPIVOTDATA question regarding adding "rows" CamiK	by Debra Dalgleish	1	611
How to create a prefix containing text and zero? GeneWan	by GeneWan	10	1,331
match values in two different columns thomasNg	by Max	2	717
Have 2 items in dropdown, want warning if one selected movermike	by L. Howard Kittle	1	591
Match Last Occurrence of Numeric Value and Count BACK to Previous Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,553
Formula/Array question with dates Renee	by DOR	1	536
Column labels SN	by SN	3	730
Referencing a different Workbook Ken	by Max	8	608
networkdays rsenn	by rsenn	0	553
vb code - Automatic transfer of data from one sheet to another herr_bench	by Gord Dibben	1	1,491
Printing Certain Columns DonDon	by Dave Peterson	1	628
Nested IF with OR Function Trudy	by Roger Govier	5	726
matching data from column b tbax6	by bpeltzer	1	633
I need to Sum the value D2:G1000 Steved	by Steved	2	481
how many if statements can i use in a single cell ? Kypreo	by Roger Govier	5	1,059
Can criteria in countif statement be a color? aosbor	by Bob Phillips	1	1,008
Assign Date Formatting To Button MDW	by MDW	0	429
Enable automatic refresh link Deb Bagby	by Deb Bagby	0	770
How do I set up a conditional cell from a drop down list in Excel Mon	by SteveG	3	823
Ignoring Time in a Date Time Calculation nmp	by nmp	3	4,660
Enable automatic refresh Deb Bagby	by Deb Bagby	0	750
Time and Business Hours Brett	by Biff	1	616
What excel function to use? Excel user	by Bob Phillips	1	422
Multiple Validations in for 1 cell dmcnutt_ghg	by Bob Phillips	1	656
count and lookup eoht	by Bob Phillips	1	489
Nested --- Subtotal IF function Lisa Beach	by Bob Phillips	3	4,282
Trying to do something that may not be possible RS-PLH	by RS-PLH	0	378
How to add a column of accumulated data in pivottable? Angus	by cs02000	1	1,092