Excel Worksheet Functions - Page 915

Thread / Thread Starter	Last Post	Replies	Views
Indirect Formula fullers	by Bob Phillips	3	463
How do I convert a text string into a date? JJMCDD02	by JJMCDD02	4	1,469
convert numercials into words Younus Khatri	by Paul B	1	686
calculate ranges Bob Bedford	by Bob Bedford	6	532
Validation List Dilip Mistry	by	3	442
Find max date philcud	by philcud	6	547
Help with formula Ben	by Ben	2	460
In Excel: select the last 20 rows of data in a column Tad Blanchard	by Bob Phillips	2	1,189
Problems with setting up a billing budjet JoeStL	by Roger Govier	1	488
how to change absolute path to relative path hwijgerse	by hwijgerse	0	2,243
vlookup using two lookup values? tjb	by Krishnakumar	10	1,615
Find last non-blank row with a worksheet function Bruce	by Bruce	2	984
complex amortization cfspahn24	by Fred Smith	1	874
Rounding Bud	by [email protected]	3	483
Count cell ecohen1	by Ashish Mathur	3	551
How easy is it to loop in VBA based on cell contents? Lee Harris	by Gord Dibben	3	1,001
best formula to use raw	by Gord Dibben	2	430
How to summarize the first 4 numbers greater than 0 from a list. Antonio	by Peo Sjoblom	7	848
Selecting a range of values for another function Sergun	by Sergun	4	798
How do I extract data from graph (i.e. interpolaton) TauBrewer	by Gary''s Student	1	607
Error in "IF" formula reloanpro	by reloanpro	4	534
Why is my printer printing white fonts as black? Howie	by Gord Dibben	2	1,772
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	475
Two dimensional lookup CDog	by CDog	6	1,172
Help! BradleyLawrence	by BradleyLawrence	5	516
Is this possible please someone help me ?? spuds	by Roger Govier	2	440
Hour and minute MaryK	by Peo Sjoblom	3	516
Time code cell format pauls510	by Bob Phillips	1	585
Matrix Dimension Michelle	by Peo Sjoblom	1	582
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,684
Click button to automatically add row yirawan	by Ron de Bruin	1	5,199
Excel - need a function to compare lists JerryMatson	by Niek Otten	1	923
VLOOKUP Problem uplink600	by Roger Govier	2	466
how to fetch a row and post the row into another sheelt ananthmca2004	by Roland	1	427
I would like the worksheet auto name itself with a formula SJA	by Barb Reinhardt	1	459
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	462
Visual Basic I/O error when opening Excel file SK Low	by SK Low	0	724
Help with SUMPRODUCT Robo	by Robo	4	426
lock tab in sheet 2 until cell in sheet one is completed john tempest	by john tempest	7	1,213
populating empty cell with value from above PY & Associates	by PY & Associates	4	548
Autofilter Locks??? cybermrt	by cybermrt	2	554
How to tackle Division by zero for DAVERAGE function Sharma	by Biff	1	952
formula looking up multiple information. Tamara	by Biff	4	424
select based on word CDS being in description field Joe D	by Joe D	2	475
GETPIVOTDATA question regarding adding "rows" CamiK	by Debra Dalgleish	1	623
How to create a prefix containing text and zero? GeneWan	by GeneWan	10	1,333
match values in two different columns thomasNg	by Max	2	729
Have 2 items in dropdown, want warning if one selected movermike	by L. Howard Kittle	1	602
Match Last Occurrence of Numeric Value and Count BACK to Previous Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,567
Formula/Array question with dates Renee	by DOR	1	545
Column labels SN	by SN	3	787
Referencing a different Workbook Ken	by Max	8	620
networkdays rsenn	by rsenn	0	574
vb code - Automatic transfer of data from one sheet to another herr_bench	by Gord Dibben	1	1,494
Printing Certain Columns DonDon	by Dave Peterson	1	641
Nested IF with OR Function Trudy	by Roger Govier	5	743
matching data from column b tbax6	by bpeltzer	1	646
I need to Sum the value D2:G1000 Steved	by Steved	2	494
how many if statements can i use in a single cell ? Kypreo	by Roger Govier	5	1,071
Can criteria in countif statement be a color? aosbor	by Bob Phillips	1	1,021
Assign Date Formatting To Button MDW	by MDW	0	440
Enable automatic refresh link Deb Bagby	by Deb Bagby	0	822
How do I set up a conditional cell from a drop down list in Excel Mon	by SteveG	3	839
Ignoring Time in a Date Time Calculation nmp	by nmp	3	4,677
Enable automatic refresh Deb Bagby	by Deb Bagby	0	797
Time and Business Hours Brett	by Biff	1	619
What excel function to use? Excel user	by Bob Phillips	1	435
Multiple Validations in for 1 cell dmcnutt_ghg	by Bob Phillips	1	665
count and lookup eoht	by Bob Phillips	1	498
Nested --- Subtotal IF function Lisa Beach	by Bob Phillips	3	4,296
Trying to do something that may not be possible RS-PLH	by RS-PLH	0	391
How to add a column of accumulated data in pivottable? Angus	by cs02000	1	1,106