Excel Worksheet Functions - Page 51

Thread / Thread Starter	Last Post	Replies	Views
hr worksheet counting days missed Tina	by trip_to_tokyo[_3_]	2	1,136
Excel 2007 Pivot Tables compatible with 2003 Jimmy G	by bala_vb	3	2,327
Using wildcard characters in find & replace Tola	by bala_vb	4	3,856
Graph Paper Rainchild	by Billns	2	709
Top 10 in pivot - show rest as other or similar Kenneth Andersen	by Herbert Seidenberg	3	3,365
vlook on different tabs based on value jatman	by Luke M[_4_]	1	603
Lookup / Summary Table Joe	by Steve Dunn	8	701
insert blank row and formulas scottmcm	by Luke M[_4_]	1	1,008
sum 2 values in diffnt cells with dup values, and sum if not dup Nina	by Bernard Liengme[_2_]	2	495
VLOOKUP PAL	by Tom Hutchins	2	402
Combining cells with text Nadine	by Nadine	2	541
Duplication Lorenza@hsccs	by Dave Peterson	1	494
WEEKNUM function not working Cam	by Dave Peterson	4	1,525
How do I write a formula in excel where 1 = .05 and 2 = .75 etc. CarolB	by Mike H	2	637
conditional formatting Russell	by Russell	3	494
Counting for frequency Roxana	by Joe User[_2_]	2	666
Password protect cells Christobo	by Dave Peterson	9	820
SumIf AND NoodNutt	by Fred Smith[_4_]	6	750
count similar text with using filters mj	by Eduardo	2	892
Match - not sure how to use this function Luvable Lady	by Bob Phillips[_4_]	3	667
Help with SUMPRODUCT & converting date to value jrproudfoot	by Bob Phillips[_4_]	1	570
activate formula when adjacent cell populated Simon	by Arvi Laanemets	4	810
formula to copy from a cell Legolas	by bala_vb	3	696
About Data Validation moonhkt	by Roger Govier[_8_]	2	773
Counting results of a formula Nadine	by bala_vb	10	3,133
formula for month that is prior to actual GoBonnieGo	by [email protected]	6	749
inventory Gary	by ozgrid.com	2	726
Regression Formula Abby	by Mike Middleton[_2_]	2	1,348
make a check form, and then have info go to a check register richie g	by richie g	0	694
Count blanks by date Molasses26	by Max	2	568
In Excel need to have a sub worksheet inserted into each row RT	by Dave Peterson	2	2,383
lookup? Mezani	by Bob Phillips[_4_]	1	648
set flashing alarm by a date for a text box In a quandary always	by Tom Hutchins	1	1,296
LOOKUP formula when term may not be present MichaelRobert	by Niek Otten	1	680
Trending Function? Kevin	by Jim Thomlinson	3	991
Count, Sum, Index,Match or other formula needed Nadine	by Tom Hutchins	1	1,451
Identifying a label. Nicole[_3_]	by Gord Dibben	1	696
formatting a spreadsheet help hj	by Billns	4	984
copied from web page to excel sheet and cant remove from sheet mitch	by Billns	2	869
copied from web page to excel sheet and cant remove from sheet mitch	by mitch	0	756
Excel Security Patp	by Gord Dibben	2	446
Formula to calculate Latest Cost (inventory valuation) Curtis[_2_]	by Curtis[_2_]	6	2,378
keep formula delete contents carspjcars	by Gord Dibben	4	2,762
Vlookup? Doug	by Niek Otten	2	515
Macro Help karim	by Luke M[_4_]	1	559
counting occurences specific month appears MM	by MM	4	946
IF Function Help Dewayne	by Steve Dunn	3	582
Aggregating data among multiple workbooks Kadco	by Otto Moehrbach[_2_]	1	872
Formula to sum based on a change in another column J Harris	by bala_vb	3	1,254
Formula for competition pairing Colin[_4_]	by Pete_UK	1	785
change text color when the value become lower than a certain value change text color automatically	by Jacob Skaria	1	1,519
Vlookup and match part of text in a cell Joe Phan	by T. Valko	3	2,516
Help with Conditional Format Formula David K.	by T. Valko	6	686
filtering subtotals and if functions fam	by Domenic	2	477
how do I achieve my xl spread sheet in Alphabetical order Generous	by JLatham	1	591
conditional format help hj	by JLatham	3	582
Conditional Formatting - stuck on formula Awrex	by Fred Smith[_4_]	3	613
Simple calculation where values change to letters? Zuo	by Zuo	3	653
Find latest date from list and corresponding info MCRH	by Teethless mama	2	1,313
How can I reference a worksheet in a formula based on a cell value JZinGA	by David K.	1	807
Excel and consecutive number Shadowkiller361	by Shadowkiller361	2	1,531
IF function winnie123	by winnie123	4	555
countif/sumproduct + month MM	by Teethless mama	1	700
counting occurences of month on a specific worksheet MM	by Fred Smith[_4_]	1	629
Lookup / Summary Table Joe	by Joe	0	561
how to change the pivot chart automaticaly as values in the worksheet change Vinay Vasu	by Vinay Vasu	0	679
complex lookup Doug	by Bernd P	8	1,206
finding 10 smallest numbers from last 20 input handicapper	by Bernd P	8	1,851
code to copy range smith82	by Don Guillett[_2_]	1	625
Using Fill command in Editing Group Caz	by Gord Dibben	2	1,409
Macro for Time Recording karim	by Gord Dibben	2	1,438
Format Ratio Q Seanie	by Dana DeLouis[_3_]	2	657
question related to merging multiple statements Dharmesh[_2_]	by Rick Rothstein	5	621
IRR showed #NUM! bakbuk	by Dana DeLouis[_4_]	16	2,874
sort 2 column in the same time "" as dictionary "" Mahmoud Mustafa	by Mahmoud Mustafa	0	631