Excel Worksheet Functions - Page 430

Thread / Thread Starter	Last Post	Replies	Views
Running a macro Derek Upson - Pioneer	by Derek Upson - Pioneer	5	480
conditionally format anumber format Montana	by [email protected]	5	546
find all same numbers in a column without dropdown listing ShoDan	by CLR	3	435
Find value in more than 100 worksheets at once Alamgir Farooq	by Dave Peterson	2	397
copy and paste. Gary	by Bernie Deitrick	1	390
Capitalize first letter in sentence Lightjag	by Gaurav[_2_]	13	2,444
Accumulating Attendance Base upon Age Group Neon520	by Bob Phillips	5	531
Array or SumProduct or other? TMK	by TMK	3	429
Replacing a Table-array with a cell reference in vlookup Allan	by Mike H	4	3,849
Challenge: Return the rightmost 12 values (rolling 12 months) mr tom	by mr tom	2	850
Use Formula to sort two strings Ray Ray	by David Biddulph[_2_]	2	713
Auto populate data from a table into cells after a match is found CrashOz	by Pete_UK	5	838
Calculating time Pastor Selma	by carlo	4	507
Ranking with Duplicates [email protected]	by T. Valko	1	630
Convert numbers to words Rick[_7_]	by Rick Rothstein \(MVP - VB\)	2	558
Autocomplete combo box Learning Excel	by T. Valko	5	836
Convert Number to Words Rick[_7_]	by Gord Dibben	2	777
Problem w/formula referencing another sheet PatrickP	by PatrickP	1	519
Remove Negative Signs from Formula Results Holly	by T. Valko	4	5,114
how do I enter a reoccuring event like once every 9 days kemomama	by kemomama	0	942
Copy from worksheet to worksheet Bob	by Colleen A	3	419
Average & Deviation ross27	by Tyro[_2_]	1	623
count(if(... using array formula: can I use a named range in my ca katy	by katy	1	913
If Then Or Statement nabanco	by Max	3	398
invalid references Shooter	by Gord Dibben	2	710
Leave Cell BLANK if no criteria met Neon520	by T. Valko	2	1,767
I have the checkmark beside print gridlines and they won't print Lois	by MartinW	3	501
Worksheet tab labels Brenda463	by Gord Dibben	7	481
DCOUNTA question Barb Reinhardt	by Barb Reinhardt	0	494
How Do You Stop Annoying Excel Message Boxes? Colin Hayes	by Colin Hayes	36	3,797
What function do i use? motorman2008	by LiveUser	2	388
Not all words in sentence prints - row is set autofit HELP? Marita	by Marita	0	492
Explode field JustJo	by Jim Cone	3	542
SUMPRODUCT, INDIRECT, dates... LongTermNoob	by T. Valko	5	555
Consolidating worksheets mimilave	by mimilave	0	475
reference first cell in a named range Robert H	by Robert H	3	5,137
Converting a Formula stored as String to real Formula BlueD	by JP[_4_]	3	790
Probelm with macro mac	by Gord Dibben	5	489
Nesting SUMIF with Wildcard ShannaD	by T. Valko	3	679
average(if not working properly Gaurav[_2_]	by Gaurav[_2_]	7	1,837
constant date medavino	by Gord Dibben	3	517
Excel macro spreadsheet that is rejected by other firewall. Why? illini10000	by Roger Govier[_3_]	2	1,073
No. of Saturdays between 2 dates Bhupinder Rayat	by Ron Rosenfeld	5	978
Paste from clipboard only taa	by taa	0	601
6 cell sum dc04wrightl	by RB[_2_]	2	406
date entry medavino	by CLR	1	354
Not sure which function to use - need multiple lines of data Bob	by Duke Carey	1	567
converting .html to regen lost .xls file dr nemo	by dr nemo	0	524
referencing a 3D Named Range Robert H	by Harlan Grove[_2_]	3	870
Writing a macro RB[_2_]	by RB[_2_]	0	426
how do I change a date to show the year only? Nicholw	by CLR	2	500
Duplicates in a spread sheet Martha	by ryguy7272	3	503
"Grouping" based on value in a column Fred	by ryguy7272	3	380
Basic Statistics - which function? REM[_2_]	by ilia	3	467
Macro error orquidea	by orquidea	2	448
Automatic Drop Down List aeddave	by JP[_4_]	3	405
Compare two lists; return only unique records Lkyred19	by ryguy7272	3	1,989
how to I determine frequency Sandi	by ryguy7272	5	557
how to sum only specific coloured cells ali1h	by JE McGimpsey	2	631
how can i write an equation in polar form in excel vi_friend	by Herbert Seidenberg	3	5,467
Is there a way to turn off the auto save function? timbo29	by Gav123	3	690
large database with multiple rows Steve	by Max	2	691
how do i bring back excel sheet ? MoBi	by David Biddulph[_2_]	3	593
Problem encountered when saving worksheet as a text file Ginge1968	by Pete_UK	3	423
clear the file now available msgbox Jive	by Jive	2	439
Automatically extracting unique values Blue Max	by Ron Rosenfeld	5	1,062
Express a Formula that is + or - 20% from a Value Q Sean	by Pete_UK	3	416
How do i use a 24 hour clock format on my timesheet? grant	by Tyro[_2_]	2	1,450
New version of Excel doesn't show my other worksheets! Doug1943	by Mike Middleton	1	767
need a function or property to extract the hyperlink from a cell J	by David Biddulph[_2_]	1	458
Adding criteria to loop Andyjim	by Andyjim	0	596
problem data validation and copy/paste Theo	by Theo	2	2,029
Using a macro to paste into first empty row in a new worksheet Bruce64	by Theo	3	2,103
Macro HELP Theo	by Theo	0	345
autocomplete from specific list stremetzky	by T. Valko	8	1,330