Excel Worksheet Functions - Page 56

Thread / Thread Starter	Last Post	Replies	Views
Complex functions JP Ronse	by Bernard Liengme[_2_]	1	579
Vlookup and Data Validation Q Seanie	by Sheeloo	2	920
Date question Ziggy	by T. Valko	3	593
Linking to other worksheets Cav	by Ashish Mathur[_2_]	3	546
What happened to setting up a constant using F4? Stan	by Ziggy	2	765
multi-worksheet sum trip_to_tokyo[_3_]	by ªá¥Ò¯Î[_2_]	1	458
Sorting Father John	by JLatham	1	324
m4=b4 only if Derek	by Joe User[_2_]	2	542
Linking Totals Across Multiple Worksheets snowboardbaltimore	by snowboardbaltimore	3	939
Store formulas in Vlookups? (another try ;) patbarb	by patbarb	6	614
updating cell range depending on input value handicapper	by handicapper	3	968
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,760
Maybe too hard to do? LSSTOC Black Belt	by LSSTOC BB	2	512
Use Vlookup to store formulas? patbarb	by patbarb	6	565
Add text automatically by recognized value Peter Gonzalez[_2_]	by Per Jessen[_2_]	4	585
counting groups of words Seller Smith	by Ron Rosenfeld	4	520
Converting PDF or HTML to Excel JPalmer	by Don Guillett[_2_]	2	556
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,319
If & Vlookup statement Sarah	by Mitch	3	646
networkdays issue AJ	by AJ	8	530
How can I add the values based the color of font and the date Peter Gonzalez[_2_]	by Bernard Liengme[_2_]	1	741
Identify the windows just below the menu Luismo	by Dave Peterson	2	463
concatenate rpmani	by Dave Peterson	2	513
Using text and formatting sum function in formula Billy B	by David Biddulph[_2_]	3	1,436
Finding the lowest cost for a product from a list tt	by Squeaky	2	815
formatted cells medina	by medina	0	1,260
Dynamic Filtering...Need Help cmeyer	by cmeyer	0	1,197
Can you sum the amount of type a word appears? Scott_goddard	by getting old[_2_]	2	520
Formula josvill2010	by getting old[_2_]	1	451
Finding NEXT to last, non zero numeric value in a row gergster	by Steve Dunn	3	2,217
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	857
comparing data in excel Eightball	by Steve Dunn	3	530
Sumproduct with a twist Pam[_3_]	by Steve Dunn	4	394
Sum of retuned valus as digits Vinay Vasu	by Mike H	1	450
search a row for a word and if found Vibeke	by Jarek Kujawa[_2_]	2	4,626
Concentration Analysis Phillip Olan'g	by Jarek Kujawa[_2_]	3	586
Logical function please Amin	by Amin	3	489
Pulling a cell reference--clickable cells? Bermie	by Steve Dunn	1	720
creating a report from a table, pivot table not suitable UKMAN	by Steve Dunn	1	512
Function similar to "LEFT" Karen D	by Jacob Skaria	2	622
copy formula Jafferi[_2_]	by Jacob Skaria	3	389
CONCATENATE Tservo	by Ashish Mathur[_2_]	3	480
SUM Talladega	by Ashish Mathur[_2_]	2	351
Pivot table show all days of a month even if no data Elan lent	by Herbert Seidenberg	2	3,127
Conditional Formatting Date Range BWR_Rick	by T. Valko	1	1,248
VLOOKUP returning formula Jan Ogg	by T. Valko	3	1,256
copy/paste malfunction Innovator	by Innovator	0	448
VLOOKUP & IF Sarah	by T. Valko	9	788
spreadsheet Ben Rivera	by CLR	1	406
Need function to return numbers at beginning of text Nadine	by T. Valko	2	564
Can excel data be encrypted? Confused	by Joe User[_2_]	1	472
Standard deviation and bell curve Meebers[_4_]	by Meebers[_4_]	0	760
rounded # to correct # Wagnerk	by David Biddulph[_2_]	4	464
Add values based on text color with the criteria of a date Peter Gonzalez[_2_]	by Peter Gonzalez[_2_]	7	678
Add no. of days to a workday to get new workday? blswes	by Duke Carey	1	607
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine	by Duke Carey	1	4,814
Sort Brandon	by Tom Hutchins	2	587
#N/A help please cadustin	by Duke Carey	2	564
Help with If Sum statement - i think.... Scott_goddard	by Duke Carey	4	452
Rounding Up question spreadsheetlady	by Mike H	2	479
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,331
Ad-In Rowliner Eurika Stemmet	by Gord Dibben	4	1,313
Excel IF Formulas mgreen-NJ	by mgreen-NJ[_2_]	2	435
Show time as a negative figure JCR1987	by Hans Terkelsen	3	1,739
Convert percentage into margin Linda	by Bernard Liengme[_2_]	2	1,646
how do I import data in excel form SQL server? Mitch	by Duke Carey	7	1,375
Countif/SumProduct excelllllllll	by excelllllllll	4	351
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,628
Adding a value to a customer ID? Anne	by Bernard Liengme[_2_]	4	679
Sumif with multiple sum ranges in a sheet MA	by Teethless mama	4	5,473
Can I combine a Vlookup with an IF formula? Claire[_2_]	by Duke Carey	2	698
Filldown starting from F2 instead of F1 Ephraim	by Ephraim	5	613