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	896
Date question Ziggy	by T. Valko	3	568
Linking to other worksheets Cav	by Ashish Mathur[_2_]	3	527
What happened to setting up a constant using F4? Stan	by Ziggy	2	744
multi-worksheet sum trip_to_tokyo[_3_]	by ªá¥Ò¯Î[_2_]	1	444
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	912
Store formulas in Vlookups? (another try ;) patbarb	by patbarb	6	591
updating cell range depending on input value handicapper	by handicapper	3	941
annuity calculation for monthly payments but quarterly compoundin JayM	by Joe User[_2_]	5	2,314
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	549
Add text automatically by recognized value Peter Gonzalez[_2_]	by Per Jessen[_2_]	4	545
counting groups of words Seller Smith	by Ron Rosenfeld	4	500
Converting PDF or HTML to Excel JPalmer	by Don Guillett[_2_]	2	534
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,296
If & Vlookup statement Sarah	by Mitch	3	613
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	446
concatenate rpmani	by Dave Peterson	2	495
Using text and formatting sum function in formula Billy B	by David Biddulph[_2_]	3	1,398
Finding the lowest cost for a product from a list tt	by Squeaky	2	788
formatted cells medina	by medina	0	1,153
Dynamic Filtering...Need Help cmeyer	by cmeyer	0	1,181
Can you sum the amount of type a word appears? Scott_goddard	by getting old[_2_]	2	503
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,194
Interval between now and next birthday WilDeliver	by Chip Pearson	3	689
Average numbers in noncontiguous columns ignoring 0's. bean counter	by Steve Dunn	2	846
comparing data in excel Eightball	by Steve Dunn	3	509
Sumproduct with a twist Pam[_3_]	by Steve Dunn	4	385
Sum of retuned valus as digits Vinay Vasu	by Mike H	1	434
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	575
Logical function please Amin	by Amin	3	468
Pulling a cell reference--clickable cells? Bermie	by Steve Dunn	1	652
creating a report from a table, pivot table not suitable UKMAN	by Steve Dunn	1	498
Function similar to "LEFT" Karen D	by Jacob Skaria	2	602
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,100
Conditional Formatting Date Range BWR_Rick	by T. Valko	1	1,229
VLOOKUP returning formula Jan Ogg	by T. Valko	3	1,234
copy/paste malfunction Innovator	by Innovator	0	434
VLOOKUP & IF Sarah	by T. Valko	9	777
spreadsheet Ben Rivera	by CLR	1	395
Need function to return numbers at beginning of text Nadine	by T. Valko	2	550
Can excel data be encrypted? Confused	by Joe User[_2_]	1	456
Standard deviation and bell curve Meebers[_4_]	by Meebers[_4_]	0	751
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	584
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine	by Duke Carey	1	4,768
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	435
Rounding Up question spreadsheetlady	by Mike H	2	469
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,282
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,719
Convert percentage into margin Linda	by Bernard Liengme[_2_]	2	1,561
how do I import data in excel form SQL server? Mitch	by Duke Carey	7	1,353
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	655
multiple dependent drop down lists Mikej	by Mikej	6	3,602
Adding a value to a customer ID? Anne	by Bernard Liengme[_2_]	4	665
Sumif with multiple sum ranges in a sheet MA	by Teethless mama	4	5,444
Can I combine a Vlookup with an IF formula? Claire[_2_]	by Duke Carey	2	682
Filldown starting from F2 instead of F1 Ephraim	by Ephraim	5	560