Excel Worksheet Functions - Page 60

Thread / Thread Starter	Last Post	Replies	Views
"Cumulative" column based on a pivot table sum column? Robert Day	by Robert Day	2	2,231
How to print from consecutive numbers in excel w/o typing all? Need help in Excel	by Bernard Liengme	1	2,230
Histogram in reverse order Brandon Schmidt	by Brandon Schmidt[_2_]	1	2,230
Rows to repeat at top of each page Jane	by Gord Dibben	4	2,229
Conditional formatting comparing two columns Shelina	by Jacob Skaria	6	2,229
Excel lookups should have a return paramater if not found LJ	by Luke M	3	2,229
Count Unique Text Values Scott Halper	by Domenic	18	2,229
can you insert a comment into a protected worksheet? TKGerdie	by TKGerdie	3	2,228
Adding VLOOKUPS across multiple worksheets NCarter	by DKS	3	2,227
Invalid Cell Reference error Ravi	by Spiky	3	2,227
Does excel recognise names rather than cells? Sue	by Sue	9	2,227
Can VLookup function find and list multiple records? Rich - SG	by Biff	11	2,227
How do I chg the text size in my validation drop down box? tmeloff	by Colin	11	2,226
How do I create a print button? Dan	by Don Guillett	3	2,225
MODE - Second most frequent value Sam via OfficeKB.com	by Sam via OfficeKB.com	2	2,225
Compare multiple column of data and list out common and unique component in adj columns kuansheng	by Max	15	2,225
Price Comparison formula TJC	by JBoulton	5	2,224
Amortisation with a lump sum principal payment during term Network Capital	by jasonc	2	2,224
comparing and isolating duplicates in two columns monkeytrader	by T. Valko	2	2,223
Running Total, Opening & Closing Acct Balance in Cash Book rushdhih	by Fred Smith[_4_]	1	2,223
Save As csv Carraige Return issue WaterBug	by Tom Hutchins	3	2,223
Pulling Data that falls within a specific date range? mobius9oo	by Sheeloo	3	2,222
Double CountIF LiAD	by Bernie Deitrick	5	2,222
Converting a number to hours and minutes dslocum[_7_]	by dslocum[_8_]	4	2,222
My "F2" function has been turned off, how do I turn it on? Sometimes I need assistance...	by Gord Dibben	5	2,221
pmt() uses 360-Days Bases, I need 365-Days Bases Mujeeb ur Rehman, FBL-GRW-PK	by JE McGimpsey	1	2,221
number of week days in a period of time Erol	by T. Valko	5	2,221
COUNTIF a value within a range equals any value in an array/list sweens319	by T. Valko	14	2,220
Multiple formats in a single cell with multiple formulas Zakhary	by Bernie Deitrick	1	2,220
Columns labeled with numbers not letters plumeria54	by John	9	2,220
Excel 2003: Count total days elapsed watermt	by Ron Rosenfeld	12	2,219
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,219
my excel formulas are too long to execute find and replace jmh33	by Ron Coderre	1	2,219
Reduced Row Echelon form bigf*	by Fredrik Wahlgren	1	2,219
Match with tilda characater IanW	by Biff	6	2,218
formula to return value from a matrix - I know hor and vert values UKMAN	by Don Guillett[_2_]	14	2,218
Cell reference with variable column mjones	by mjones	4	2,218
Send active workbook as attachment via hyperlink Keith Thompson	by Claus Busch	4	2,218
LOOKUP multiple results but ignore duplicates. vane0326	by Biff	10	2,218
Need Formula to display pivot table source data Don S	by Debra Dalgleish	3	2,217
Two functions in one cell??? Skip	by Harlan Grove	4	2,217
Conditional Formatting based on cell text Saucer Man	by Saucer Man	3	2,217
go to last filled cell in a column shortcut inthestands	by Gord Dibben	2	2,217
How do I use countif across non-adjacent cells? Nick	by Harlan Grove	2	2,216
External Links in Excel 2007 with variable source file PaHead	by JGT	5	2,216
#N/A In Max min Average Formula P Beardshall	by Peo Sjoblom	2	2,216
How do I calculate 30 days later from a date SYH	by Biff	1	2,216
Find a Function to use accross different worksheets R. Hale	by Frank Kabel	3	2,215
Month (datedif) to 1 decimal jennifer	by jennifer	3	2,215
Add days to a date, but exclude holidays Chickadee	by Chickadee	13	2,215
if one cell has "X" textin contents, then pull cell "Y"... azazel	by swatsp0p	3	2,214
dates and 1st Tuesday of month Jessica[_2_]	by T. Valko	11	2,214
number cell increment +1 when dragging down box Johnny Cake	by Johnny Cake	4	2,213
How do I filter data by more than one column in excel teeniebop	by Don Guillett[_2_]	1	2,213
Variable Table Array in Lookup Function matt_the_brum	by matt_the_brum	6	2,213
Compare sheet 1 column A numbers with sheet 2 column A number Not and Excel Expert	by Synkronizer Excel Tool	3	2,213
Coefficient of Repeatability thewildleo	by thewildleo	0	2,212
Vlookup of specific text, then in consecutive rows Steve	by zvkmpw	9	2,212
Sum of visible cells only Stgeorge	by jaysin	11	2,212
Formatting cells Auto fill color using €œIf€ Masatami	by Gord Dibben	4	2,211
How do I make a cell in Excel default to the negative value? TVB Credit Manager	by Gord Dibben	1	2,210
Is there a function that will evaluate a text string in a cell? Dave	by Ashish Mathur[_2_]	2	2,210
Formatting color and font to a logical statement result? STRAC	by STRAC	7	2,210
Return text in Column A if Column B and Column K match jeannie v	by T. Valko	4	2,210
Symbols in Data Validation List marie	by marie	2	2,210
How to control worksheet initialization upon opening a workbook Nick	by Bob Phillips	3	2,210
Excel: Round formula up in $5. increments =+(M4*1.1)+M4 Wanda M	by CLR	5	2,209
Conditional Accounts receivable Aging Analysis rushdhih	by rushdhih	0	2,209
Average Range Stndt	by Stndt	0	2,209
how do I drag and fill hyperlinks? coreygreat	by Don Guillett[_2_]	3	2,209
Excel Convert Multiple Rows into Multiple Columns [email protected]	by Peo Sjoblom	1	2,209
vba to sort group copy paste to another sheet mango	by mango	0	2,209
Select and move two NON-ADJACENT Excel cells simultaneously ? Vulture	by Otto Moehrbach[_2_]	4	2,208
Advanced Filter used with merged cells? davisk	by JBeaucaire[_64_]	3	2,208
Lookup values in a list and return multiple rows of data Amanda L	by Alan Beban	2	2,208