Excel Worksheet Functions - Page 167

Thread / Thread Starter	Last Post	Replies	Views
VLookup formula question Tim at alliant	by Tim at alliant	2	411
CONDITIONAL FORMATING FORMULA Kanmi	by Kanmi	6	422
VLOOKUP Kanmi	by Max	3	406
Pivot Table Percent Question mark	by mark	4	917
ACCRUED INTEREST (ACCRINT) Bug Keith	by Keith	2	1,120
Iserror for an array diepvic	by diepvic	8	3,203
need complex if formula (I think) b4nature	by Bernd P	3	554
Keeping the selected font when creating charts in Excel 2007 Lars	by Bernard Liengme[_3_]	1	514
How do I get a new calculated date from different date ranges? Ann LeBlanc	by Mike H	3	699
excel - outlines meghnal	by meghnal	4	632
Worksheet protection ssdsibes	by FatBytestard	1	416
Isolate UNIQUE combination of Z cells from a range N that adds up alex	by Sam Wilson	3	544
Doing multiple borders Herb[_2_]	by Shane Devenshire[_2_]	1	511
Relative Worksheet references mjb1	by mjb1	4	665
Want to split 922 037 022 into 3cols and recombine without spaces Confused	by Jacob Skaria	4	563
If blank cell, copy information from cell above Oceangate	by Ashish Mathur[_2_]	5	3,319
VB CODE Kanmi	by Jacob Skaria	7	492
FAQ : Answers to show in another cell gwtechie72	by FatBytestard	4	448
adding text to the end of a formula Lodge	by Jim Cone[_2_]	1	579
Comparing two ranges and get true or false in one cell depending onresult Leon[_2_]	by Leon[_2_]	3	800
How do I subtotal specific / random rows from a spreadsheet? Duke Bond	by Tom Hutchins	1	1,095
Replace hard return with a delimiter? Erin.	by Ethan Strauss	3	1,663
SUMPRODUCT not working. Gaurav[_4_]	by Gord Dibben	2	549
Cycle Times PAL	by PAL	4	494
Automatic Cell Copy to other worksheets sharice.g	by Ron de Bruin	1	433
Excel Comments lisa	by lisa	5	804
forgoten password Leon	by Hans Terkelsen	4	422
lookup issue.... John	by Gord Dibben	2	437
Using tab key in protected worksheet bev	by bev	4	1,441
Conditional Count Formula Mully	by T. Valko	3	643
how to use vlookup for more than 1line LHM	by LHM	3	602
how to make a preforated page-break insert KoldKream	by Gord Dibben	2	444
Sorting Coloumns that are Formula's heritage1450	by Eduardo	1	422
Woman age 40 Tony_student	by JLatham	9	578
Extracting email address from various data Wade	by Jacob Skaria	2	470
Copying Worksheets which contain Named Ranges Terry Bennett	by Terry Bennett	0	640
i need some help in a type Vatos	by Shane Devenshire[_2_]	2	417
Merge two columns of data with a condition Richard	by Sam Wilson	1	1,113
count value dependent on unique or repeated values in another colu singing_inmysleep	by RagDyeR	2	837
Check for CAPS Heidi	by Heidi	3	588
Turn of 'Read Only' Barb	by Barb	2	689
How do I freeze individual cells with formulas in them Robernaut	by Eduardo	2	3,782
Track Changes Kanmi	by Kanmi	0	433
How do I get Excel to display a table on a different worksheet? John	by Stefi	6	1,178
Array formulas Lynda	by Shane Devenshire[_2_]	3	796
Merge 2 datasheets into single Pivot Table. free_ur_mind	by Eduardo	2	2,555
Woman age 40 Tony_student	by Tony_student[_2_]	6	564
IF formula & formatting rh33a	by Fred Smith[_4_]	3	519
DSUM using alpha numeric codes brian	by brian	1	720
What If Scenario and/or Pivot Table eightandup	by eightandup	0	617
Protected worksheet/tab key bev	by bev	2	557
How to average the last 10 numbers in a row? John P[_2_]	by John P[_2_]	7	1,105
Limit data entry in range of cells JStiehl	by JStiehl	2	652
Sports Tipping Formula! Mully	by Mully	1	493
Search backmara	by Joel	1	416
adding a zero in front of a colon 303mike	by Per Jessen	5	1,129
Auto-adding text when a certain number is input Lauren	by Jacob Skaria	1	520
If Statements??/Conditional formatting from drop-down multiple she sarah	by Sheeloo	1	796
Change Chart Data KIOhio	by KIOhio	0	530
Countif Criteria Reference Cell StephonM	by T. Valko	3	832
Finding the first value that is less than zero russhess8	by T. Valko	4	5,718
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! forevertrying	by Scarlett	18	1,852
Reconize the first digit only Steved	by Jacob Skaria	2	482
Printing spreadsheet print area to 1 page fails to shrink image en zipidy	by zipidy	0	838
Comparing dates from VLOOKUP functions not working right Sambonator	by Max	2	3,106
i need to figure 55% for a range from 300 to 499 sbechtel59	by Fred Smith[_4_]	1	381
Hide row based on cell value Munchkin	by Jacob Skaria	2	1,394
How can I create a simple form where users can tab between fields DMAC	by Gord Dibben	1	575
Row Height-expand if text wraps in a cell Penny Miller	by Gord Dibben	3	920
Pulling data from Sheets in A workbook MRSVATEK	by Gord Dibben	2	534
Auto enter current date in cell when another changed Andy Smith[_3_]	by Gord Dibben	7	1,765
Sum function dannyboy8	by Gord Dibben	3	456
sum/autosum not calculating correctly websterk12	by Gord Dibben	6	1,636
Formula for 0 Fareez	by Gord Dibben	4	517
Vlookup function wont work for copied data Scarlett	by Gord Dibben	2	683