Excel Worksheet Functions - Page 15

Thread / Thread Starter	Last Post	Replies	Views
Can I convert a number(1-365) to a month and day of a year? rnc	by Shane Devenshire	4	5,210
IF - THEN - OTHERWISE -......UNLESS! ??? dim	by dim	11	5,202
Can SUMIFS use the OR function? Ted M H	by T. Valko	7	5,199
How to Copy single Cell into Multiple cells Nitesh Mathur	by Max	3	5,199
change the orientation of a worksheet to Landscape epoliver	by Gord Dibben	2	5,194
How do I make GRID LINES print LIGTHER dee	by Shane Devenshire[_2_]	3	5,191
how do I delete data in a cell without deleting formula? tripy	by Tim Paine	9	5,191
convert 100 minute hour to a 60 minute hour Todd	by Frank Kabel	1	5,183
Referencing text in merged cells Woofaloo	by T. Valko	1	5,183
Counting from the Bottom Up SwearBear	by T. Valko	14	5,182
Header Row with Option to Shrink/Expand Rows Beneath kippers	by Jacob Skaria	2	5,180
add apostrophe to text in cell WJS	by Ashish Mathur[_2_]	3	5,178
Excel F2 not working... prominND	by Toni Johnston	3	5,174
How to make random numbers stay the same wyobuff	by ShaneDevenshire	4	5,171
I've forgot password in my worksheet,how to unprotect the sheet? bigniwat	by Ny bruker	5	5,169
Edit Replace the third digit only of a number Hammertime	by JE McGimpsey	3	5,168
How to change the direction of the enter key to go horizontal BManske	by [email protected]	5	5,161
Output of the =IF(COUNTA) Function Excel Helps	by Excel Helps	2	5,160
Canadian Mortgage Formula AFQ	by AFQ	2	5,155
Formula to determine whether number falls within range?? Cat	by Cat	4	5,155
indirect function with r1c1 style Zim	by Zim	4	5,155
Using Vlookup for intervals UnisourceforNPH	by Teethless mama	3	5,155
How can I stack worksheets (I have 30 worksheets) Eastendkid	by Dave Peterson	3	5,154
How do I Minus 10% discount On my Excel Invoices On the Sub Total jk	by Bearacade	1	5,153
Amortization template for uneven monthly payments DOUG ODOM	by Fred Smith	1	5,148
Click button to automatically add row yirawan	by Ron de Bruin	1	5,148
How to calculate total interest on 12 month loan with early payments Fred Smith	by Fred Smith	0	5,144
Convert TimeStamp to Minutes EAB1977	by EAB1977	3	5,139
How do I change one repeated word in the spreadsheet to another? Largo	by wjohnson	5	5,137
If statements using less than or equal with dates Tigers00	by T. Valko	2	5,136
what does "," mean in an excel formula Excel Question	by Excel Question	8	5,135
MAX value matching multiple criteria mwd	by BoniM	10	5,135
How do I save part of a worksheet in a separate file? cleo	by Gord Dibben	3	5,133
Icon Sets - Display icon in one cell depending upon value in anoth Nolene	by Nolene	2	5,132
Match / Index multiple criteria return multiple results Marty	by Max	2	5,128
How many Standard Deviations above and below the mean each number is. [email protected]	by [email protected]	4	5,127
How to get Solver to target array rather than cell? h.2	by Tushar Mehta	3	5,123
How do I remove the #div or N/A and make it 0 when using VLookup? JeaneIsaac	by Flcnmech	26	5,123
Finding cells with a value ending in '.0' MDP420	by Rick Rothstein \(MVP - VB\)[_937_]	8	5,123
Difference between two numbers Pam	by Gary''s Student	2	5,121
Can excel pick a random cell from a column? Helene deChappe	by daddylonglegs	6	5,118
VLOOKUP return text not date Paul Dennis	by Stefi	3	5,118
Move/Copy Worksheet -- does not work dbsavoy	by Pete_UK	4	5,115
reference first cell in a named range Robert H	by Robert H	3	5,114
Can Excel trigger Outlook reminder? Andee39	by [email protected]	9	5,104
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o	by dc	6	5,102
Too few arguments plore	by Edd1986	5	5,093
Excel formula that calculates percentage of increase or decrease Ration	by BekkiM	2	5,093
VLookup - Not Exact Match vmagal1	by Max	2	5,091
Return to next row in first column when entering data in Excel DaddyRay	by L. Howard Kittle	3	5,089
How to paste data to alternating cells down a column? wbowers	by Max	1	5,089
Convert Julian to Gregorian Date [email protected]	by Hans Terkelsen	1	5,088
If statement to copy an entire row to other worksheet w/ in same b hshayh0rn	by Luke M	7	5,080
countif only visible cells (filtered) [email protected]	by Dave Peterson	8	5,080
sumifs multiple columns help duketter	by Jacob Skaria	2	5,077
change language setting using VBA code ub	by ub	0	5,073
How can I remove a constant from a cell? ac	by ac	2	5,072
Formula to get date from text string Sara	by Roger Govier[_8_]	2	5,071
How to make a key float in an excel wksh when a person scrolls. Kelly	by Gord Dibben	5	5,066
Remove/Ignore Letters when Summing cells in a column. Matt	by Teethless mama	3	5,061
Chain IF formula help Dave	by Dave	4	5,058
Find & Replace - Limit search to a specific column falena23	by Spiky	3	5,057
Remove Negative Signs from Formula Results Holly	by T. Valko	4	5,053
How do i apply Goal Seek to a range of cells in Excel Mabvuto	by ryguy7272	1	5,047
Excluding Zero's from Average (SumIF / CountIF) Alex	by Alex	5	5,038
conditional formatting highlight dates 90 days or less michelle	by Shane Devenshire[_2_]	7	5,037
Man hours calculation Mama Mia	by [email protected]	7	5,036
Simplify formula Luke	by Harlan Grove	37	5,034
How do I convert dd/mm/yy date format to yyddd Julian date format itzy bitzy[_2_]	by Rick Rothstein	8	5,033
Delete a toggle button overlaying data Gigacrete	by Dave Peterson	1	5,031
Return the current Yearly Quarter based on date hozman	by T. Valko	2	5,029
Between Symbol chard9401	by Frank Kabel	2	5,024
Is it possible to link a whole table into another worksheet Linda	by Gord Dibben	8	5,023
Sometimes I can't see or edit comments in xcel cells. Why? Ian	by ShaneDevenshire	1	5,023
formula to calculate time difference crossing midnight ditorejax	by Sloth	3	5,018