Excel Worksheet Functions - Page 264

Thread / Thread Starter	Last Post	Replies	Views
Transpose with Match ? Steve D	by Steve D	4	3,567
Count multiple criteria KJ	by KJ	7	848
Referencing Icon Sets BLR	by BLR	3	774
VLOOKUP with a blank cell Iriemon	by Iriemon	5	654
Normal distribution Alexandra Lopes	by Alexandra Lopes	2	884
vlookup and lookup Ruth	by Ruth	12	1,050
Sum a NULL cell ArcticWolf	by Ashish Mathur[_2_]	6	611
Expand Selection in Auto filter NM	by Ashish Mathur[_2_]	7	6,427
Formula for empty cell collyer3	by Bernard Liengme	2	618
More Conditional Formatting Frecks1983	by Max	1	440
Conditional Formatting Frecks1983	by Max	3	411
HLOOKUP Help GRynners	by Pete_UK	1	420
vat formula John[_25_]	by ob-server	2	562
sumproduct and countif in one formula Aaron Hodson $Coversure$	by Aaron Hodson $Coversure$	2	644
counting colords cells with letters in them JJ	by Shane Devenshire[_2_]	6	471
Can you calculate the number of years between two dates in Excel 0 Christina	by Shane Devenshire[_2_]	4	863
Mac Auto-filter John	by Shane Devenshire[_2_]	1	822
What exactly {=TRANSPOSE()} means tuncau	by Shane Devenshire[_2_]	2	580
Can I pass network logon name to a cell in a spreadsheet? Quality Plan	by The Code Cage Team[_42_]	5	857
Data Validation Custom with V Lookup Scott R	by T. Valko	6	733
Sumproduct with autofilter John	by T. Valko	1	385
Help! Christina	by Pete_UK	6	472
Sum for two criteria Ernie Fenwick	by Max	3	485
change email Hyperlink from picture to text view? any ideas? Jeannie	by Jeannie	0	572
97 Pop-Up Calendar Tia	by Gord Dibben	1	611
Break Up Data Jennifer	by Spiky	1	401
Preventing row numbers from sorting Gary	by Gord Dibben	4	485
Once a column is marked as $, how do I change it back? wpbvin	by Gord Dibben	2	470
How to set worksheets to print in different order in the same file Tamall	by Gord Dibben	1	499
Multiple conditions Picman	by Picman	12	777
Returning a value from the cell next to my match Ron	by Gord Dibben	2	505
Counting Numbers Buffalo	by Rick Rothstein	4	427
Hyperlinks stopped working tom	by Gord Dibben	4	567
rows to repeat at the top Meebers[_2_]	by Meebers[_2_]	4	393
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	623
Array with Sum and multiply Eric	by Harlan Grove[_2_]	12	915
VLOOKUP Issue Rocco2526	by Jessica	2	465
VLOOKUP - Referencing seperate workbook getting #N/A erros Reddo	by xlmate[_2_]	2	494
Pull Information from one sheet to another Christina	by Max	1	455
Is there any way to auto-insert a row? Shawn	by xlmate[_2_]	4	669
Extract specified fields with criteria from Excel.cvs workbook Max	by Max	0	472
scroll function not working in excel 2007 scrool problem	by Spiky	1	793
trying to copy a worksheet containing named ranges to anotherworksheet cil9mxm	by Spiky	1	631
Selecting Pivot Table Raw Data Karen	by Karen	2	568
Change last number to 9 Laura Lee Day	by Mike H	3	401
EXCEL WILL CLOSE IF I CLICK PAGE Bamabo12	by Mike H	1	467
can I split a worksheet then have the 2 sections work independent Nik	by Sheeloo[_3_]	1	749
Hyperlinks to show on top left corner of screen Elisabeth	by Gary''s Student	4	1,105
converting ssn's tisaman	by Rick Rothstein	12	1,001
cross referencing 2 workbooks at same time GezCam	by Shane Devenshire[_2_]	3	490
is this not working because i am using 03? out of my depth	by Bob Phillips[_3_]	1	421
Non working time [email protected]	by Bob Phillips[_3_]	4	424
Copying Formula dorinn	by David Biddulph[_2_]	8	526
Index Help iRon924	by iron924	2	361
worksheets Joanne	by Mohamed Attia	3	429
Tracking Changes Rich Mogy	by Mohamed Attia	2	470
Mortgage with Quarterly Capitalisation & Monthly Payments Beth	by Junge[_2_]	8	2,025
creating checkboxes and radio buttons in excel Sandeep	by Joel	1	853
Excel 2003 bank ledger spreadsheet background fill shading Dan	by David Biddulph[_2_]	4	1,968
If formula result = 0, do not display-leave cell blank ASG	by Pete_UK	3	4,567
Extract specified fields with criteria from Excel.cvs workbook Ashish Mathur[_2_]	by Ashish Mathur[_2_]	0	608
NEW IPHONE VIDEO PROJECTOR PROTOTYPE NOW AVAILABLE LIMITED EDITION jurgita	by jurgita	0	603
Count if formula error Kate83	by Shane Devenshire[_2_]	5	576
Function to return a range of cells from a PivotTable ubundom	by Shane Devenshire[_2_]	2	628
[Statistical functions] Function to return result from Z table? plh	by plh	4	1,177
IF function problems mmcap	by mmcap	9	534
Counting cells that are shaded in black? Denise	by T. Valko	5	825
formula to add 6 months to a date entered on one worksheet, in ano Ron	by Rick Rothstein	2	1,282
drop down list dependant of previous selection The Fru Fru	by Shane Devenshire[_2_]	1	1,323
SUM Formula Riley	by Ashish Mathur[_2_]	8	500
SUM DATA RANGE roy.okinawa	by T. Valko	4	429
Duplicate entries in spreadsheet Hunt	by Ashish Mathur[_2_]	2	437
FORMULA VS VALUE Kathy Niebur	by Ashish Mathur[_2_]	4	454
Hlookup, range_lookup parameter lmagnuss	by Pete_UK	1	974
INDEX & MATCH find first column value in an array? Ambie	by Ambie	3	1,264