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	657
extract data from a range of cells in rows or columns when a date. Dartyon	by Dartyon	0	846
Sub-total feature is unavailable in Office 2003 Excel cawhitaker	by Peo Sjoblom	5	926
Capturing query table errors T. Erkson	by T. Erkson	1	521
Incrementing formula by two rows Ben Hur	by Steve	1	554
Match function selecting first value it matches on exactly Paul K.	by Bernd Plumhoff	1	1,233
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,211
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	567
SUM a column with errors Joe Gieder	by Joe Gieder	3	625
Excel should allow a number formats of HEX, OCT and BIN. Neil	by Harlan Grove	3	522
Concatenating Dates jadams-bellevue	by jadams-bellevue	2	525
opening worksheet is "packing list" usrofc	by Gord Dibben	1	725
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,515
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	700
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,331
Formula presumes cells have data Pat	by Peo Sjoblom	1	537
How can I write a formula or an argument to highlight a date when. saffield	by Jason Morin	1	458
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	736
how do i set up a formulas with an if date? Thunley	by Peo Sjoblom	3	673
unwanted number to date conversion while pasting data from web Jacek	by Peo Sjoblom	1	1,502
converting to numbers smintey	by Peo Sjoblom	1	496
Using INDEX & AND Joe Gieder	by Joe Gieder	0	416
text splits down cells d-man	by Fred	1	458
Tje opposite appears to be happening Pat	by Bob Phillips	5	607
Use address function or other Doug Laidlaw	by Jason Morin	1	417
What's wrong with this vb? DaveMoore	by DaveMoore	2	604
Protect the formula but change result. ArchieBoy	by Bob Phillips	1	386
Match or vlookup? Manos	by Jerry W. Lewis	1	414
Multipart formula needed Barb	by ewan7279	2	584
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	697
formula to extract specific data if match occurs jerry	by Aladin Akyurek	2	856
Compare cell values Grant	by Grant	5	799
VLOOKUP or MATCH Jaladino	by David McRitchie	1	481
Learn formulas Kevin Henderson	by David McRitchie	1	523
how to set a 6-day work week ? RobertH	by Bob Phillips	1	890
sumproduct function Andreea Moyes via OfficeKB.com	by Aladin Akyurek	3	570
problem working with time data imported from text file afaqm	by Biff	1	940
How to have multiple columns in pivot table data area? mitch1962	by mitch1962	0	704
weight formula [email protected]	by Ragdyer	4	737
every nth cell by columns not rows.... Sampson	by Biff	1	621
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R.	by Mike R.	2	877
find data from other sheet Jaladino	by Biff	1	743
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	629
Vlook up or index match jerry	by Curt	1	555
Bringing additional information in with combo box selection JD	by Debra Dalgleish	1	488
How to have multiple columns in pivot table data area? mitch1962	by Debra Dalgleish	1	1,391
Formula doesnt work Kevin	by Kevin	2	637
Ref to Tab Name briank	by Harlan Grove	3	429
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,883
function needed David Harrison	by [email protected]	1	617
Can I increase row capacity beyond 65536 rows Trish	by Harlan Grove	2	870
Complex(?) Edit Kanga 85	by Kanga 85	3	359
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	737
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,250
Convert 20050118 to a working date field Jessica	by Ken Wright	7	796
Counting... Patrick G	by Steve	3	729
Winnowing a list NL	by NL	6	361
Summing part of an Alpha Numeric String Arturo	by Arturo	2	719
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	875
I want to print out the sheet tabs (sheet names) Sundus	by Gord Dibben	3	1,156
conditional formatting-shading Shooter	by Jason Morin	2	531