Excel Worksheet Functions - Page 17

Thread / Thread Starter	Last Post	Replies	Views
Lookup or search using the * character Steve Venianakis	by Claus Busch	1	604
Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo jeannie v	by [email protected]	8	3,655
time_report_date-wise_employee-wise via135	by via135	6	634
Problem formatting dates from CSV file rhhince[_2_]	by bisogun35	3	556
Created invoices in Excel - not working in Drive [email protected]	by GS[_2_]	1	686
Combining Hlookup and vlookup Dale	by [email protected]	6	1,592
Hide columns based on row values [email protected]	by [email protected]	2	636
Cells not updated automatically CS Chia	by GS[_2_]	3	766
Help with long if then statement Szpila	by Ron Rosenfeld[_2_]	1	576
IF Statement on multiple levels ljochmann	by ljochmann	5	746
Payment calculation MyVeryOwnSelf[_3_]	by MyVeryOwnSelf[_3_]	0	627
how to do data validation in excel [email protected]	by Claus Busch	1	582
VanillaSoft Changes [email protected]	by [email protected]	0	490
Match issue Sking	by Sking	3	631
Excel is too complicated for me Leah1668	by [email protected]	5	731
SUMIF Help CharlieCC	by [email protected]	4	584
VLookup + IF reidynem	by Claus Busch	6	679
SUMPRODUCT formula I think w/ wild card & number vs number as text L. Howard	by Claus Busch	8	898
Subtracting time...again wabbleknee	by wabbleknee	2	448
Adding cells until they are greater than a lookup cell and returning a value thunderbirdlindy	by Claus Busch	1	534
Payout based on hours rate and designation [email protected]	by [email protected]	6	860
Getting a formula to reflect added columns alittlehelp	by GS[_2_]	10	1,285
Need a proper guru! My head hurts ;( xix_xix	by xix_xix	1	724
How to get largest date from a Vlookup Madiya	by Claus Busch	1	710
Function in Excel to count and list number of entries of text valuesin a row. JRC[_3_]	by Gord Dibben[_2_]	2	651
Returning 1 of 4 values if conditions are met Tricia Griffiths	by Tricia Griffiths	4	664
Sumif apllying to all sheets in workbook wdstylr	by Don Guillett[_2_]	2	767
Nested if statements creating a blank cell ruthhicks999	by Ron Rosenfeld[_2_]	1	745
Merging cells and formats Walter Briscoe	by Walter Briscoe	8	944
grand totals in pivot table rows [email protected]	by [email protected]	1	804
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET [email protected]	by GS[_2_]	6	838
Column header for Max value? Index/array function? Cecilia	by [email protected]	5	2,630
Calculate end date and time chciknwing	by Ron Rosenfeld[_2_]	1	545
basketball scoring old coach	by old coach	0	536
need help on either doing a loop and counting specific values orusing subtotal function Mike Ruiz	by Mike Ruiz	2	729
XIRR vs. IRR Function CMLDALLAS	by Robert Miller	10	4,147
work hours with different hour prices [email protected]	by [email protected]	12	1,465
Sports Comp Ladder tabulating help needed shaunl	by [email protected]	12	1,942
Multiple arguments Tim S	by Ron Rosenfeld[_2_]	3	752
Count Number of Unique Cells That Don't Have Certain Characters limh5	by Howard Silcock	1	591
Finding location (or start cell) of highest consecutive values Emilio Guerra	by Emilio Guerra	3	664
Is there a function to count how many times a cells value is used? Pistolade	by Pistolade	0	540
Simple nested if and statement GW	by [email protected]	2	709
Perplexed by simple Icon Set Cond. Formatting Issue CJoQ	by CJoQ	0	481
convert sum number to a set number John	by [email protected]	2	3,537
Finding NROI - no return on investment and RONI - return on noinvestment in Excel Abraham A	by Abraham A	0	756
Excel considers my formulas as plain text Kimmo Kallio	by OldDomGuy	10	2,391
Wotksheets Roy Penny	by Roy Penny	0	438
SUMIF between 2 dates rhhince[_2_]	by Claus Busch	1	382
Avoiding auxiliary cells Walter Briscoe	by Howard Silcock	1	743
Conditional Highlight Colin Hayes	by Colin Hayes	2	467
State Tax Business Calculations Help KathyP143	by Claus Busch	1	432
test L. Howard	by L. Howard	0	346
Pasting a range to a single cell [email protected]	by [email protected]	0	385
Carry over YTD balance to next worksheet jackreacher	by Gord Dibben[_2_]	4	1,039
Excel: counting times and dates during non-traditional hours Deuces	by Deuces	0	514
Formula not working properly HopsBarley	by Ron Rosenfeld[_2_]	2	470
Graphing using FORMAT Jack Deuce	by Jack Deuce	0	391
Conditional Formatting to Another Cell hbcobra	by hbcobra	0	408
add hyperlink using sheet names and cells(i,j) tuli	by Claus Busch	3	605
Time Sum in Excel Holly Allen	by GS[_2_]	1	545
IF function says too many nested [email protected]	by Ron Rosenfeld[_2_]	2	600
Formula to multiply numbers intervals Carpe Diem	by Claus Busch	1	959
Syncing between source worksheet and dependent worksheets Joseph Anthony James	by Joseph Anthony James	0	425
Lookup whole sheet and add datas from specified date to end date akash_7869	by akash_7869	0	389
Sort Question [email protected]	by Claus Busch	1	389
Excel Pagination Function [email protected]	by [email protected]	0	706
"Send to mail recipient" is dimmed out on my tool bar SRU	by Blake[_4_]	2	1,210
countifs Function not giving desired result with date criteria San[_4_]	by San[_4_]	2	553
Conditional formatting dates FEVOOO	by Lisa Wilke-Thissen	3	547
Need a ) somewhere in ISERROR formula but don't know where to put it [email protected]	by Claus Busch	3	401
Depedent Dropdown and INDIRECT($P$8) with a twist [email protected]	by [email protected]	4	630
calculating average handling time nitesh katoch	by Claus Busch	7	618
Copy 2 cells to 1 cell BigGuy	by Auric__	1	447
index function eltyar	by Claus Busch	1	481