Excel Worksheet Functions - Page 46

Thread / Thread Starter	Last Post	Replies	Views
count if cell if fill with text [email protected]	by T. Valko	2	2,608
create list based on criteria Bexi	by Eva	1	2,608
Lookup Function Not in Ascending Order Jessica Donadio	by Jessica Donadio	14	2,608
hoW TO LOCK AND UNLOCK A CELL USING A FUNCTION/FORMULA Ridhi	by Ridhi	6	2,608
FFT function/algorithm used by Excel xerogel	by Dana DeLouis	3	2,606
Count unique values across two columns with multiple conditions Ert	by Bernd P	4	2,606
Hide Columns based on a cell value Tami	by Don Guillett	10	2,603
Drop Down Lists - assign a value based on selection Neil M	by Ron Coderre	6	2,603
How do I find the earliest dates in a range of dates? JJ	by Pete_UK	3	2,602
Apparent bug in CHIINV! Boris	by merlin666	12	2,602
How do I remove a date at the bottom of an excel sheet? rrogers	by Tim C	1	2,601
SUMIF with rows and columns David Howdon	by David Howdon	5	2,601
Rolling YTD/YTD Dynamic Function Marena	by Marena	2	2,601
How to find which formula in Excel sheet has an invalid reference Jerry Timm	by Alok	1	2,600
Present Value Uneven Cashflows jjones42	by joeu2004[_2_]	6	2,600
TREND and OFFSET gavs73	by smartin	1	2,599
time formatting and time categorizing (vlookup or data validation) MarianneR	by O'C	4	2,599
Accrued late fee calculation JAC	by Jerry W. Lewis	5	2,598
FIND function does not return ZERO when text is not found DOUG01A	by Peo Sjoblom[_2_]	5	2,598
Complicated counting of cells (based on other cells contents) George	by Bob Phillips	3	2,597
EOWEEK --- similar to EOMONTH Jonathan Horvath	by Jonathan Horvath	3	2,597
Need greater than = .. less than = combined with index/match state Dingy101	by David Biddulph[_2_]	8	2,596
Converting text format of time/date into Excel time/date for subtr YY san.[_2_]	by David Biddulph[_2_]	6	2,596
How to remove multiple hyperlinks at once Janne Siukkola	by Pete_UK	1	2,596
Cell reference in vlookup not working ericgo	by Dave Mc	4	2,596
convert a nine digit number to base 32 Wildman	by Ron Rosenfeld	14	2,596
Always keeping source formatting when copying and pasting in Excel Mail Merge and Form Protection in Word 2	by Mail Merge and Form Protection in Word 2	0	2,595
Deleting 3 Text characters from the right Helen	by ww	7	2,595
Nested IF statements John Simons	by Arvi Laanemets	14	2,595
How to undo the same document opening twice :1 and :2? Need Advice	by Dave Peterson	3	2,593
how do you create a floating row? Jeff	by Fred Smith	1	2,592
using vlookup to delete duplicate data carolj	by carolj	4	2,592
AVERAGE excluding #N/A RonB	by Ken Wright	3	2,592
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? ARADER	by Gord Dibben	3	2,592
Highlight row a random color Altan	by [email protected]	2	2,592
Cell to cell movement with arrow keys moves entire sheet ken heinemann	by Dave Peterson	1	2,591
Count if date is between two dates and value in another column equ mg_sv_r	by Bob Phillips	2	2,591
Vlookup and match part of text in a cell Joe Phan	by T. Valko	3	2,591
Cell Entry That Locks Selected Cells From Any Data Entry. ron	by Elkar	5	2,591
Custom Data Validation : Lock if MyCell = ""? RayportingMonkey	by RayportingMonkey	5	2,590
vlookup or dget with multiple condition - help please Eddy Stan	by Max	4	2,590
Excel function needed smoborny	by Ron Rosenfeld[_2_]	24	2,590
I can't paste from one cell to multiple cells anymore. fdavis	by Claus Busch	5	2,590
Calculating daily totals from multiple worksheets (Excel 2003) Dhardy	by Dhardy	4	2,589
Group under Data Group and Outline Data not working. Help. Michele	by Dave Peterson	2	2,588
Pivot Table multiple grand totals RoofIL	by Herbert Seidenberg	4	2,588
search multiple worksheets for an item and return the Wsheets name Chris	by Chris	16	2,588
Using Cell Contents to Select Worksheet with Same Name as Cell Con Alan Sexter	by Simon Lloyd[_281_]	14	2,588
Count Consecutive Numbers in a Row Sam via OfficeKB.com	by Sam via OfficeKB.com	5	2,588
Comments won't print in spreadsheet Penny	by ryguy7272	1	2,587
Array formula SUMIF with 2D sum_range array Rich_84	by Bernard Liengme[_3_]	3	2,586
excel 2003 page numbering art	by art	3	2,586
Sumproduct "not equal" Terry	by David Biddulph[_2_]	4	2,585
excel - rows repeat on top cxxper	by amorfelici	4	2,585
Google search box on excel Dileep Chandran	by Dileep Chandran	7	2,585
formula to add six months to date lonedove288	by Ron Rosenfeld	3	2,584
WORKDAY Function in an IF statement [email protected]	by [email protected]	2	2,584
Error: Undefined or non-rectangular name Conan Kelly	by Conan Kelly	0	2,583
Copy cell value into blank cells below (full worksheet) SimmoG	by Fesco	4	2,583
=Cell("color",[reference]) Allzero	by Bob Phillips	5	2,582
Return data sorted min to max BCNU	by Domenic[_2_]	1	2,582
How can I display the first business day of the month? Needhelp!	by Sandy Mann	6	2,582
Excel not recognizing equal values san-avsc	by san-avsc	5	2,581
Conditional SUM for Budget, Actuals, & Variance YTD columns [email protected]	by [email protected]	0	2,579
Excel Formula for years and months Newfie809	by David Heaton[_2_]	2	2,578
adding a round function to an existing formula Deb Paiement	by Deb Paiement[_2_]	2	2,578
Text Import Wizard, Step 3 (converting .tsv file to Excel) Eve	by Eve	2	2,578
How can I convert binary numbers to decimal when they are larger . Nebulae	by JE McGimpsey	1	2,577
How do I move comment indicator to different corner of cell? TVK	by Debra Dalgleish	1	2,577
Is it possible to extend the number of fields in an Excel form? Daddy Sage	by Daddy Sage	13	2,576
Short Way to Calculate Salary Increases John	by John	0	2,576
How do I turn off header and footer in 2007? whitetop	by Eduardo	1	2,575
VLOOKUP referencing a cell with a URL corlev	by Gary''s Student	1	2,575
count colored cells? DKY	by [email protected]	21	2,574
Conditional formatting to exclude weekend and Bank Holidays Paul	by Ron Rosenfeld	12	2,574