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,368
finding the largest number from the last row and look up its name. Jeff	by Max	5	659
extract data from a range of cells in rows or columns when a date. Dartyon	by Dartyon	0	847
Sub-total feature is unavailable in Office 2003 Excel cawhitaker	by Peo Sjoblom	5	937
Capturing query table errors T. Erkson	by T. Erkson	1	521
Incrementing formula by two rows Ben Hur	by Steve	1	564
Match function selecting first value it matches on exactly Paul K.	by Bernd Plumhoff	1	1,233
VLookup? Right function? Timmers	by Biff	1	445
Can I use the contents of a cell to satisfy the result_vector arg. robh_2	by RagDyer	3	1,212
Excel shifts to wrong worksheet automatically Tom77	by dave	1	970
how do i open a 2003 file into an xp spreadsheet windylyndy	by Ken Wright	2	567
SUM a column with errors Joe Gieder	by Joe Gieder	3	626
Excel should allow a number formats of HEX, OCT and BIN. Neil	by Harlan Grove	3	524
Concatenating Dates jadams-bellevue	by jadams-bellevue	2	525
opening worksheet is "packing list" usrofc	by Gord Dibben	1	735
is there a more efficient formula than... Wazooli	by Ken Wright	6	755
How I show, automatically, the tab name on a cell, in Excel? CPortilloTroconis	by Sarah	4	765
"count if" function based on value of another cell Anauna	by Bernie Deitrick	3	4,516
why do my spreadsheet gridlines only prints half way on the page?. gardnere	by BobT	2	1,643
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly	by Peo Sjoblom	1	709
Check for errors Pat	by Peo Sjoblom	3	359
Excel should support DAYOFYEAR(year,month,day) returns julian dat. Neil	by Jason Morin	1	651
Worksheet Function - Find? DAA	by DAA	2	1,335
Formula presumes cells have data Pat	by Peo Sjoblom	1	542
How can I write a formula or an argument to highlight a date when. saffield	by Jason Morin	1	459
Can I put Pop up menus on Excel Ricardo Munoz	by Bob Phillips	2	442
What does a "plus" cursor mean (in lieu of the pointer?)? thanks S. Hegge	by Peo Sjoblom	4	741
how do i set up a formulas with an if date? Thunley	by Peo Sjoblom	3	674
unwanted number to date conversion while pasting data from web Jacek	by Peo Sjoblom	1	1,503
converting to numbers smintey	by Peo Sjoblom	1	501
Using INDEX & AND Joe Gieder	by Joe Gieder	0	416
text splits down cells d-man	by Fred	1	464
Tje opposite appears to be happening Pat	by Bob Phillips	5	615
Use address function or other Doug Laidlaw	by Jason Morin	1	417
What's wrong with this vb? DaveMoore	by DaveMoore	2	610
Protect the formula but change result. ArchieBoy	by Bob Phillips	1	395
Match or vlookup? Manos	by Jerry W. Lewis	1	414
Multipart formula needed Barb	by ewan7279	2	586
Help with Pivot Chart SteveJ	by SteveJ	0	441
find LAST match in column Pantryman	by Aladin Akyurek	7	4,345
Want to return a value based on a whether a number is within a ra. laurieevan	by JulieD	3	699
formula to extract specific data if match occurs jerry	by Aladin Akyurek	2	857
Compare cell values Grant	by Grant	5	800
VLOOKUP or MATCH Jaladino	by David McRitchie	1	488
Learn formulas Kevin Henderson	by David McRitchie	1	526
how to set a 6-day work week ? RobertH	by Bob Phillips	1	899
sumproduct function Andreea Moyes via OfficeKB.com	by Aladin Akyurek	3	571
problem working with time data imported from text file afaqm	by Biff	1	945
How to have multiple columns in pivot table data area? mitch1962	by mitch1962	0	704
weight formula [email protected]	by Ragdyer	4	747
every nth cell by columns not rows.... Sampson	by Biff	1	622
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R.	by Mike R.	2	877
find data from other sheet Jaladino	by Biff	1	744
Is there a way to automatically add columns as the data updates? Eric D.	by Eric D.	1	650
Pesky VLookup !!! Lacklustre	by Curt	4	634
Vlook up or index match jerry	by Curt	1	560
Bringing additional information in with combo box selection JD	by Debra Dalgleish	1	489
How to have multiple columns in pivot table data area? mitch1962	by Debra Dalgleish	1	1,399
Formula doesnt work Kevin	by Kevin	2	638
Ref to Tab Name briank	by Harlan Grove	3	436
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,891
function needed David Harrison	by [email protected]	1	621
Can I increase row capacity beyond 65536 rows Trish	by Harlan Grove	2	873
Complex(?) Edit Kanga 85	by Kanga 85	3	369
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	738
How do i transfer certain lines from one list to another matt_hull1979	by Max	3	445
Need Formula to display pivot table source data Don S	by Debra Dalgleish	3	2,251
Convert 20050118 to a working date field Jessica	by Ken Wright	7	796
Counting... Patrick G	by Steve	3	733
Winnowing a list NL	by NL	6	371
Summing part of an Alpha Numeric String Arturo	by Arturo	2	722
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS FORMULA	by FORMULA	4	1,050
In Excel what can I use for the XINDEX function from Lotus 123? Val from ICB	by Ken Wright	2	878
I want to print out the sheet tabs (sheet names) Sundus	by Gord Dibben	3	1,166
conditional formatting-shading Shooter	by Jason Morin	2	532