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,304
finding the largest number from the last row and look up its name. Jeff	by Max	5	627
extract data from a range of cells in rows or columns when a date. Dartyon	by Dartyon	0	811
Sub-total feature is unavailable in Office 2003 Excel cawhitaker	by Peo Sjoblom	5	858
Capturing query table errors T. Erkson	by T. Erkson	1	493
Incrementing formula by two rows Ben Hur	by Steve	1	518
Match function selecting first value it matches on exactly Paul K.	by Bernd Plumhoff	1	1,168
VLookup? Right function? Timmers	by Biff	1	417
Can I use the contents of a cell to satisfy the result_vector arg. robh_2	by RagDyer	3	1,137
Excel shifts to wrong worksheet automatically Tom77	by dave	1	928
how do i open a 2003 file into an xp spreadsheet windylyndy	by Ken Wright	2	530
SUM a column with errors Joe Gieder	by Joe Gieder	3	584
Excel should allow a number formats of HEX, OCT and BIN. Neil	by Harlan Grove	3	478
Concatenating Dates jadams-bellevue	by jadams-bellevue	2	494
opening worksheet is "packing list" usrofc	by Gord Dibben	1	696
is there a more efficient formula than... Wazooli	by Ken Wright	6	730
How I show, automatically, the tab name on a cell, in Excel? CPortilloTroconis	by Sarah	4	743
"count if" function based on value of another cell Anauna	by Bernie Deitrick	3	4,431
why do my spreadsheet gridlines only prints half way on the page?. gardnere	by BobT	2	1,613
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly	by Peo Sjoblom	1	673
Check for errors Pat	by Peo Sjoblom	3	353
Excel should support DAYOFYEAR(year,month,day) returns julian dat. Neil	by Jason Morin	1	634
Worksheet Function - Find? DAA	by DAA	2	1,296
Formula presumes cells have data Pat	by Peo Sjoblom	1	504
How can I write a formula or an argument to highlight a date when. saffield	by Jason Morin	1	442
Can I put Pop up menus on Excel Ricardo Munoz	by Bob Phillips	2	419
What does a "plus" cursor mean (in lieu of the pointer?)? thanks S. Hegge	by Peo Sjoblom	4	709
how do i set up a formulas with an if date? Thunley	by Peo Sjoblom	3	645
unwanted number to date conversion while pasting data from web Jacek	by Peo Sjoblom	1	1,457
converting to numbers smintey	by Peo Sjoblom	1	472
Using INDEX & AND Joe Gieder	by Joe Gieder	0	399
text splits down cells d-man	by Fred	1	443
Tje opposite appears to be happening Pat	by Bob Phillips	5	586
Use address function or other Doug Laidlaw	by Jason Morin	1	400
What's wrong with this vb? DaveMoore	by DaveMoore	2	576
Protect the formula but change result. ArchieBoy	by Bob Phillips	1	370
Match or vlookup? Manos	by Jerry W. Lewis	1	388
Multipart formula needed Barb	by ewan7279	2	548
Help with Pivot Chart SteveJ	by SteveJ	0	431
find LAST match in column Pantryman	by Aladin Akyurek	7	4,292
Want to return a value based on a whether a number is within a ra. laurieevan	by JulieD	3	673
formula to extract specific data if match occurs jerry	by Aladin Akyurek	2	826
Compare cell values Grant	by Grant	5	765
VLOOKUP or MATCH Jaladino	by David McRitchie	1	445
Learn formulas Kevin Henderson	by David McRitchie	1	495
how to set a 6-day work week ? RobertH	by Bob Phillips	1	871
sumproduct function Andreea Moyes via OfficeKB.com	by Aladin Akyurek	3	541
problem working with time data imported from text file afaqm	by Biff	1	907
How to have multiple columns in pivot table data area? mitch1962	by mitch1962	0	679
weight formula [email protected]	by Ragdyer	4	710
every nth cell by columns not rows.... Sampson	by Biff	1	588
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R.	by Mike R.	2	843
find data from other sheet Jaladino	by Biff	1	706
Is there a way to automatically add columns as the data updates? Eric D.	by Eric D.	1	622
Pesky VLookup !!! Lacklustre	by Curt	4	618
Vlook up or index match jerry	by Curt	1	524
Bringing additional information in with combo box selection JD	by Debra Dalgleish	1	464
How to have multiple columns in pivot table data area? mitch1962	by Debra Dalgleish	1	1,348
Formula doesnt work Kevin	by Kevin	2	591
Ref to Tab Name briank	by Harlan Grove	3	424
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,844
function needed David Harrison	by [email protected]	1	588
Can I increase row capacity beyond 65536 rows Trish	by Harlan Grove	2	842
Complex(?) Edit Kanga 85	by Kanga 85	3	346
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	709
How do i transfer certain lines from one list to another matt_hull1979	by Max	3	420
Need Formula to display pivot table source data Don S	by Debra Dalgleish	3	2,210
Convert 20050118 to a working date field Jessica	by Ken Wright	7	758
Counting... Patrick G	by Steve	3	662
Winnowing a list NL	by NL	6	355
Summing part of an Alpha Numeric String Arturo	by Arturo	2	686
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS FORMULA	by FORMULA	4	1,016
In Excel what can I use for the XINDEX function from Lotus 123? Val from ICB	by Ken Wright	2	837
I want to print out the sheet tabs (sheet names) Sundus	by Gord Dibben	3	1,124
conditional formatting-shading Shooter	by Jason Morin	2	507