Excel Worksheet Functions - Page 17

Thread / Thread Starter	Last Post	Replies	Views
Lookup or search using the * character Steve Venianakis	by Claus Busch	1	617
Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo jeannie v	by [email protected]	8	3,700
time_report_date-wise_employee-wise via135	by via135	6	643
Problem formatting dates from CSV file rhhince[_2_]	by bisogun35	3	571
Created invoices in Excel - not working in Drive [email protected]	by GS[_2_]	1	715
Combining Hlookup and vlookup Dale	by [email protected]	6	1,619
Hide columns based on row values [email protected]	by [email protected]	2	652
Cells not updated automatically CS Chia	by GS[_2_]	3	774
Help with long if then statement Szpila	by Ron Rosenfeld[_2_]	1	589
IF Statement on multiple levels ljochmann	by ljochmann	5	753
Payment calculation MyVeryOwnSelf[_3_]	by MyVeryOwnSelf[_3_]	0	638
how to do data validation in excel [email protected]	by Claus Busch	1	593
VanillaSoft Changes [email protected]	by [email protected]	0	503
Match issue Sking	by Sking	3	645
Excel is too complicated for me Leah1668	by [email protected]	5	743
SUMIF Help CharlieCC	by [email protected]	4	593
VLookup + IF reidynem	by Claus Busch	6	692
SUMPRODUCT formula I think w/ wild card & number vs number as text L. Howard	by Claus Busch	8	920
Subtracting time...again wabbleknee	by wabbleknee	2	462
Adding cells until they are greater than a lookup cell and returning a value thunderbirdlindy	by Claus Busch	1	539
Payout based on hours rate and designation [email protected]	by [email protected]	6	872
Getting a formula to reflect added columns alittlehelp	by GS[_2_]	10	1,298
Need a proper guru! My head hurts ;( xix_xix	by xix_xix	1	739
How to get largest date from a Vlookup Madiya	by Claus Busch	1	717
Function in Excel to count and list number of entries of text valuesin a row. JRC[_3_]	by Gord Dibben[_2_]	2	660
Returning 1 of 4 values if conditions are met Tricia Griffiths	by Tricia Griffiths	4	670
Sumif apllying to all sheets in workbook wdstylr	by Don Guillett[_2_]	2	778
Nested if statements creating a blank cell ruthhicks999	by Ron Rosenfeld[_2_]	1	750
Merging cells and formats Walter Briscoe	by Walter Briscoe	8	970
grand totals in pivot table rows [email protected]	by [email protected]	1	818
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET [email protected]	by GS[_2_]	6	846
Column header for Max value? Index/array function? Cecilia	by [email protected]	5	2,640
Calculate end date and time chciknwing	by Ron Rosenfeld[_2_]	1	557
basketball scoring old coach	by old coach	0	546
need help on either doing a loop and counting specific values orusing subtotal function Mike Ruiz	by Mike Ruiz	2	745
XIRR vs. IRR Function CMLDALLAS	by Robert Miller	10	4,201
work hours with different hour prices [email protected]	by [email protected]	12	1,482
Sports Comp Ladder tabulating help needed shaunl	by [email protected]	12	1,977
Multiple arguments Tim S	by Ron Rosenfeld[_2_]	3	760
Count Number of Unique Cells That Don't Have Certain Characters limh5	by Howard Silcock	1	604
Finding location (or start cell) of highest consecutive values Emilio Guerra	by Emilio Guerra	3	684
Is there a function to count how many times a cells value is used? Pistolade	by Pistolade	0	555
Simple nested if and statement GW	by [email protected]	2	719
Perplexed by simple Icon Set Cond. Formatting Issue CJoQ	by CJoQ	0	489
convert sum number to a set number John	by [email protected]	2	3,551
Finding NROI - no return on investment and RONI - return on noinvestment in Excel Abraham A	by Abraham A	0	771
Excel considers my formulas as plain text Kimmo Kallio	by OldDomGuy	10	2,411
Wotksheets Roy Penny	by Roy Penny	0	443
SUMIF between 2 dates rhhince[_2_]	by Claus Busch	1	403
Avoiding auxiliary cells Walter Briscoe	by Howard Silcock	1	762
Conditional Highlight Colin Hayes	by Colin Hayes	2	518
State Tax Business Calculations Help KathyP143	by Claus Busch	1	444
test L. Howard	by L. Howard	0	355
Pasting a range to a single cell [email protected]	by [email protected]	0	396
Carry over YTD balance to next worksheet jackreacher	by Gord Dibben[_2_]	4	1,051
Excel: counting times and dates during non-traditional hours Deuces	by Deuces	0	519
Formula not working properly HopsBarley	by Ron Rosenfeld[_2_]	2	481
Graphing using FORMAT Jack Deuce	by Jack Deuce	0	398
Conditional Formatting to Another Cell hbcobra	by hbcobra	0	423
add hyperlink using sheet names and cells(i,j) tuli	by Claus Busch	3	613
Time Sum in Excel Holly Allen	by GS[_2_]	1	549
IF function says too many nested [email protected]	by Ron Rosenfeld[_2_]	2	614
Formula to multiply numbers intervals Carpe Diem	by Claus Busch	1	971
Syncing between source worksheet and dependent worksheets Joseph Anthony James	by Joseph Anthony James	0	433
Lookup whole sheet and add datas from specified date to end date akash_7869	by akash_7869	0	406
Sort Question [email protected]	by Claus Busch	1	406
Excel Pagination Function [email protected]	by [email protected]	0	721
"Send to mail recipient" is dimmed out on my tool bar SRU	by Blake[_4_]	2	1,219
countifs Function not giving desired result with date criteria San[_4_]	by San[_4_]	2	565
Conditional formatting dates FEVOOO	by Lisa Wilke-Thissen	3	565
Need a ) somewhere in ISERROR formula but don't know where to put it [email protected]	by Claus Busch	3	413
Depedent Dropdown and INDIRECT($P$8) with a twist [email protected]	by [email protected]	4	638
calculating average handling time nitesh katoch	by Claus Busch	7	633
Copy 2 cells to 1 cell BigGuy	by Auric__	1	467
index function eltyar	by Claus Busch	1	488