Excel Worksheet Functions - Page 167

Thread / Thread Starter	Last Post	Replies	Views
VLookup formula question Tim at alliant	by Tim at alliant	2	384
CONDITIONAL FORMATING FORMULA Kanmi	by Kanmi	6	397
VLOOKUP Kanmi	by Max	3	388
Pivot Table Percent Question mark	by mark	4	906
ACCRUED INTEREST (ACCRINT) Bug Keith	by Keith	2	1,112
Iserror for an array diepvic	by diepvic	8	3,088
need complex if formula (I think) b4nature	by Bernd P	3	526
Keeping the selected font when creating charts in Excel 2007 Lars	by Bernard Liengme[_3_]	1	487
How do I get a new calculated date from different date ranges? Ann LeBlanc	by Mike H	3	677
excel - outlines meghnal	by meghnal	4	584
Worksheet protection ssdsibes	by FatBytestard	1	403
Isolate UNIQUE combination of Z cells from a range N that adds up alex	by Sam Wilson	3	515
Doing multiple borders Herb[_2_]	by Shane Devenshire[_2_]	1	485
Relative Worksheet references mjb1	by mjb1	4	650
Want to split 922 037 022 into 3cols and recombine without spaces Confused	by Jacob Skaria	4	544
If blank cell, copy information from cell above Oceangate	by Ashish Mathur[_2_]	5	3,274
VB CODE Kanmi	by Jacob Skaria	7	477
FAQ : Answers to show in another cell gwtechie72	by FatBytestard	4	414
adding text to the end of a formula Lodge	by Jim Cone[_2_]	1	564
Comparing two ranges and get true or false in one cell depending onresult Leon[_2_]	by Leon[_2_]	3	772
How do I subtotal specific / random rows from a spreadsheet? Duke Bond	by Tom Hutchins	1	1,067
Replace hard return with a delimiter? Erin.	by Ethan Strauss	3	1,640
SUMPRODUCT not working. Gaurav[_4_]	by Gord Dibben	2	521
Cycle Times PAL	by PAL	4	481
Automatic Cell Copy to other worksheets sharice.g	by Ron de Bruin	1	427
Excel Comments lisa	by lisa	5	766
forgoten password Leon	by Hans Terkelsen	4	412
lookup issue.... John	by Gord Dibben	2	428
Using tab key in protected worksheet bev	by bev	4	1,420
Conditional Count Formula Mully	by T. Valko	3	620
how to use vlookup for more than 1line LHM	by LHM	3	584
how to make a preforated page-break insert KoldKream	by Gord Dibben	2	419
Sorting Coloumns that are Formula's heritage1450	by Eduardo	1	402
Woman age 40 Tony_student	by JLatham	9	528
Extracting email address from various data Wade	by Jacob Skaria	2	438
Copying Worksheets which contain Named Ranges Terry Bennett	by Terry Bennett	0	625
i need some help in a type Vatos	by Shane Devenshire[_2_]	2	398
Merge two columns of data with a condition Richard	by Sam Wilson	1	1,090
count value dependent on unique or repeated values in another colu singing_inmysleep	by RagDyeR	2	813
Check for CAPS Heidi	by Heidi	3	572
Turn of 'Read Only' Barb	by Barb	2	646
How do I freeze individual cells with formulas in them Robernaut	by Eduardo	2	3,756
Track Changes Kanmi	by Kanmi	0	421
How do I get Excel to display a table on a different worksheet? John	by Stefi	6	1,114
Array formulas Lynda	by Shane Devenshire[_2_]	3	780
Merge 2 datasheets into single Pivot Table. free_ur_mind	by Eduardo	2	2,508
Woman age 40 Tony_student	by Tony_student[_2_]	6	544
IF formula & formatting rh33a	by Fred Smith[_4_]	3	486
DSUM using alpha numeric codes brian	by brian	1	702
What If Scenario and/or Pivot Table eightandup	by eightandup	0	594
Protected worksheet/tab key bev	by bev	2	547
How to average the last 10 numbers in a row? John P[_2_]	by John P[_2_]	7	1,074
Limit data entry in range of cells JStiehl	by JStiehl	2	618
Sports Tipping Formula! Mully	by Mully	1	483
Search backmara	by Joel	1	406
adding a zero in front of a colon 303mike	by Per Jessen	5	1,095
Auto-adding text when a certain number is input Lauren	by Jacob Skaria	1	490
If Statements??/Conditional formatting from drop-down multiple she sarah	by Sheeloo	1	765
Change Chart Data KIOhio	by KIOhio	0	513
Countif Criteria Reference Cell StephonM	by T. Valko	3	804
Finding the first value that is less than zero russhess8	by T. Valko	4	5,672
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! forevertrying	by Scarlett	18	1,818
Reconize the first digit only Steved	by Jacob Skaria	2	465
Printing spreadsheet print area to 1 page fails to shrink image en zipidy	by zipidy	0	816
Comparing dates from VLOOKUP functions not working right Sambonator	by Max	2	3,080
i need to figure 55% for a range from 300 to 499 sbechtel59	by Fred Smith[_4_]	1	374
Hide row based on cell value Munchkin	by Jacob Skaria	2	1,364
How can I create a simple form where users can tab between fields DMAC	by Gord Dibben	1	541
Row Height-expand if text wraps in a cell Penny Miller	by Gord Dibben	3	890
Pulling data from Sheets in A workbook MRSVATEK	by Gord Dibben	2	511
Auto enter current date in cell when another changed Andy Smith[_3_]	by Gord Dibben	7	1,725
Sum function dannyboy8	by Gord Dibben	3	434
sum/autosum not calculating correctly websterk12	by Gord Dibben	6	1,574
Formula for 0 Fareez	by Gord Dibben	4	507
Vlookup function wont work for copied data Scarlett	by Gord Dibben	2	654