Excel Worksheet Functions - Page 264

Thread / Thread Starter	Last Post	Replies	Views
Transpose with Match ? Steve D	by Steve D	4	3,608
Count multiple criteria KJ	by KJ	7	861
Referencing Icon Sets BLR	by BLR	3	798
VLOOKUP with a blank cell Iriemon	by Iriemon	5	666
Normal distribution Alexandra Lopes	by Alexandra Lopes	2	902
vlookup and lookup Ruth	by Ruth	12	1,064
Sum a NULL cell ArcticWolf	by Ashish Mathur[_2_]	6	638
Expand Selection in Auto filter NM	by Ashish Mathur[_2_]	7	6,482
Formula for empty cell collyer3	by Bernard Liengme	2	648
More Conditional Formatting Frecks1983	by Max	1	460
Conditional Formatting Frecks1983	by Max	3	429
HLOOKUP Help GRynners	by Pete_UK	1	430
vat formula John[_25_]	by ob-server	2	589
sumproduct and countif in one formula Aaron Hodson $Coversure$	by Aaron Hodson $Coversure$	2	652
counting colords cells with letters in them JJ	by Shane Devenshire[_2_]	6	485
Can you calculate the number of years between two dates in Excel 0 Christina	by Shane Devenshire[_2_]	4	885
Mac Auto-filter John	by Shane Devenshire[_2_]	1	828
What exactly {=TRANSPOSE()} means tuncau	by Shane Devenshire[_2_]	2	593
Can I pass network logon name to a cell in a spreadsheet? Quality Plan	by The Code Cage Team[_42_]	5	892
Data Validation Custom with V Lookup Scott R	by T. Valko	6	752
Sumproduct with autofilter John	by T. Valko	1	400
Help! Christina	by Pete_UK	6	479
Sum for two criteria Ernie Fenwick	by Max	3	489
change email Hyperlink from picture to text view? any ideas? Jeannie	by Jeannie	0	589
97 Pop-Up Calendar Tia	by Gord Dibben	1	618
Break Up Data Jennifer	by Spiky	1	411
Preventing row numbers from sorting Gary	by Gord Dibben	4	507
Once a column is marked as $, how do I change it back? wpbvin	by Gord Dibben	2	486
How to set worksheets to print in different order in the same file Tamall	by Gord Dibben	1	510
Multiple conditions Picman	by Picman	12	795
Returning a value from the cell next to my match Ron	by Gord Dibben	2	516
Counting Numbers Buffalo	by Rick Rothstein	4	453
Hyperlinks stopped working tom	by Gord Dibben	4	591
rows to repeat at the top Meebers[_2_]	by Meebers[_2_]	4	406
Is there a way to find the max in a set of data that meet a certaincriteria w/o using an array formula? SK08	by Harlan Grove[_2_]	7	637
Array with Sum and multiply Eric	by Harlan Grove[_2_]	12	951
VLOOKUP Issue Rocco2526	by Jessica	2	490
VLOOKUP - Referencing seperate workbook getting #N/A erros Reddo	by xlmate[_2_]	2	517
Pull Information from one sheet to another Christina	by Max	1	465
Is there any way to auto-insert a row? Shawn	by xlmate[_2_]	4	692
Extract specified fields with criteria from Excel.cvs workbook Max	by Max	0	502
scroll function not working in excel 2007 scrool problem	by Spiky	1	812
trying to copy a worksheet containing named ranges to anotherworksheet cil9mxm	by Spiky	1	660
Selecting Pivot Table Raw Data Karen	by Karen	2	578
Change last number to 9 Laura Lee Day	by Mike H	3	424
EXCEL WILL CLOSE IF I CLICK PAGE Bamabo12	by Mike H	1	490
can I split a worksheet then have the 2 sections work independent Nik	by Sheeloo[_3_]	1	761
Hyperlinks to show on top left corner of screen Elisabeth	by Gary''s Student	4	1,132
converting ssn's tisaman	by Rick Rothstein	12	1,039
cross referencing 2 workbooks at same time GezCam	by Shane Devenshire[_2_]	3	524
is this not working because i am using 03? out of my depth	by Bob Phillips[_3_]	1	446
Non working time [email protected]	by Bob Phillips[_3_]	4	441
Copying Formula dorinn	by David Biddulph[_2_]	8	549
Index Help iRon924	by iron924	2	381
worksheets Joanne	by Mohamed Attia	3	438
Tracking Changes Rich Mogy	by Mohamed Attia	2	487
Mortgage with Quarterly Capitalisation & Monthly Payments Beth	by Junge[_2_]	8	2,066
creating checkboxes and radio buttons in excel Sandeep	by Joel	1	883
Excel 2003 bank ledger spreadsheet background fill shading Dan	by David Biddulph[_2_]	4	1,992
If formula result = 0, do not display-leave cell blank ASG	by Pete_UK	3	4,590
Extract specified fields with criteria from Excel.cvs workbook Ashish Mathur[_2_]	by Ashish Mathur[_2_]	0	626
NEW IPHONE VIDEO PROJECTOR PROTOTYPE NOW AVAILABLE LIMITED EDITION jurgita	by jurgita	0	642
Count if formula error Kate83	by Shane Devenshire[_2_]	5	601
Function to return a range of cells from a PivotTable ubundom	by Shane Devenshire[_2_]	2	668
[Statistical functions] Function to return result from Z table? plh	by plh	4	1,193
IF function problems mmcap	by mmcap	9	545
Counting cells that are shaded in black? Denise	by T. Valko	5	837
formula to add 6 months to a date entered on one worksheet, in ano Ron	by Rick Rothstein	2	1,295
drop down list dependant of previous selection The Fru Fru	by Shane Devenshire[_2_]	1	1,349
SUM Formula Riley	by Ashish Mathur[_2_]	8	526
SUM DATA RANGE roy.okinawa	by T. Valko	4	445
Duplicate entries in spreadsheet Hunt	by Ashish Mathur[_2_]	2	457
FORMULA VS VALUE Kathy Niebur	by Ashish Mathur[_2_]	4	465
Hlookup, range_lookup parameter lmagnuss	by Pete_UK	1	999
INDEX & MATCH find first column value in an array? Ambie	by Ambie	3	1,285