Excel Worksheet Functions - Page 56

Thread / Thread Starter	Last Post	Replies	Views
Complex functions JP Ronse	by Bernard Liengme[_2_]	1	558
Vlookup and Data Validation Q Seanie	by Sheeloo	2	897
Date question Ziggy	by T. Valko	3	568
Linking to other worksheets Cav	by Ashish Mathur[_2_]	3	528
What happened to setting up a constant using F4? Stan	by Ziggy	2	745
multi-worksheet sum trip_to_tokyo[_3_]	by ªá¥Ò¯Î[_2_]	1	445
Sorting Father John	by JLatham	1	313
m4=b4 only if Derek	by Joe User[_2_]	2	521
Linking Totals Across Multiple Worksheets snowboardbaltimore	by snowboardbaltimore	3	913
Store formulas in Vlookups? (another try ;) patbarb	by patbarb	6	592
updating cell range depending on input value handicapper	by handicapper	3	942
annuity calculation for monthly payments but quarterly compoundin JayM	by Joe User[_2_]	5	2,315
If function help Pam	by Joe User[_2_]	6	1,707
Maybe too hard to do? LSSTOC Black Belt	by LSSTOC BB	2	497
Use Vlookup to store formulas? patbarb	by patbarb	6	550
Add text automatically by recognized value Peter Gonzalez[_2_]	by Per Jessen[_2_]	4	546
counting groups of words Seller Smith	by Ron Rosenfeld	4	501
Converting PDF or HTML to Excel JPalmer	by Don Guillett[_2_]	2	535
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,297
If & Vlookup statement Sarah	by Mitch	3	614
networkdays issue AJ	by AJ	8	516
How can I add the values based the color of font and the date Peter Gonzalez[_2_]	by Bernard Liengme[_2_]	1	722
Identify the windows just below the menu Luismo	by Dave Peterson	2	447
concatenate rpmani	by Dave Peterson	2	495
Using text and formatting sum function in formula Billy B	by David Biddulph[_2_]	3	1,399
Finding the lowest cost for a product from a list tt	by Squeaky	2	789
formatted cells medina	by medina	0	1,154
Dynamic Filtering...Need Help cmeyer	by cmeyer	0	1,182
Can you sum the amount of type a word appears? Scott_goddard	by getting old[_2_]	2	504
Formula josvill2010	by getting old[_2_]	1	439
Finding NEXT to last, non zero numeric value in a row gergster	by Steve Dunn	3	2,195
Interval between now and next birthday WilDeliver	by Chip Pearson	3	690
Average numbers in noncontiguous columns ignoring 0's. bean counter	by Steve Dunn	2	847
comparing data in excel Eightball	by Steve Dunn	3	510
Sumproduct with a twist Pam[_3_]	by Steve Dunn	4	385
Sum of retuned valus as digits Vinay Vasu	by Mike H	1	435
search a row for a word and if found Vibeke	by Jarek Kujawa[_2_]	2	4,598
Concentration Analysis Phillip Olan'g	by Jarek Kujawa[_2_]	3	576
Logical function please Amin	by Amin	3	469
Pulling a cell reference--clickable cells? Bermie	by Steve Dunn	1	653
creating a report from a table, pivot table not suitable UKMAN	by Steve Dunn	1	499
Function similar to "LEFT" Karen D	by Jacob Skaria	2	603
copy formula Jafferi[_2_]	by Jacob Skaria	3	379
CONCATENATE Tservo	by Ashish Mathur[_2_]	3	463
SUM Talladega	by Ashish Mathur[_2_]	2	337
Pivot table show all days of a month even if no data Elan lent	by Herbert Seidenberg	2	3,101
Conditional Formatting Date Range BWR_Rick	by T. Valko	1	1,230
VLOOKUP returning formula Jan Ogg	by T. Valko	3	1,235
copy/paste malfunction Innovator	by Innovator	0	435
VLOOKUP & IF Sarah	by T. Valko	9	778
spreadsheet Ben Rivera	by CLR	1	395
Need function to return numbers at beginning of text Nadine	by T. Valko	2	551
Can excel data be encrypted? Confused	by Joe User[_2_]	1	457
Standard deviation and bell curve Meebers[_4_]	by Meebers[_4_]	0	752
rounded # to correct # Wagnerk	by David Biddulph[_2_]	4	450
Add values based on text color with the criteria of a date Peter Gonzalez[_2_]	by Peter Gonzalez[_2_]	7	652
Add no. of days to a workday to get new workday? blswes	by Duke Carey	1	585
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine	by Duke Carey	1	4,769
Sort Brandon	by Tom Hutchins	2	576
#N/A help please cadustin	by Duke Carey	2	549
Help with If Sum statement - i think.... Scott_goddard	by Duke Carey	4	436
Rounding Up question spreadsheetlady	by Mike H	2	470
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,283
Ad-In Rowliner Eurika Stemmet	by Gord Dibben	4	1,305
Excel IF Formulas mgreen-NJ	by mgreen-NJ[_2_]	2	422
Show time as a negative figure JCR1987	by Hans Terkelsen	3	1,720
Convert percentage into margin Linda	by Bernard Liengme[_2_]	2	1,562
how do I import data in excel form SQL server? Mitch	by Duke Carey	7	1,354
Countif/SumProduct excelllllllll	by excelllllllll	4	339
Directing cell contents to one of two cells dependent on its value Debi	by Gary''s Student	1	656
multiple dependent drop down lists Mikej	by Mikej	6	3,604
Adding a value to a customer ID? Anne	by Bernard Liengme[_2_]	4	667
Sumif with multiple sum ranges in a sheet MA	by Teethless mama	4	5,445
Can I combine a Vlookup with an IF formula? Claire[_2_]	by Duke Carey	2	683
Filldown starting from F2 instead of F1 Ephraim	by Ephraim	5	561