Excel Worksheet Functions - Page 17

Thread / Thread Starter	Last Post	Replies	Views
Lookup or search using the * character Steve Venianakis	by Claus Busch	1	620
Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo jeannie v	by [email protected]	8	3,709
time_report_date-wise_employee-wise via135	by via135	6	647
Problem formatting dates from CSV file rhhince[_2_]	by bisogun35	3	578
Created invoices in Excel - not working in Drive [email protected]	by GS[_2_]	1	720
Combining Hlookup and vlookup Dale	by [email protected]	6	1,626
Hide columns based on row values [email protected]	by [email protected]	2	657
Cells not updated automatically CS Chia	by GS[_2_]	3	780
Help with long if then statement Szpila	by Ron Rosenfeld[_2_]	1	593
IF Statement on multiple levels ljochmann	by ljochmann	5	759
Payment calculation MyVeryOwnSelf[_3_]	by MyVeryOwnSelf[_3_]	0	643
how to do data validation in excel [email protected]	by Claus Busch	1	600
VanillaSoft Changes [email protected]	by [email protected]	0	510
Match issue Sking	by Sking	3	652
Excel is too complicated for me Leah1668	by [email protected]	5	747
SUMIF Help CharlieCC	by [email protected]	4	599
VLookup + IF reidynem	by Claus Busch	6	696
SUMPRODUCT formula I think w/ wild card & number vs number as text L. Howard	by Claus Busch	8	923
Subtracting time...again wabbleknee	by wabbleknee	2	465
Adding cells until they are greater than a lookup cell and returning a value thunderbirdlindy	by Claus Busch	1	542
Payout based on hours rate and designation [email protected]	by [email protected]	6	874
Getting a formula to reflect added columns alittlehelp	by GS[_2_]	10	1,301
Need a proper guru! My head hurts ;( xix_xix	by xix_xix	1	742
How to get largest date from a Vlookup Madiya	by Claus Busch	1	720
Function in Excel to count and list number of entries of text valuesin a row. JRC[_3_]	by Gord Dibben[_2_]	2	668
Returning 1 of 4 values if conditions are met Tricia Griffiths	by Tricia Griffiths	4	676
Sumif apllying to all sheets in workbook wdstylr	by Don Guillett[_2_]	2	784
Nested if statements creating a blank cell ruthhicks999	by Ron Rosenfeld[_2_]	1	753
Merging cells and formats Walter Briscoe	by Walter Briscoe	8	974
grand totals in pivot table rows [email protected]	by [email protected]	1	822
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET [email protected]	by GS[_2_]	6	848
Column header for Max value? Index/array function? Cecilia	by [email protected]	5	2,644
Calculate end date and time chciknwing	by Ron Rosenfeld[_2_]	1	559
basketball scoring old coach	by old coach	0	550
need help on either doing a loop and counting specific values orusing subtotal function Mike Ruiz	by Mike Ruiz	2	750
XIRR vs. IRR Function CMLDALLAS	by Robert Miller	10	4,205
work hours with different hour prices [email protected]	by [email protected]	12	1,485
Sports Comp Ladder tabulating help needed shaunl	by [email protected]	12	1,987
Multiple arguments Tim S	by Ron Rosenfeld[_2_]	3	766
Count Number of Unique Cells That Don't Have Certain Characters limh5	by Howard Silcock	1	606
Finding location (or start cell) of highest consecutive values Emilio Guerra	by Emilio Guerra	3	687
Is there a function to count how many times a cells value is used? Pistolade	by Pistolade	0	557
Simple nested if and statement GW	by [email protected]	2	723
Perplexed by simple Icon Set Cond. Formatting Issue CJoQ	by CJoQ	0	493
convert sum number to a set number John	by [email protected]	2	3,553
Finding NROI - no return on investment and RONI - return on noinvestment in Excel Abraham A	by Abraham A	0	772
Excel considers my formulas as plain text Kimmo Kallio	by OldDomGuy	10	2,423
Wotksheets Roy Penny	by Roy Penny	0	445
SUMIF between 2 dates rhhince[_2_]	by Claus Busch	1	404
Avoiding auxiliary cells Walter Briscoe	by Howard Silcock	1	765
Conditional Highlight Colin Hayes	by Colin Hayes	2	520
State Tax Business Calculations Help KathyP143	by Claus Busch	1	458
test L. Howard	by L. Howard	0	359
Pasting a range to a single cell [email protected]	by [email protected]	0	399
Carry over YTD balance to next worksheet jackreacher	by Gord Dibben[_2_]	4	1,068
Excel: counting times and dates during non-traditional hours Deuces	by Deuces	0	520
Formula not working properly HopsBarley	by Ron Rosenfeld[_2_]	2	483
Graphing using FORMAT Jack Deuce	by Jack Deuce	0	400
Conditional Formatting to Another Cell hbcobra	by hbcobra	0	427
add hyperlink using sheet names and cells(i,j) tuli	by Claus Busch	3	615
Time Sum in Excel Holly Allen	by GS[_2_]	1	552
IF function says too many nested [email protected]	by Ron Rosenfeld[_2_]	2	617
Formula to multiply numbers intervals Carpe Diem	by Claus Busch	1	974
Syncing between source worksheet and dependent worksheets Joseph Anthony James	by Joseph Anthony James	0	435
Lookup whole sheet and add datas from specified date to end date akash_7869	by akash_7869	0	408
Sort Question [email protected]	by Claus Busch	1	408
Excel Pagination Function [email protected]	by [email protected]	0	728
"Send to mail recipient" is dimmed out on my tool bar SRU	by Blake[_4_]	2	1,221
countifs Function not giving desired result with date criteria San[_4_]	by San[_4_]	2	566
Conditional formatting dates FEVOOO	by Lisa Wilke-Thissen	3	566
Need a ) somewhere in ISERROR formula but don't know where to put it [email protected]	by Claus Busch	3	414
Depedent Dropdown and INDIRECT($P$8) with a twist [email protected]	by [email protected]	4	640
calculating average handling time nitesh katoch	by Claus Busch	7	635
Copy 2 cells to 1 cell BigGuy	by Auric__	1	473
index function eltyar	by Claus Busch	1	490