Excel Worksheet Functions - Page 120

Thread / Thread Starter	Last Post	Replies	Views
IF to group months John McDonnell	by Ashish Mathur[_2_]	3	408
FAO Mike Caroline	by Glenn	10	913
? enter a static time (Excel) in a cell using the IF function Dave Peterson	by Dave Peterson	0	721
help formula (ranking) Eddy Stan	by JLatham	1	411
More columne sorting BEOPS	by David Biddulph[_2_]	5	360
Look up last and next entry Huggy	by Huggy	5	320
sumif using "AND" and "Date" Excel_Kiwi[_2_]	by Jacob Skaria	2	372
Formula have a VLOOKUP but want it to =0 if no value is found Nicole	by T. Valko	3	1,895
Formula for payout & interest Atreyu	by JoeU2004	3	1,211
User Defined Function and VLookUP Kevin	by Kevin	11	1,148
Match value return a text ppp	by Jacob Skaria	6	558
Allocate Value Across Monthly Periods AlanR[_2_]	by Jacob Skaria	1	3,022
Match Column and copy to cell Column D Jeffrey Yau	by Ashish Mathur[_2_]	1	616
Include calculations in the lookup function JP Ronse	by Lars-Åke Aspelin[_2_]	8	450
nper cdh625	by Ron Rosenfeld	1	508
custom created table styles TinaW	by Gord Dibben	6	1,140
Workday function returns the wrong date when the duration is 5 day KarenMA	by Ron Rosenfeld	5	1,170
Split list query for Vlookups CellShocked	by BSc Chem Eng Rick	1	435
help with data match ppp	by ppp	0	476
WildCards in Sumif Function Hardeep Kanwar	by Bob Phillips[_3_]	2	579
display number if date is in a range lmarty	by David Biddulph[_2_]	5	417
Help with formula (decimal to fraction) Jack Deuce	by David Biddulph[_2_]	2	2,153
Local Apparent Time (LAT) - real / actual solar time ? Kelvin	by David Biddulph[_2_]	2	3,779
Counting Unique occurences of text in a column Bernd P	by Bernd P	0	468
Numbering years and months Colin Hayes	by Colin Hayes	5	503
Colors too dark! BiT212	by JLatham	1	1,064
External data connections CellShocked	by CellShocked	2	884
SUMIFs function lefty	by Gord Dibben	2	564
Using wildcard * in MATCH berniean	by Max	6	979
how do i use IF to substitute for another cell? Tim	by Gord Dibben	1	358
using sort in excel 2003 naj	by Gord Dibben	2	438
Copying formulas from one cell to another Woodie6	by Gord Dibben	7	609
SUMIFS function lefty	by Teethless mama	4	530
I have a column of 50 numbers Skip[_2_]	by Pete_UK	5	308
Do while not last row littleredhairedgirl	by Mike H	2	600
BeforeRightClick gk	by gk	4	504
Create Sheet & Copy Stuff littleredhairedgirl	by littleredhairedgirl	0	393
Text Item Processor littleredhairedgirl	by littleredhairedgirl	1	403
formula in excel Laundone	by Jacob Skaria	2	320
Weighted grades Otyokwa	by T. Valko	2	492
What formula would I use? Redland	by Redland	2	386
Simpler way to pull a cell value from a group based on 2 factors? ker_01	by smartin	1	318
Table Lookup JeffK	by JeffK	3	317
to link information between two lists Bklynhyc	by Ashish Mathur[_2_]	16	1,080
Macro to copy data when data is detected in another column(s). Richard	by Gord Dibben	2	580
Is there a Dolph-Chebychev function in Excel? richrdsn70	by richrdsn70	0	443
Vlookup JeffK	by JeffK	5	443
scrolling columns behind previous columns gfw	by Gord Dibben	4	859
Sumproduct Help Curtis	by Curtis	3	480
Vlookup PAL	by Tom Hutchins	2	306
Difference between these two formulas? ker_01	by ker_01	5	485
Pivot Table using data from multiple sheets nabanco	by ryguy7272	1	968
Project a date and calculate a % in one formula bert_lady	by Sean Timmons	4	395
Changing zoom level automatically Xt	by Xt	2	3,605
Formatting a radio button Iriemon	by Dave Peterson	4	1,629
Formula Help Newfie809	by Pete_UK	5	506
Copying Formulas Kris	by John[_22_]	4	386
Problem with Functions and Formulas Kris	by Jacob Skaria	11	989
Sumif with multiple sets of duplicates Lou Nunez	by Tom Hutchins	4	1,385
#value! error in sum function Art	by T. Valko	9	639
Limit access in a pivot table Ken	by Tom Hutchins	2	656
adding actual numbers in columns geb	by T. Valko	3	503
Calc occurrances for weekday omitting weekend data dtoney	by Bernard Liengme[_3_]	4	753
IF statements with multiple criteria LWilson	by LWilson	2	1,597
Function to Filter Unique Records Tevuna	by MPI Planner[_2_]	6	760
convert currency to word Soumya Samanthan	by Bob Phillips[_3_]	2	452
Validation List Steve HKG[_2_]	by Steve HKG[_2_]	0	343
Mid function Maria[_4_]	by Bob Phillips[_3_]	2	342
removing blanks from range (mr Pearson) Atishoo	by Atishoo	1	312
Help with formula Jack Deuce	by Bob Phillips[_3_]	3	593
Rearranging a report Rick	by Pete_UK	7	359
Combining text from several cells into 1 cell Rick	by Rick	4	1,785
Vlookups (sum of) Caroline	by Caroline	7	495
Transpose data and retain links to original data Neil	by David Biddulph[_2_]	2	599
Counting Closed Date < 2 weeks of Open Date etc gcw	by gcw	0	572