Excel Worksheet Functions - Page 81

Thread / Thread Starter	Last Post	Replies	Views
weight formula [email protected]	by Ragdyer	4	715
How to have multiple columns in pivot table data area? mitch1962	by mitch1962	0	684
problem working with time data imported from text file afaqm	by Biff	1	909
sumproduct function Andreea Moyes via OfficeKB.com	by Aladin Akyurek	3	545
how to set a 6-day work week ? RobertH	by Bob Phillips	1	871
Learn formulas Kevin Henderson	by David McRitchie	1	500
VLOOKUP or MATCH Jaladino	by David McRitchie	1	447
Compare cell values Grant	by Grant	5	773
formula to extract specific data if match occurs jerry	by Aladin Akyurek	2	830
Want to return a value based on a whether a number is within a ra. laurieevan	by JulieD	3	678
find LAST match in column Pantryman	by Aladin Akyurek	7	4,300
Help with Pivot Chart SteveJ	by SteveJ	0	432
Multipart formula needed Barb	by ewan7279	2	554
Match or vlookup? Manos	by Jerry W. Lewis	1	389
Protect the formula but change result. ArchieBoy	by Bob Phillips	1	371
What's wrong with this vb? DaveMoore	by DaveMoore	2	576
Use address function or other Doug Laidlaw	by Jason Morin	1	406
Tje opposite appears to be happening Pat	by Bob Phillips	5	587
text splits down cells d-man	by Fred	1	447
Using INDEX & AND Joe Gieder	by Joe Gieder	0	400
converting to numbers smintey	by Peo Sjoblom	1	473
unwanted number to date conversion while pasting data from web Jacek	by Peo Sjoblom	1	1,459
how do i set up a formulas with an if date? Thunley	by Peo Sjoblom	3	649
What does a "plus" cursor mean (in lieu of the pointer?)? thanks S. Hegge	by Peo Sjoblom	4	710
Can I put Pop up menus on Excel Ricardo Munoz	by Bob Phillips	2	420
How can I write a formula or an argument to highlight a date when. saffield	by Jason Morin	1	445
Formula presumes cells have data Pat	by Peo Sjoblom	1	509
Worksheet Function - Find? DAA	by DAA	2	1,303
Excel should support DAYOFYEAR(year,month,day) returns julian dat. Neil	by Jason Morin	1	635
Check for errors Pat	by Peo Sjoblom	3	354
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly	by Peo Sjoblom	1	681
why do my spreadsheet gridlines only prints half way on the page?. gardnere	by BobT	2	1,615
"count if" function based on value of another cell Anauna	by Bernie Deitrick	3	4,437
How I show, automatically, the tab name on a cell, in Excel? CPortilloTroconis	by Sarah	4	748
is there a more efficient formula than... Wazooli	by Ken Wright	6	732
opening worksheet is "packing list" usrofc	by Gord Dibben	1	699
Concatenating Dates jadams-bellevue	by jadams-bellevue	2	496
Excel should allow a number formats of HEX, OCT and BIN. Neil	by Harlan Grove	3	483
SUM a column with errors Joe Gieder	by Joe Gieder	3	599
how do i open a 2003 file into an xp spreadsheet windylyndy	by Ken Wright	2	535
Excel shifts to wrong worksheet automatically Tom77	by dave	1	933
Can I use the contents of a cell to satisfy the result_vector arg. robh_2	by RagDyer	3	1,139
VLookup? Right function? Timmers	by Biff	1	424
Match function selecting first value it matches on exactly Paul K.	by Bernd Plumhoff	1	1,169
Incrementing formula by two rows Ben Hur	by Steve	1	521
Capturing query table errors T. Erkson	by T. Erkson	1	496
Sub-total feature is unavailable in Office 2003 Excel cawhitaker	by Peo Sjoblom	5	860
extract data from a range of cells in rows or columns when a date. Dartyon	by Dartyon	0	816
finding the largest number from the last row and look up its name. Jeff	by Max	5	629
convert a numerical currency into word format Rojo	by Fredrik Wahlgren	1	1,321
phantom headers dave	by Dave Peterson	1	394
Check Box gtcyberaz	by Dave Peterson	1	376
geting hiperlink wiyh vlookup Horacio	by Horacio	0	478
What does ={TABLE(,J213)} in the fx Box Mean? Rodby	by Rodby	7	1,397
How can I do a "best match" for text entries? NeedDataHelp	by Trevor Shuttleworth	1	635
Saving a file using a specific name in a cell SU	by Gord Dibben	4	694
How can I include the name of the tab in a header without typing . kasaz	by Gord Dibben	1	394
add list to newly created menu Anthony	by Gord Dibben	1	622
Change decimal format of cells depending on conditions? Cornelius	by Ron Rosenfeld	1	628
interior.colorindex used with conditional formatting Wazooli	by Gord Dibben	7	727
how do i calculate the order quantity? cfo guy	by Fred	1	719
excel pivot herbzee	by Gord Dibben	2	416
how do I reference a spreadsheet in a cell Lee_Wrede	by Lee Wrede	2	844
retain 'update remote reference' flag jacqui	by jacqui	0	528
Add a Message Box Anthony	by Michael	2	440
data validation [email protected]	by	2	419
Excel - Discount Factors and NOV mo	by Michael R Middleton	1	711
Formula - Excluding weekends & holidays Connie Martin	by Myrna Larson	9	1,900
For the Excel Query Gurus Andrew	by Arvi Laanemets	4	671
Howdo U copy a formula down a column, that uses data in another w. brantty	by brantty	0	1,050
Money for life mike	by mike	0	527
In Excel Auditing linking lines(blue colour) are not shown proper. Parvath	by Parvath	0	542
How do I clear cell content when excel document is closed? m3155	by Springbok	1	1,043
Excel gcdesign	by gcdesign	0	349
Help Required With IF AND Formula Ian	by Ian	3	487