Excel Worksheet Functions - Page 2

Thread / Thread Starter	Last Post	Replies	Views
TAN different to a calculator? Please help would be appreciated lo !!HELP!!	by MrShorty	5	988
How do I show the low-price supplier from seven different quotes? !Maniac McGhee!	by JE McGimpsey	1	729
Cell converts a date entry to "=" and displays "01/00/00 ##	by bj	1	1,031
table of value ranges $cruncher	by T. Valko	2	455
Counting results from a lookup &e7	by &e7	1	581
How can I get the Analysis Toolpak 'cole	by Myrna Larson	1	565
Nested subtotals in incorrect order on large worksheets 'Wyn	by Robert Lyons	2	1,139
Cannot format data after using mid() function ()	by Duke Carey	3	524
Using lookup functions with conditions and constantly changing dat (-) Ions	by Max	11	971
A change in date will reschedule all other dates * In need of your expertise***	by Jacob Skaria	1	488
Excell convert formula row to formula column Danny	by Chip Pearson	1	783
Auto size a pivot table to a page size .	by steven1001	1	1,558
Grabbing data from a specific cell Kenneth	by Kenneth	2	743
$ for VLOOKUP functions Suzannah	by ExcelBanter AI	4	11,943
Vlookup question zot	by T. Valko	2	690
Poor humaneyes «Ë²´	by «Ë²´	0	400
Poor humaneyes «Ë²´	by «Ë²´	0	460
Poor humaneyes «Ë²´	by «Ë²´	0	483
Choose date from drop-down calendar +alcheme	by Duke Carey	1	730
HOW MANY "/" IN THIS CELL A1 = "RG/351/87/11/3" - - - - -	by Mike	4	434
Auto update information in footer - pat	by - pat	0	566
Drop down box issue - pat	by Ashish Mathur[_2_]	2	568
convert second to date and time --== Alain ==--	by Bob Phillips	4	729
Link cells with text not numbers --Viewpoint	by --Viewpoint	4	778
Time Calculation and formulas needed (2 questions) --Viewpoint	by Teethless mama	1	565
How to retain part of formula's criteria as static --Viewpoint	by --Viewpoint	7	1,146
OT I would want protect my sheets of excel from a "password recovery" software... How? -= Luca =-	by macropod	3	758
The same IF (SE) formula give me two different number: why??? -= Luca =-	by Dave Peterson	5	918
Fungerande schema Excel -> Outlook? -=Patrik=-	by -=Patrik=-	0	1,036
How do I check for duplications in a range of data (excel)? -Adrianna_	by Alan	2	963
diverting output -az	by Dave Peterson	1	633
Need to find the right-most cell value in a string of cells -dc-	by Domenic	2	2,431
COMBO BOX FOCUS -debi-	by -debi-	0	617
using vlookup help -keevill-	by Bob Phillips	1	477
Weighted ranking of a series -Macca-	by -Macca-	4	1,149
MONTHNAME when getting external data from Access -PJ	by FxM	2	882
How do I reference a cell as PART of a vlookup "Table_Array" locat -Rocket	by -Rocket	2	803
calculated celles according to more then 1 condition -yuval[_2_]	by xlmate	5	470
Global Warming and what you can do to against it ..	by ..	0	662
Solar cells for less than 1 USD per Watt ..	by ..	0	547
link text cells on different sheets ...jay...	by Peo Sjoblom[_2_]	3	1,953
possible to have =now() at data entry and not update after that? .:mmac:.	by Peo Sjoblom	5	666
No showing of cellnumbers used in formular with colour /Maria	by Hopest	5	481
Invalid Formula with the use of Indirect 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	5	490
Extract each item in the list 0-0 Wai Wai ^-^	by Stefi	2	482
Start & End of the data series 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	0	554
If the cell contains..., do something 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	5	1,119
Dynamically-linked formula, cell reference in the string 0-0 Wai Wai ^-^	by Teerings3	4	1,457
Extract each item in the list 0-0 Wai Wai ^-^	by Arvi Laanemets	1	665
Insert manual line break in formula 0-0 Wai Wai ^-^	by Ron Coderre	3	1,161
How to set condition: A1=A2=A3= ... =A10 0-0 Wai Wai ^-^	by Aladin Akyurek	9	671
Weighed Average 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	3	445
average if, multiple if, divide if 0-0 Wai Wai ^-^	by Jerry W. Lewis	6	882
A difficult conditonal calculation 0-0 Wai Wai ^-^	by Ron Rosenfeld	1	501
countif - Criterion1 OR [Criterion2 AND Criterion3] 0-0 Wai Wai ^-^	by Harlan Grove	3	508
Insert manual line break in formula 0-0 Wai Wai ^-^	by Roger Govier	1	745
Any function for Crop/Cut Text 0-0 Wai Wai ^-^	by Bernie Deitrick	1	1,721
Advanced Lookup (lookup for 2 values) 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	2	847
If the cell contains..., do something (2) 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	6	492
Chop off parts of the statement 0-0 Wai Wai ^-^	by Niek Otten	1	436
Conditional Formula - calculate only if net unit is zero 0-0 Wai Wai ^-^	by Bob Phillips	8	609
Variable Cell Reference 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	2	569
Variable Cell Referencing 0-0 Wai Wai ^-^	by [email protected]	3	582
vlookup with variable col_index_num 0-0 Wai Wai ^-^	by Bob Phillips	2	1,584
"000" + number + "." 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	4	425
If's conditions about matching 0-0 Wai Wai ^-^	by Biff	8	514
Take fraction out of the figure 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	3	459
Extract information from the list 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	3	527
0.5883698 Does This Look Good? ... 0.7272271 [email protected]	by [email protected]	0	407
formula question... 000ani	by Joe User[_2_]	2	528
Obi Wan Kenobi: You're My Only...HELP!!!!!! [email protected]	by JonOfAllTrades	5	665
Help with formula 007juk	by Dave Peterson	3	392
Question re Vlookup function within Excel. 007juk	by Niek Otten	7	596
Constant growth 050529	by PC	5	528
Printing formulas in worksheet 05_CHASBRO	by Gord Dibben	3	552