Excel Worksheet Functions - Page 56

Thread / Thread Starter	Last Post	Replies	Views
Complex functions JP Ronse	by Bernard Liengme[_2_]	1	573
Vlookup and Data Validation Q Seanie	by Sheeloo	2	912
Date question Ziggy	by T. Valko	3	579
Linking to other worksheets Cav	by Ashish Mathur[_2_]	3	537
What happened to setting up a constant using F4? Stan	by Ziggy	2	757
multi-worksheet sum trip_to_tokyo[_3_]	by ªá¥Ò¯Î[_2_]	1	453
Sorting Father John	by JLatham	1	319
m4=b4 only if Derek	by Joe User[_2_]	2	534
Linking Totals Across Multiple Worksheets snowboardbaltimore	by snowboardbaltimore	3	934
Store formulas in Vlookups? (another try ;) patbarb	by patbarb	6	604
updating cell range depending on input value handicapper	by handicapper	3	963
annuity calculation for monthly payments but quarterly compoundin JayM	by Joe User[_2_]	5	2,334
If function help Pam	by Joe User[_2_]	6	1,751
Maybe too hard to do? LSSTOC Black Belt	by LSSTOC BB	2	504
Use Vlookup to store formulas? patbarb	by patbarb	6	559
Add text automatically by recognized value Peter Gonzalez[_2_]	by Per Jessen[_2_]	4	577
counting groups of words Seller Smith	by Ron Rosenfeld	4	515
Converting PDF or HTML to Excel JPalmer	by Don Guillett[_2_]	2	547
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,314
If & Vlookup statement Sarah	by Mitch	3	636
networkdays issue AJ	by AJ	8	526
How can I add the values based the color of font and the date Peter Gonzalez[_2_]	by Bernard Liengme[_2_]	1	733
Identify the windows just below the menu Luismo	by Dave Peterson	2	458
concatenate rpmani	by Dave Peterson	2	506
Using text and formatting sum function in formula Billy B	by David Biddulph[_2_]	3	1,421
Finding the lowest cost for a product from a list tt	by Squeaky	2	805
formatted cells medina	by medina	0	1,171
Dynamic Filtering...Need Help cmeyer	by cmeyer	0	1,190
Can you sum the amount of type a word appears? Scott_goddard	by getting old[_2_]	2	514
Formula josvill2010	by getting old[_2_]	1	447
Finding NEXT to last, non zero numeric value in a row gergster	by Steve Dunn	3	2,214
Interval between now and next birthday WilDeliver	by Chip Pearson	3	707
Average numbers in noncontiguous columns ignoring 0's. bean counter	by Steve Dunn	2	854
comparing data in excel Eightball	by Steve Dunn	3	524
Sumproduct with a twist Pam[_3_]	by Steve Dunn	4	390
Sum of retuned valus as digits Vinay Vasu	by Mike H	1	448
search a row for a word and if found Vibeke	by Jarek Kujawa[_2_]	2	4,623
Concentration Analysis Phillip Olan'g	by Jarek Kujawa[_2_]	3	582
Logical function please Amin	by Amin	3	482
Pulling a cell reference--clickable cells? Bermie	by Steve Dunn	1	714
creating a report from a table, pivot table not suitable UKMAN	by Steve Dunn	1	507
Function similar to "LEFT" Karen D	by Jacob Skaria	2	615
copy formula Jafferi[_2_]	by Jacob Skaria	3	384
CONCATENATE Tservo	by Ashish Mathur[_2_]	3	473
SUM Talladega	by Ashish Mathur[_2_]	2	346
Pivot table show all days of a month even if no data Elan lent	by Herbert Seidenberg	2	3,120
Conditional Formatting Date Range BWR_Rick	by T. Valko	1	1,240
VLOOKUP returning formula Jan Ogg	by T. Valko	3	1,250
copy/paste malfunction Innovator	by Innovator	0	445
VLOOKUP & IF Sarah	by T. Valko	9	783
spreadsheet Ben Rivera	by CLR	1	402
Need function to return numbers at beginning of text Nadine	by T. Valko	2	559
Can excel data be encrypted? Confused	by Joe User[_2_]	1	465
Standard deviation and bell curve Meebers[_4_]	by Meebers[_4_]	0	755
rounded # to correct # Wagnerk	by David Biddulph[_2_]	4	460
Add values based on text color with the criteria of a date Peter Gonzalez[_2_]	by Peter Gonzalez[_2_]	7	671
Add no. of days to a workday to get new workday? blswes	by Duke Carey	1	600
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine	by Duke Carey	1	4,783
Sort Brandon	by Tom Hutchins	2	584
#N/A help please cadustin	by Duke Carey	2	559
Help with If Sum statement - i think.... Scott_goddard	by Duke Carey	4	449
Rounding Up question spreadsheetlady	by Mike H	2	473
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,321
Ad-In Rowliner Eurika Stemmet	by Gord Dibben	4	1,309
Excel IF Formulas mgreen-NJ	by mgreen-NJ[_2_]	2	427
Show time as a negative figure JCR1987	by Hans Terkelsen	3	1,734
Convert percentage into margin Linda	by Bernard Liengme[_2_]	2	1,589
how do I import data in excel form SQL server? Mitch	by Duke Carey	7	1,365
Countif/SumProduct excelllllllll	by excelllllllll	4	344
Directing cell contents to one of two cells dependent on its value Debi	by Gary''s Student	1	671
multiple dependent drop down lists Mikej	by Mikej	6	3,618
Adding a value to a customer ID? Anne	by Bernard Liengme[_2_]	4	677
Sumif with multiple sum ranges in a sheet MA	by Teethless mama	4	5,463
Can I combine a Vlookup with an IF formula? Claire[_2_]	by Duke Carey	2	692
Filldown starting from F2 instead of F1 Ephraim	by Ephraim	5	608