Excel Worksheet Functions - Page 17

Thread / Thread Starter	Last Post	Replies	Views
Lookup or search using the * character Steve Venianakis	by Claus Busch	1	626
Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo jeannie v	by [email protected]	8	3,732
time_report_date-wise_employee-wise via135	by via135	6	662
Problem formatting dates from CSV file rhhince[_2_]	by bisogun35	3	584
Created invoices in Excel - not working in Drive [email protected]	by GS[_2_]	1	723
Combining Hlookup and vlookup Dale	by [email protected]	6	1,638
Hide columns based on row values [email protected]	by [email protected]	2	673
Cells not updated automatically CS Chia	by GS[_2_]	3	794
Help with long if then statement Szpila	by Ron Rosenfeld[_2_]	1	607
IF Statement on multiple levels ljochmann	by ljochmann	5	780
Payment calculation MyVeryOwnSelf[_3_]	by MyVeryOwnSelf[_3_]	0	651
how to do data validation in excel [email protected]	by Claus Busch	1	611
VanillaSoft Changes [email protected]	by [email protected]	0	518
Match issue Sking	by Sking	3	662
Excel is too complicated for me Leah1668	by [email protected]	5	761
SUMIF Help CharlieCC	by [email protected]	4	611
VLookup + IF reidynem	by Claus Busch	6	713
SUMPRODUCT formula I think w/ wild card & number vs number as text L. Howard	by Claus Busch	8	935
Subtracting time...again wabbleknee	by wabbleknee	2	479
Adding cells until they are greater than a lookup cell and returning a value thunderbirdlindy	by Claus Busch	1	555
Payout based on hours rate and designation [email protected]	by [email protected]	6	890
Getting a formula to reflect added columns alittlehelp	by GS[_2_]	10	1,312
Need a proper guru! My head hurts ;( xix_xix	by xix_xix	1	754
How to get largest date from a Vlookup Madiya	by Claus Busch	1	731
Function in Excel to count and list number of entries of text valuesin a row. JRC[_3_]	by Gord Dibben[_2_]	2	678
Returning 1 of 4 values if conditions are met Tricia Griffiths	by Tricia Griffiths	4	692
Sumif apllying to all sheets in workbook wdstylr	by Don Guillett[_2_]	2	794
Nested if statements creating a blank cell ruthhicks999	by Ron Rosenfeld[_2_]	1	763
Merging cells and formats Walter Briscoe	by Walter Briscoe	8	991
grand totals in pivot table rows [email protected]	by [email protected]	1	834
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET [email protected]	by GS[_2_]	6	865
Column header for Max value? Index/array function? Cecilia	by [email protected]	5	2,657
Calculate end date and time chciknwing	by Ron Rosenfeld[_2_]	1	568
basketball scoring old coach	by old coach	0	559
need help on either doing a loop and counting specific values orusing subtotal function Mike Ruiz	by Mike Ruiz	2	758
XIRR vs. IRR Function CMLDALLAS	by Robert Miller	10	4,211
work hours with different hour prices [email protected]	by [email protected]	12	1,496
Sports Comp Ladder tabulating help needed shaunl	by [email protected]	12	2,000
Multiple arguments Tim S	by Ron Rosenfeld[_2_]	3	777
Count Number of Unique Cells That Don't Have Certain Characters limh5	by Howard Silcock	1	619
Finding location (or start cell) of highest consecutive values Emilio Guerra	by Emilio Guerra	3	698
Is there a function to count how many times a cells value is used? Pistolade	by Pistolade	0	563
Simple nested if and statement GW	by [email protected]	2	735
Perplexed by simple Icon Set Cond. Formatting Issue CJoQ	by CJoQ	0	501
convert sum number to a set number John	by [email protected]	2	3,564
Finding NROI - no return on investment and RONI - return on noinvestment in Excel Abraham A	by Abraham A	0	783
Excel considers my formulas as plain text Kimmo Kallio	by OldDomGuy	10	2,442
Wotksheets Roy Penny	by Roy Penny	0	456
SUMIF between 2 dates rhhince[_2_]	by Claus Busch	1	420
Avoiding auxiliary cells Walter Briscoe	by Howard Silcock	1	773
Conditional Highlight Colin Hayes	by Colin Hayes	2	529
State Tax Business Calculations Help KathyP143	by Claus Busch	1	473
test L. Howard	by L. Howard	0	369
Pasting a range to a single cell [email protected]	by [email protected]	0	401
Carry over YTD balance to next worksheet jackreacher	by Gord Dibben[_2_]	4	1,080
Excel: counting times and dates during non-traditional hours Deuces	by Deuces	0	529
Formula not working properly HopsBarley	by Ron Rosenfeld[_2_]	2	496
Graphing using FORMAT Jack Deuce	by Jack Deuce	0	408
Conditional Formatting to Another Cell hbcobra	by hbcobra	0	438
add hyperlink using sheet names and cells(i,j) tuli	by Claus Busch	3	628
Time Sum in Excel Holly Allen	by GS[_2_]	1	561
IF function says too many nested [email protected]	by Ron Rosenfeld[_2_]	2	631
Formula to multiply numbers intervals Carpe Diem	by Claus Busch	1	983
Syncing between source worksheet and dependent worksheets Joseph Anthony James	by Joseph Anthony James	0	442
Lookup whole sheet and add datas from specified date to end date akash_7869	by akash_7869	0	417
Sort Question [email protected]	by Claus Busch	1	418
Excel Pagination Function [email protected]	by [email protected]	0	748
"Send to mail recipient" is dimmed out on my tool bar SRU	by Blake[_4_]	2	1,233
countifs Function not giving desired result with date criteria San[_4_]	by San[_4_]	2	577
Conditional formatting dates FEVOOO	by Lisa Wilke-Thissen	3	578
Need a ) somewhere in ISERROR formula but don't know where to put it [email protected]	by Claus Busch	3	423
Depedent Dropdown and INDIRECT($P$8) with a twist [email protected]	by [email protected]	4	653
calculating average handling time nitesh katoch	by Claus Busch	7	643
Copy 2 cells to 1 cell BigGuy	by Auric__	1	483
index function eltyar	by Claus Busch	1	502