Excel Worksheet Functions - Page 120

Thread / Thread Starter	Last Post	Replies	Views
IF to group months John McDonnell	by Ashish Mathur[_2_]	3	418
FAO Mike Caroline	by Glenn	10	925
? enter a static time (Excel) in a cell using the IF function Dave Peterson	by Dave Peterson	0	728
help formula (ranking) Eddy Stan	by JLatham	1	418
More columne sorting BEOPS	by David Biddulph[_2_]	5	366
Look up last and next entry Huggy	by Huggy	5	326
sumif using "AND" and "Date" Excel_Kiwi[_2_]	by Jacob Skaria	2	386
Formula have a VLOOKUP but want it to =0 if no value is found Nicole	by T. Valko	3	1,966
Formula for payout & interest Atreyu	by JoeU2004	3	1,220
User Defined Function and VLookUP Kevin	by Kevin	11	1,156
Match value return a text ppp	by Jacob Skaria	6	571
Allocate Value Across Monthly Periods AlanR[_2_]	by Jacob Skaria	1	3,034
Match Column and copy to cell Column D Jeffrey Yau	by Ashish Mathur[_2_]	1	646
Include calculations in the lookup function JP Ronse	by Lars-Åke Aspelin[_2_]	8	460
nper cdh625	by Ron Rosenfeld	1	518
custom created table styles TinaW	by Gord Dibben	6	1,166
Workday function returns the wrong date when the duration is 5 day KarenMA	by Ron Rosenfeld	5	1,182
Split list query for Vlookups CellShocked	by BSc Chem Eng Rick	1	441
help with data match ppp	by ppp	0	480
WildCards in Sumif Function Hardeep Kanwar	by Bob Phillips[_3_]	2	613
display number if date is in a range lmarty	by David Biddulph[_2_]	5	424
Help with formula (decimal to fraction) Jack Deuce	by David Biddulph[_2_]	2	2,178
Local Apparent Time (LAT) - real / actual solar time ? Kelvin	by David Biddulph[_2_]	2	3,836
Counting Unique occurences of text in a column Bernd P	by Bernd P	0	480
Numbering years and months Colin Hayes	by Colin Hayes	5	509
Colors too dark! BiT212	by JLatham	1	1,083
External data connections CellShocked	by CellShocked	2	905
SUMIFs function lefty	by Gord Dibben	2	671
Using wildcard * in MATCH berniean	by Max	6	1,051
how do i use IF to substitute for another cell? Tim	by Gord Dibben	1	369
using sort in excel 2003 naj	by Gord Dibben	2	441
Copying formulas from one cell to another Woodie6	by Gord Dibben	7	642
SUMIFS function lefty	by Teethless mama	4	562
I have a column of 50 numbers Skip[_2_]	by Pete_UK	5	340
Do while not last row littleredhairedgirl	by Mike H	2	605
BeforeRightClick gk	by gk	4	523
Create Sheet & Copy Stuff littleredhairedgirl	by littleredhairedgirl	0	404
Text Item Processor littleredhairedgirl	by littleredhairedgirl	1	418
formula in excel Laundone	by Jacob Skaria	2	329
Weighted grades Otyokwa	by T. Valko	2	499
What formula would I use? Redland	by Redland	2	392
Simpler way to pull a cell value from a group based on 2 factors? ker_01	by smartin	1	326
Table Lookup JeffK	by JeffK	3	331
to link information between two lists Bklynhyc	by Ashish Mathur[_2_]	16	1,092
Macro to copy data when data is detected in another column(s). Richard	by Gord Dibben	2	593
Is there a Dolph-Chebychev function in Excel? richrdsn70	by richrdsn70	0	449
Vlookup JeffK	by JeffK	5	451
scrolling columns behind previous columns gfw	by Gord Dibben	4	888
Sumproduct Help Curtis	by Curtis	3	489
Vlookup PAL	by Tom Hutchins	2	312
Difference between these two formulas? ker_01	by ker_01	5	490
Pivot Table using data from multiple sheets nabanco	by ryguy7272	1	971
Project a date and calculate a % in one formula bert_lady	by Sean Timmons	4	399
Changing zoom level automatically Xt	by Xt	2	3,618
Formatting a radio button Iriemon	by Dave Peterson	4	1,666
Formula Help Newfie809	by Pete_UK	5	514
Copying Formulas Kris	by John[_22_]	4	394
Problem with Functions and Formulas Kris	by Jacob Skaria	11	1,006
Sumif with multiple sets of duplicates Lou Nunez	by Tom Hutchins	4	1,401
#value! error in sum function Art	by T. Valko	9	641
Limit access in a pivot table Ken	by Tom Hutchins	2	684
adding actual numbers in columns geb	by T. Valko	3	506
Calc occurrances for weekday omitting weekend data dtoney	by Bernard Liengme[_3_]	4	765
IF statements with multiple criteria LWilson	by LWilson	2	1,612
Function to Filter Unique Records Tevuna	by MPI Planner[_2_]	6	779
convert currency to word Soumya Samanthan	by Bob Phillips[_3_]	2	467
Validation List Steve HKG[_2_]	by Steve HKG[_2_]	0	358
Mid function Maria[_4_]	by Bob Phillips[_3_]	2	347
removing blanks from range (mr Pearson) Atishoo	by Atishoo	1	322
Help with formula Jack Deuce	by Bob Phillips[_3_]	3	602
Rearranging a report Rick	by Pete_UK	7	372
Combining text from several cells into 1 cell Rick	by Rick	4	1,796
Vlookups (sum of) Caroline	by Caroline	7	516
Transpose data and retain links to original data Neil	by David Biddulph[_2_]	2	616
Counting Closed Date < 2 weeks of Open Date etc gcw	by gcw	0	593