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,356
finding the largest number from the last row and look up its name. Jeff	by Max	5	646
extract data from a range of cells in rows or columns when a date. Dartyon	by Dartyon	0	844
Sub-total feature is unavailable in Office 2003 Excel cawhitaker	by Peo Sjoblom	5	915
Capturing query table errors T. Erkson	by T. Erkson	1	509
Incrementing formula by two rows Ben Hur	by Steve	1	547
Match function selecting first value it matches on exactly Paul K.	by Bernd Plumhoff	1	1,219
VLookup? Right function? Timmers	by Biff	1	437
Can I use the contents of a cell to satisfy the result_vector arg. robh_2	by RagDyer	3	1,201
Excel shifts to wrong worksheet automatically Tom77	by dave	1	968
how do i open a 2003 file into an xp spreadsheet windylyndy	by Ken Wright	2	558
SUM a column with errors Joe Gieder	by Joe Gieder	3	615
Excel should allow a number formats of HEX, OCT and BIN. Neil	by Harlan Grove	3	510
Concatenating Dates jadams-bellevue	by jadams-bellevue	2	515
opening worksheet is "packing list" usrofc	by Gord Dibben	1	722
is there a more efficient formula than... Wazooli	by Ken Wright	6	745
How I show, automatically, the tab name on a cell, in Excel? CPortilloTroconis	by Sarah	4	764
"count if" function based on value of another cell Anauna	by Bernie Deitrick	3	4,508
why do my spreadsheet gridlines only prints half way on the page?. gardnere	by BobT	2	1,639
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly	by Peo Sjoblom	1	694
Check for errors Pat	by Peo Sjoblom	3	359
Excel should support DAYOFYEAR(year,month,day) returns julian dat. Neil	by Jason Morin	1	646
Worksheet Function - Find? DAA	by DAA	2	1,327
Formula presumes cells have data Pat	by Peo Sjoblom	1	533
How can I write a formula or an argument to highlight a date when. saffield	by Jason Morin	1	453
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	733
how do i set up a formulas with an if date? Thunley	by Peo Sjoblom	3	665
unwanted number to date conversion while pasting data from web Jacek	by Peo Sjoblom	1	1,492
converting to numbers smintey	by Peo Sjoblom	1	488
Using INDEX & AND Joe Gieder	by Joe Gieder	0	415
text splits down cells d-man	by Fred	1	457
Tje opposite appears to be happening Pat	by Bob Phillips	5	607
Use address function or other Doug Laidlaw	by Jason Morin	1	416
What's wrong with this vb? DaveMoore	by DaveMoore	2	599
Protect the formula but change result. ArchieBoy	by Bob Phillips	1	383
Match or vlookup? Manos	by Jerry W. Lewis	1	414
Multipart formula needed Barb	by ewan7279	2	578
Help with Pivot Chart SteveJ	by SteveJ	0	436
find LAST match in column Pantryman	by Aladin Akyurek	7	4,342
Want to return a value based on a whether a number is within a ra. laurieevan	by JulieD	3	696
formula to extract specific data if match occurs jerry	by Aladin Akyurek	2	846
Compare cell values Grant	by Grant	5	799
VLOOKUP or MATCH Jaladino	by David McRitchie	1	477
Learn formulas Kevin Henderson	by David McRitchie	1	516
how to set a 6-day work week ? RobertH	by Bob Phillips	1	885
sumproduct function Andreea Moyes via OfficeKB.com	by Aladin Akyurek	3	560
problem working with time data imported from text file afaqm	by Biff	1	932
How to have multiple columns in pivot table data area? mitch1962	by mitch1962	0	694
weight formula [email protected]	by Ragdyer	4	735
every nth cell by columns not rows.... Sampson	by Biff	1	620
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R.	by Mike R.	2	869
find data from other sheet Jaladino	by Biff	1	733
Is there a way to automatically add columns as the data updates? Eric D.	by Eric D.	1	642
Pesky VLookup !!! Lacklustre	by Curt	4	628
Vlook up or index match jerry	by Curt	1	545
Bringing additional information in with combo box selection JD	by Debra Dalgleish	1	481
How to have multiple columns in pivot table data area? mitch1962	by Debra Dalgleish	1	1,389
Formula doesnt work Kevin	by Kevin	2	631
Ref to Tab Name briank	by Harlan Grove	3	429
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,880
function needed David Harrison	by [email protected]	1	616
Can I increase row capacity beyond 65536 rows Trish	by Harlan Grove	2	868
Complex(?) Edit Kanga 85	by Kanga 85	3	359
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	730
How do i transfer certain lines from one list to another matt_hull1979	by Max	3	435
Need Formula to display pivot table source data Don S	by Debra Dalgleish	3	2,249
Convert 20050118 to a working date field Jessica	by Ken Wright	7	785
Counting... Patrick G	by Steve	3	718
Winnowing a list NL	by NL	6	361
Summing part of an Alpha Numeric String Arturo	by Arturo	2	712
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS FORMULA	by FORMULA	4	1,042
In Excel what can I use for the XINDEX function from Lotus 123? Val from ICB	by Ken Wright	2	868
I want to print out the sheet tabs (sheet names) Sundus	by Gord Dibben	3	1,153
conditional formatting-shading Shooter	by Jason Morin	2	520