Excel Worksheet Functions - Page 56

Thread / Thread Starter	Last Post	Replies	Views
Complex functions JP Ronse	by Bernard Liengme[_2_]	1	589
Vlookup and Data Validation Q Seanie	by Sheeloo	2	925
Date question Ziggy	by T. Valko	3	596
Linking to other worksheets Cav	by Ashish Mathur[_2_]	3	546
What happened to setting up a constant using F4? Stan	by Ziggy	2	766
multi-worksheet sum trip_to_tokyo[_3_]	by ªá¥Ò¯Î[_2_]	1	462
Sorting Father John	by JLatham	1	329
m4=b4 only if Derek	by Joe User[_2_]	2	544
Linking Totals Across Multiple Worksheets snowboardbaltimore	by snowboardbaltimore	3	939
Store formulas in Vlookups? (another try ;) patbarb	by patbarb	6	615
updating cell range depending on input value handicapper	by handicapper	3	977
annuity calculation for monthly payments but quarterly compoundin JayM	by Joe User[_2_]	5	2,344
If function help Pam	by Joe User[_2_]	6	1,774
Maybe too hard to do? LSSTOC Black Belt	by LSSTOC BB	2	515
Use Vlookup to store formulas? patbarb	by patbarb	6	578
Add text automatically by recognized value Peter Gonzalez[_2_]	by Per Jessen[_2_]	4	596
counting groups of words Seller Smith	by Ron Rosenfeld	4	523
Converting PDF or HTML to Excel JPalmer	by Don Guillett[_2_]	2	557
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,325
If & Vlookup statement Sarah	by Mitch	3	649
networkdays issue AJ	by AJ	8	532
How can I add the values based the color of font and the date Peter Gonzalez[_2_]	by Bernard Liengme[_2_]	1	747
Identify the windows just below the menu Luismo	by Dave Peterson	2	464
concatenate rpmani	by Dave Peterson	2	525
Using text and formatting sum function in formula Billy B	by David Biddulph[_2_]	3	1,438
Finding the lowest cost for a product from a list tt	by Squeaky	2	816
formatted cells medina	by medina	0	1,264
Dynamic Filtering...Need Help cmeyer	by cmeyer	0	1,199
Can you sum the amount of type a word appears? Scott_goddard	by getting old[_2_]	2	521
Formula josvill2010	by getting old[_2_]	1	455
Finding NEXT to last, non zero numeric value in a row gergster	by Steve Dunn	3	2,228
Interval between now and next birthday WilDeliver	by Chip Pearson	3	711
Average numbers in noncontiguous columns ignoring 0's. bean counter	by Steve Dunn	2	869
comparing data in excel Eightball	by Steve Dunn	3	538
Sumproduct with a twist Pam[_3_]	by Steve Dunn	4	398
Sum of retuned valus as digits Vinay Vasu	by Mike H	1	458
search a row for a word and if found Vibeke	by Jarek Kujawa[_2_]	2	4,635
Concentration Analysis Phillip Olan'g	by Jarek Kujawa[_2_]	3	586
Logical function please Amin	by Amin	3	493
Pulling a cell reference--clickable cells? Bermie	by Steve Dunn	1	732
creating a report from a table, pivot table not suitable UKMAN	by Steve Dunn	1	522
Function similar to "LEFT" Karen D	by Jacob Skaria	2	625
copy formula Jafferi[_2_]	by Jacob Skaria	3	390
CONCATENATE Tservo	by Ashish Mathur[_2_]	3	483
SUM Talladega	by Ashish Mathur[_2_]	2	360
Pivot table show all days of a month even if no data Elan lent	by Herbert Seidenberg	2	3,130
Conditional Formatting Date Range BWR_Rick	by T. Valko	1	1,252
VLOOKUP returning formula Jan Ogg	by T. Valko	3	1,259
copy/paste malfunction Innovator	by Innovator	0	449
VLOOKUP & IF Sarah	by T. Valko	9	789
spreadsheet Ben Rivera	by CLR	1	408
Need function to return numbers at beginning of text Nadine	by T. Valko	2	567
Can excel data be encrypted? Confused	by Joe User[_2_]	1	474
Standard deviation and bell curve Meebers[_4_]	by Meebers[_4_]	0	761
rounded # to correct # Wagnerk	by David Biddulph[_2_]	4	466
Add values based on text color with the criteria of a date Peter Gonzalez[_2_]	by Peter Gonzalez[_2_]	7	680
Add no. of days to a workday to get new workday? blswes	by Duke Carey	1	612
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine	by Duke Carey	1	4,823
Sort Brandon	by Tom Hutchins	2	597
#N/A help please cadustin	by Duke Carey	2	568
Help with If Sum statement - i think.... Scott_goddard	by Duke Carey	4	464
Rounding Up question spreadsheetlady	by Mike H	2	482
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,332
Ad-In Rowliner Eurika Stemmet	by Gord Dibben	4	1,316
Excel IF Formulas mgreen-NJ	by mgreen-NJ[_2_]	2	436
Show time as a negative figure JCR1987	by Hans Terkelsen	3	1,739
Convert percentage into margin Linda	by Bernard Liengme[_2_]	2	1,647
how do I import data in excel form SQL server? Mitch	by Duke Carey	7	1,383
Countif/SumProduct excelllllllll	by excelllllllll	4	352
Directing cell contents to one of two cells dependent on its value Debi	by Gary''s Student	1	677
multiple dependent drop down lists Mikej	by Mikej	6	3,636
Adding a value to a customer ID? Anne	by Bernard Liengme[_2_]	4	690
Sumif with multiple sum ranges in a sheet MA	by Teethless mama	4	5,474
Can I combine a Vlookup with an IF formula? Claire[_2_]	by Duke Carey	2	705
Filldown starting from F2 instead of F1 Ephraim	by Ephraim	5	614