Excel Worksheet Functions - Page 1103

Thread / Thread Starter	Last Post	Replies	Views
convert a numerical currency into word format Rojo	by Fredrik Wahlgren	1	1,346
finding the largest number from the last row and look up its name. Jeff	by Max	5	645
extract data from a range of cells in rows or columns when a date. Dartyon	by Dartyon	0	834
Sub-total feature is unavailable in Office 2003 Excel cawhitaker	by Peo Sjoblom	5	886
Capturing query table errors T. Erkson	by T. Erkson	1	505
Incrementing formula by two rows Ben Hur	by Steve	1	537
Match function selecting first value it matches on exactly Paul K.	by Bernd Plumhoff	1	1,203
VLookup? Right function? Timmers	by Biff	1	435
Can I use the contents of a cell to satisfy the result_vector arg. robh_2	by RagDyer	3	1,164
Excel shifts to wrong worksheet automatically Tom77	by dave	1	952
how do i open a 2003 file into an xp spreadsheet windylyndy	by Ken Wright	2	556
SUM a column with errors Joe Gieder	by Joe Gieder	3	612
Excel should allow a number formats of HEX, OCT and BIN. Neil	by Harlan Grove	3	508
Concatenating Dates jadams-bellevue	by jadams-bellevue	2	513
opening worksheet is "packing list" usrofc	by Gord Dibben	1	718
is there a more efficient formula than... Wazooli	by Ken Wright	6	744
How I show, automatically, the tab name on a cell, in Excel? CPortilloTroconis	by Sarah	4	760
"count if" function based on value of another cell Anauna	by Bernie Deitrick	3	4,457
why do my spreadsheet gridlines only prints half way on the page?. gardnere	by BobT	2	1,628
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly	by Peo Sjoblom	1	693
Check for errors Pat	by Peo Sjoblom	3	358
Excel should support DAYOFYEAR(year,month,day) returns julian dat. Neil	by Jason Morin	1	644
Worksheet Function - Find? DAA	by DAA	2	1,323
Formula presumes cells have data Pat	by Peo Sjoblom	1	531
How can I write a formula or an argument to highlight a date when. saffield	by Jason Morin	1	452
Can I put Pop up menus on Excel Ricardo Munoz	by Bob Phillips	2	429
What does a "plus" cursor mean (in lieu of the pointer?)? thanks S. Hegge	by Peo Sjoblom	4	731
how do i set up a formulas with an if date? Thunley	by Peo Sjoblom	3	663
unwanted number to date conversion while pasting data from web Jacek	by Peo Sjoblom	1	1,483
converting to numbers smintey	by Peo Sjoblom	1	485
Using INDEX & AND Joe Gieder	by Joe Gieder	0	413
text splits down cells d-man	by Fred	1	454
Tje opposite appears to be happening Pat	by Bob Phillips	5	597
Use address function or other Doug Laidlaw	by Jason Morin	1	414
What's wrong with this vb? DaveMoore	by DaveMoore	2	588
Protect the formula but change result. ArchieBoy	by Bob Phillips	1	383
Match or vlookup? Manos	by Jerry W. Lewis	1	410
Multipart formula needed Barb	by ewan7279	2	576
Help with Pivot Chart SteveJ	by SteveJ	0	435
find LAST match in column Pantryman	by Aladin Akyurek	7	4,331
Want to return a value based on a whether a number is within a ra. laurieevan	by JulieD	3	692
formula to extract specific data if match occurs jerry	by Aladin Akyurek	2	844
Compare cell values Grant	by Grant	5	796
VLOOKUP or MATCH Jaladino	by David McRitchie	1	471
Learn formulas Kevin Henderson	by David McRitchie	1	507
how to set a 6-day work week ? RobertH	by Bob Phillips	1	884
sumproduct function Andreea Moyes via OfficeKB.com	by Aladin Akyurek	3	559
problem working with time data imported from text file afaqm	by Biff	1	930
How to have multiple columns in pivot table data area? mitch1962	by mitch1962	0	693
weight formula [email protected]	by Ragdyer	4	732
every nth cell by columns not rows.... Sampson	by Biff	1	615
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R.	by Mike R.	2	869
find data from other sheet Jaladino	by Biff	1	731
Is there a way to automatically add columns as the data updates? Eric D.	by Eric D.	1	641
Pesky VLookup !!! Lacklustre	by Curt	4	628
Vlook up or index match jerry	by Curt	1	544
Bringing additional information in with combo box selection JD	by Debra Dalgleish	1	479
How to have multiple columns in pivot table data area? mitch1962	by Debra Dalgleish	1	1,381
Formula doesnt work Kevin	by Kevin	2	623
Ref to Tab Name briank	by Harlan Grove	3	428
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,874
function needed David Harrison	by [email protected]	1	609
Can I increase row capacity beyond 65536 rows Trish	by Harlan Grove	2	865
Complex(?) Edit Kanga 85	by Kanga 85	3	355
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	729
How do i transfer certain lines from one list to another matt_hull1979	by Max	3	434
Need Formula to display pivot table source data Don S	by Debra Dalgleish	3	2,242
Convert 20050118 to a working date field Jessica	by Ken Wright	7	780
Counting... Patrick G	by Steve	3	698
Winnowing a list NL	by NL	6	360
Summing part of an Alpha Numeric String Arturo	by Arturo	2	709
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS FORMULA	by FORMULA	4	1,040
In Excel what can I use for the XINDEX function from Lotus 123? Val from ICB	by Ken Wright	2	864
I want to print out the sheet tabs (sheet names) Sundus	by Gord Dibben	3	1,149
conditional formatting-shading Shooter	by Jason Morin	2	519