Excel Worksheet Functions - Page 51

Thread / Thread Starter	Last Post	Replies	Views
Formula to calculate Latest Cost (inventory valuation) Curtis[_2_]	by Curtis[_2_]	6	2,492
keep formula delete contents carspjcars	by Gord Dibben	4	2,899
Vlookup? Doug	by Niek Otten	2	717
Macro Help karim	by Luke M[_4_]	1	720
counting occurences specific month appears MM	by MM	4	1,082
IF Function Help Dewayne	by Steve Dunn	3	687
Aggregating data among multiple workbooks Kadco	by Otto Moehrbach[_2_]	1	975
Formula to sum based on a change in another column J Harris	by bala_vb	3	1,370
Formula for competition pairing Colin[_4_]	by Pete_UK	1	911
change text color when the value become lower than a certain value change text color automatically	by Jacob Skaria	1	1,644
Vlookup and match part of text in a cell Joe Phan	by T. Valko	3	2,685
Help with Conditional Format Formula David K.	by T. Valko	6	842
filtering subtotals and if functions fam	by Domenic	2	619
how do I achieve my xl spread sheet in Alphabetical order Generous	by JLatham	1	723
conditional format help hj	by JLatham	3	742
Conditional Formatting - stuck on formula Awrex	by Fred Smith[_4_]	3	726
Simple calculation where values change to letters? Zuo	by Zuo	3	755
Find latest date from list and corresponding info MCRH	by Teethless mama	2	1,420
How can I reference a worksheet in a formula based on a cell value JZinGA	by David K.	1	974
Excel and consecutive number Shadowkiller361	by Shadowkiller361	2	1,642
IF function winnie123	by winnie123	4	671
countif/sumproduct + month MM	by Teethless mama	1	852
counting occurences of month on a specific worksheet MM	by Fred Smith[_4_]	1	738
Lookup / Summary Table Joe	by Joe	0	672
how to change the pivot chart automaticaly as values in the worksheet change Vinay Vasu	by Vinay Vasu	0	819
complex lookup Doug	by Bernd P	8	1,329
finding 10 smallest numbers from last 20 input handicapper	by Bernd P	8	1,983
code to copy range smith82	by Don Guillett[_2_]	1	729
Using Fill command in Editing Group Caz	by Gord Dibben	2	1,525
Macro for Time Recording karim	by Gord Dibben	2	1,552
Format Ratio Q Seanie	by Dana DeLouis[_3_]	2	803
question related to merging multiple statements Dharmesh[_2_]	by Rick Rothstein	5	740
IRR showed #NUM! bakbuk	by Dana DeLouis[_4_]	16	2,990
sort 2 column in the same time "" as dictionary "" Mahmoud Mustafa	by Mahmoud Mustafa	0	753
Nested formular to give a word answer based on 2 cells Sean	by Sean	4	766
how do i use format cells to alpha / numeric values Samvid69	by ozgrid.com	2	2,162
Conditional Formatting on Index,Match formula Nadine	by T. Valko	3	2,101
Conditional formatting problem Coco212	by samrah	3	744
Logical Test for blank and then for score Mikesnhu	by PatM	1	1,386
extracting data from one cell to another pat67	by Bob Phillips[_4_]	8	925
summary values across worksheets within the same workbook Gordon[_2_]	by Ormond	2	1,234
Count Multiple Text Entries Craig	by ker_01	1	1,043
Drop list and redirect WT	by L. Howard Kittle	1	1,085
Sharing workbook Olivier	by Gord Dibben	3	733
YES or NO formulas Alyssa	by FSt1	3	673
Sumif Function worduser	by Lars-Åke Aspelin[_4_]	1	1,317
how do I freeze the time in the NOW() function? George, the neophyte	by abdulla	3	3,242
determine a range using a formula Jonathon Shull	by Jonathon Shull	2	681
Need some help with auto-fill Per Carlsson	by Pete_UK	1	593
VBA to autofill from relative location AlexJarvis	by AlexJarvis	2	3,738
SAMPLE EXCEL DATA EricB	by Jacob Skaria	2	1,194
Format a dollar amount to text Jordan	by Gord Dibben	4	763
negative value Radhakant Panigrahi	by JLatham	6	622
Multiple AND OR functions Woodi2	by Steve Dunn	5	946
Pick List + Alphabetical Skip To or Auto Complete Hark2k	by Steve Dunn	2	1,469
IF formula help Mark D[_2_]	by Ms-Exl-Learner	2	680
Email one worksheet to email address on worksheet Veronica Johnson	by Melisa Hutchins	4	1,074
VLOOKUP help (possible format issue) Mark D[_2_]	by Mark D[_2_]	6	958
counting unique text values in an array of data selltrue	by Steve Dunn	1	674
search excel for overpopulated cells darrick	by Steve Dunn	1	1,035
Help with lookup CW	by Eduardo	3	515
Dynamic sheet reference in Name formula Raj[_2_]	by Bob Phillips[_4_]	1	1,740
need to install DVZXLAddin.xla kiran	by Ms-Exl-Learner	1	1,153
Average If... Nadine	by Steve Dunn	12	1,424
protection error Selen	by Jacob Skaria	2	964
adding time in a work schedule Chris	by Jacob Skaria	5	1,130
Vlookup return 2nd match MarkinArk	by ozgrid.com	2	2,722
Average IF Function SandiVaughn	by T. Valko	3	1,691
Adding fill to cells only when value is "No" in another cell Noel	by Fred Smith[_4_]	1	661
Counting Results of Formulas jgupte	by T. Valko	1	1,178
need formula to add two different criteria in a range Meenie	by Dave Peterson	6	1,203
Dynamic pivot table linked to dynamic excel spreadsheets FErd	by FErd	0	1,064
Keeping the format but update the data JoeM[_3_]	by JoeM[_3_]	2	922
date from sheet name JBoulton	by T. Valko	21	1,727
How do I remove data in a row in excel without losing all data in lindad	by Rick Rothstein	1	719