Excel Worksheet Functions - Page 430

Thread / Thread Starter	Last Post	Replies	Views
Running a macro Derek Upson - Pioneer	by Derek Upson - Pioneer	5	469
conditionally format anumber format Montana	by [email protected]	5	546
find all same numbers in a column without dropdown listing ShoDan	by CLR	3	426
Find value in more than 100 worksheets at once Alamgir Farooq	by Dave Peterson	2	396
copy and paste. Gary	by Bernie Deitrick	1	384
Capitalize first letter in sentence Lightjag	by Gaurav[_2_]	13	2,444
Accumulating Attendance Base upon Age Group Neon520	by Bob Phillips	5	530
Array or SumProduct or other? TMK	by TMK	3	420
Replacing a Table-array with a cell reference in vlookup Allan	by Mike H	4	3,842
Challenge: Return the rightmost 12 values (rolling 12 months) mr tom	by mr tom	2	840
Use Formula to sort two strings Ray Ray	by David Biddulph[_2_]	2	704
Auto populate data from a table into cells after a match is found CrashOz	by Pete_UK	5	827
Calculating time Pastor Selma	by carlo	4	497
Ranking with Duplicates [email protected]	by T. Valko	1	624
Convert numbers to words Rick[_7_]	by Rick Rothstein \(MVP - VB\)	2	555
Autocomplete combo box Learning Excel	by T. Valko	5	825
Convert Number to Words Rick[_7_]	by Gord Dibben	2	773
Problem w/formula referencing another sheet PatrickP	by PatrickP	1	512
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	618
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	391
invalid references Shooter	by Gord Dibben	2	705
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	480
DCOUNTA question Barb Reinhardt	by Barb Reinhardt	0	494
How Do You Stop Annoying Excel Message Boxes? Colin Hayes	by Colin Hayes	36	3,790
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	482
Explode field JustJo	by Jim Cone	3	532
SUMPRODUCT, INDIRECT, dates... LongTermNoob	by T. Valko	5	552
Consolidating worksheets mimilave	by mimilave	0	475
reference first cell in a named range Robert H	by Robert H	3	5,132
Converting a Formula stored as String to real Formula BlueD	by JP[_4_]	3	789
Probelm with macro mac	by Gord Dibben	5	483
Nesting SUMIF with Wildcard ShannaD	by T. Valko	3	672
average(if not working properly Gaurav[_2_]	by Gaurav[_2_]	7	1,834
constant date medavino	by Gord Dibben	3	509
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	969
Paste from clipboard only taa	by taa	0	601
6 cell sum dc04wrightl	by RB[_2_]	2	403
date entry medavino	by CLR	1	354
Not sure which function to use - need multiple lines of data Bob	by Duke Carey	1	556
converting .html to regen lost .xls file dr nemo	by dr nemo	0	519
referencing a 3D Named Range Robert H	by Harlan Grove[_2_]	3	863
Writing a macro RB[_2_]	by RB[_2_]	0	418
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	494
"Grouping" based on value in a column Fred	by ryguy7272	3	372
Basic Statistics - which function? REM[_2_]	by ilia	3	457
Macro error orquidea	by orquidea	2	439
Automatic Drop Down List aeddave	by JP[_4_]	3	402
Compare two lists; return only unique records Lkyred19	by ryguy7272	3	1,989
how to I determine frequency Sandi	by ryguy7272	5	551
how to sum only specific coloured cells ali1h	by JE McGimpsey	2	622
how can i write an equation in polar form in excel vi_friend	by Herbert Seidenberg	3	5,460
Is there a way to turn off the auto save function? timbo29	by Gav123	3	681
large database with multiple rows Steve	by Max	2	690
how do i bring back excel sheet ? MoBi	by David Biddulph[_2_]	3	592
Problem encountered when saving worksheet as a text file Ginge1968	by Pete_UK	3	416
clear the file now available msgbox Jive	by Jive	2	431
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	413
How do i use a 24 hour clock format on my timesheet? grant	by Tyro[_2_]	2	1,441
New version of Excel doesn't show my other worksheets! Doug1943	by Mike Middleton	1	764
need a function or property to extract the hyperlink from a cell J	by David Biddulph[_2_]	1	448
Adding criteria to loop Andyjim	by Andyjim	0	596
problem data validation and copy/paste Theo	by Theo	2	2,019
Using a macro to paste into first empty row in a new worksheet Bruce64	by Theo	3	2,092
Macro HELP Theo	by Theo	0	335
autocomplete from specific list stremetzky	by T. Valko	8	1,328