Excel Worksheet Functions - Page 264

Thread / Thread Starter	Last Post	Replies	Views
Transpose with Match ? Steve D	by Steve D	4	3,601
Count multiple criteria KJ	by KJ	7	853
Referencing Icon Sets BLR	by BLR	3	793
VLOOKUP with a blank cell Iriemon	by Iriemon	5	663
Normal distribution Alexandra Lopes	by Alexandra Lopes	2	899
vlookup and lookup Ruth	by Ruth	12	1,059
Sum a NULL cell ArcticWolf	by Ashish Mathur[_2_]	6	628
Expand Selection in Auto filter NM	by Ashish Mathur[_2_]	7	6,476
Formula for empty cell collyer3	by Bernard Liengme	2	640
More Conditional Formatting Frecks1983	by Max	1	449
Conditional Formatting Frecks1983	by Max	3	419
HLOOKUP Help GRynners	by Pete_UK	1	430
vat formula John[_25_]	by ob-server	2	586
sumproduct and countif in one formula Aaron Hodson $Coversure$	by Aaron Hodson $Coversure$	2	647
counting colords cells with letters in them JJ	by Shane Devenshire[_2_]	6	475
Can you calculate the number of years between two dates in Excel 0 Christina	by Shane Devenshire[_2_]	4	882
Mac Auto-filter John	by Shane Devenshire[_2_]	1	828
What exactly {=TRANSPOSE()} means tuncau	by Shane Devenshire[_2_]	2	590
Can I pass network logon name to a cell in a spreadsheet? Quality Plan	by The Code Cage Team[_42_]	5	887
Data Validation Custom with V Lookup Scott R	by T. Valko	6	752
Sumproduct with autofilter John	by T. Valko	1	397
Help! Christina	by Pete_UK	6	476
Sum for two criteria Ernie Fenwick	by Max	3	489
change email Hyperlink from picture to text view? any ideas? Jeannie	by Jeannie	0	584
97 Pop-Up Calendar Tia	by Gord Dibben	1	617
Break Up Data Jennifer	by Spiky	1	406
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	473
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	785
Returning a value from the cell next to my match Ron	by Gord Dibben	2	507
Counting Numbers Buffalo	by Rick Rothstein	4	453
Hyperlinks stopped working tom	by Gord Dibben	4	590
rows to repeat at the top Meebers[_2_]	by Meebers[_2_]	4	396
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	944
VLOOKUP Issue Rocco2526	by Jessica	2	485
VLOOKUP - Referencing seperate workbook getting #N/A erros Reddo	by xlmate[_2_]	2	516
Pull Information from one sheet to another Christina	by Max	1	464
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	491
scroll function not working in excel 2007 scrool problem	by Spiky	1	803
trying to copy a worksheet containing named ranges to anotherworksheet cil9mxm	by Spiky	1	654
Selecting Pivot Table Raw Data Karen	by Karen	2	578
Change last number to 9 Laura Lee Day	by Mike H	3	419
EXCEL WILL CLOSE IF I CLICK PAGE Bamabo12	by Mike H	1	479
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,131
converting ssn's tisaman	by Rick Rothstein	12	1,028
cross referencing 2 workbooks at same time GezCam	by Shane Devenshire[_2_]	3	516
is this not working because i am using 03? out of my depth	by Bob Phillips[_3_]	1	436
Non working time [email protected]	by Bob Phillips[_3_]	4	433
Copying Formula dorinn	by David Biddulph[_2_]	8	543
Index Help iRon924	by iron924	2	373
worksheets Joanne	by Mohamed Attia	3	437
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	882
Excel 2003 bank ledger spreadsheet background fill shading Dan	by David Biddulph[_2_]	4	1,989
If formula result = 0, do not display-leave cell blank ASG	by Pete_UK	3	4,587
Extract specified fields with criteria from Excel.cvs workbook Ashish Mathur[_2_]	by Ashish Mathur[_2_]	0	616
NEW IPHONE VIDEO PROJECTOR PROTOTYPE NOW AVAILABLE LIMITED EDITION jurgita	by jurgita	0	642
Count if formula error Kate83	by Shane Devenshire[_2_]	5	595
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,184
IF function problems mmcap	by mmcap	9	545
Counting cells that are shaded in black? Denise	by T. Valko	5	832
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,344
SUM Formula Riley	by Ashish Mathur[_2_]	8	520
SUM DATA RANGE roy.okinawa	by T. Valko	4	435
Duplicate entries in spreadsheet Hunt	by Ashish Mathur[_2_]	2	449
FORMULA VS VALUE Kathy Niebur	by Ashish Mathur[_2_]	4	460
Hlookup, range_lookup parameter lmagnuss	by Pete_UK	1	999
INDEX & MATCH find first column value in an array? Ambie	by Ambie	3	1,275