Excel Worksheet Functions - Page 915

Thread / Thread Starter	Last Post	Replies	Views
Indirect Formula fullers	by Bob Phillips	3	460
How do I convert a text string into a date? JJMCDD02	by JJMCDD02	4	1,462
convert numercials into words Younus Khatri	by Paul B	1	683
calculate ranges Bob Bedford	by Bob Bedford	6	521
Validation List Dilip Mistry	by	3	434
Find max date philcud	by philcud	6	536
Help with formula Ben	by Ben	2	457
In Excel: select the last 20 rows of data in a column Tad Blanchard	by Bob Phillips	2	1,180
Problems with setting up a billing budjet JoeStL	by Roger Govier	1	487
how to change absolute path to relative path hwijgerse	by hwijgerse	0	2,233
vlookup using two lookup values? tjb	by Krishnakumar	10	1,603
Find last non-blank row with a worksheet function Bruce	by Bruce	2	971
complex amortization cfspahn24	by Fred Smith	1	867
Rounding Bud	by [email protected]	3	476
Count cell ecohen1	by Ashish Mathur	3	539
How easy is it to loop in VBA based on cell contents? Lee Harris	by Gord Dibben	3	992
best formula to use raw	by Gord Dibben	2	428
How to summarize the first 4 numbers greater than 0 from a list. Antonio	by Peo Sjoblom	7	837
Selecting a range of values for another function Sergun	by Sergun	4	783
How do I extract data from graph (i.e. interpolaton) TauBrewer	by Gary''s Student	1	592
Error in "IF" formula reloanpro	by reloanpro	4	526
Why is my printer printing white fonts as black? Howie	by Gord Dibben	2	1,771
Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats DORI	by DORI	2	2,666
returning a cell's value and a corresponding value Force Flow	by Force Flow	2	466
Two dimensional lookup CDog	by CDog	6	1,169
Help! BradleyLawrence	by BradleyLawrence	5	516
Is this possible please someone help me ?? spuds	by Roger Govier	2	439
Hour and minute MaryK	by Peo Sjoblom	3	513
Time code cell format pauls510	by Bob Phillips	1	573
Matrix Dimension Michelle	by Peo Sjoblom	1	575
How do I do an amortization schedule knowing the princ, int rate,. cfspahn24	by cfspahn24	5	1,322
Calculating percentages in pivot tables on subtotals David Ruderman - Chapman University	by cs02000	1	1,677
Click button to automatically add row yirawan	by Ron de Bruin	1	5,189
Excel - need a function to compare lists JerryMatson	by Niek Otten	1	908
VLOOKUP Problem uplink600	by Roger Govier	2	457
how to fetch a row and post the row into another sheelt ananthmca2004	by Roland	1	414
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,463
Part of text as criteria irresistible007	by Bruno Campanini	2	452
Visual Basic I/O error when opening Excel file SK Low	by SK Low	0	715
Help with SUMPRODUCT Robo	by Robo	4	423
lock tab in sheet 2 until cell in sheet one is completed john tempest	by john tempest	7	1,212
populating empty cell with value from above PY & Associates	by PY & Associates	4	535
Autofilter Locks??? cybermrt	by cybermrt	2	551
How to tackle Division by zero for DAVERAGE function Sharma	by Biff	1	944
formula looking up multiple information. Tamara	by Biff	4	415
select based on word CDS being in description field Joe D	by Joe D	2	464
GETPIVOTDATA question regarding adding "rows" CamiK	by Debra Dalgleish	1	612
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	592
Match Last Occurrence of Numeric Value and Count BACK to Previous Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,554
Formula/Array question with dates Renee	by DOR	1	537
Column labels SN	by SN	3	781
Referencing a different Workbook Ken	by Max	8	610
networkdays rsenn	by rsenn	0	565
vb code - Automatic transfer of data from one sheet to another herr_bench	by Gord Dibben	1	1,493
Printing Certain Columns DonDon	by Dave Peterson	1	629
Nested IF with OR Function Trudy	by Roger Govier	5	730
matching data from column b tbax6	by bpeltzer	1	637
I need to Sum the value D2:G1000 Steved	by Steved	2	482
how many if statements can i use in a single cell ? Kypreo	by Roger Govier	5	1,061
Can criteria in countif statement be a color? aosbor	by Bob Phillips	1	1,009
Assign Date Formatting To Button MDW	by MDW	0	430
Enable automatic refresh link Deb Bagby	by Deb Bagby	0	818
How do I set up a conditional cell from a drop down list in Excel Mon	by SteveG	3	826
Ignoring Time in a Date Time Calculation nmp	by nmp	3	4,663
Enable automatic refresh Deb Bagby	by Deb Bagby	0	797
Time and Business Hours Brett	by Biff	1	618
What excel function to use? Excel user	by Bob Phillips	1	423
Multiple Validations in for 1 cell dmcnutt_ghg	by Bob Phillips	1	656
count and lookup eoht	by Bob Phillips	1	492
Nested --- Subtotal IF function Lisa Beach	by Bob Phillips	3	4,283
Trying to do something that may not be possible RS-PLH	by RS-PLH	0	380
How to add a column of accumulated data in pivottable? Angus	by cs02000	1	1,093