Excel Worksheet Functions - Page 120

Thread / Thread Starter	Last Post	Replies	Views
IF to group months John McDonnell	by Ashish Mathur[_2_]	3	416
FAO Mike Caroline	by Glenn	10	924
? enter a static time (Excel) in a cell using the IF function Dave Peterson	by Dave Peterson	0	727
help formula (ranking) Eddy Stan	by JLatham	1	417
More columne sorting BEOPS	by David Biddulph[_2_]	5	365
Look up last and next entry Huggy	by Huggy	5	325
sumif using "AND" and "Date" Excel_Kiwi[_2_]	by Jacob Skaria	2	384
Formula have a VLOOKUP but want it to =0 if no value is found Nicole	by T. Valko	3	1,907
Formula for payout & interest Atreyu	by JoeU2004	3	1,218
User Defined Function and VLookUP Kevin	by Kevin	11	1,155
Match value return a text ppp	by Jacob Skaria	6	570
Allocate Value Across Monthly Periods AlanR[_2_]	by Jacob Skaria	1	3,029
Match Column and copy to cell Column D Jeffrey Yau	by Ashish Mathur[_2_]	1	644
Include calculations in the lookup function JP Ronse	by Lars-Åke Aspelin[_2_]	8	459
nper cdh625	by Ron Rosenfeld	1	516
custom created table styles TinaW	by Gord Dibben	6	1,164
Workday function returns the wrong date when the duration is 5 day KarenMA	by Ron Rosenfeld	5	1,179
Split list query for Vlookups CellShocked	by BSc Chem Eng Rick	1	440
help with data match ppp	by ppp	0	479
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	423
Help with formula (decimal to fraction) Jack Deuce	by David Biddulph[_2_]	2	2,176
Local Apparent Time (LAT) - real / actual solar time ? Kelvin	by David Biddulph[_2_]	2	3,833
Counting Unique occurences of text in a column Bernd P	by Bernd P	0	478
Numbering years and months Colin Hayes	by Colin Hayes	5	508
Colors too dark! BiT212	by JLatham	1	1,082
External data connections CellShocked	by CellShocked	2	904
SUMIFs function lefty	by Gord Dibben	2	593
Using wildcard * in MATCH berniean	by Max	6	1,036
how do i use IF to substitute for another cell? Tim	by Gord Dibben	1	366
using sort in excel 2003 naj	by Gord Dibben	2	440
Copying formulas from one cell to another Woodie6	by Gord Dibben	7	631
SUMIFS function lefty	by Teethless mama	4	551
I have a column of 50 numbers Skip[_2_]	by Pete_UK	5	339
Do while not last row littleredhairedgirl	by Mike H	2	603
BeforeRightClick gk	by gk	4	522
Create Sheet & Copy Stuff littleredhairedgirl	by littleredhairedgirl	0	402
Text Item Processor littleredhairedgirl	by littleredhairedgirl	1	416
formula in excel Laundone	by Jacob Skaria	2	325
Weighted grades Otyokwa	by T. Valko	2	497
What formula would I use? Redland	by Redland	2	390
Simpler way to pull a cell value from a group based on 2 factors? ker_01	by smartin	1	324
Table Lookup JeffK	by JeffK	3	330
to link information between two lists Bklynhyc	by Ashish Mathur[_2_]	16	1,091
Macro to copy data when data is detected in another column(s). Richard	by Gord Dibben	2	591
Is there a Dolph-Chebychev function in Excel? richrdsn70	by richrdsn70	0	448
Vlookup JeffK	by JeffK	5	449
scrolling columns behind previous columns gfw	by Gord Dibben	4	885
Sumproduct Help Curtis	by Curtis	3	488
Vlookup PAL	by Tom Hutchins	2	311
Difference between these two formulas? ker_01	by ker_01	5	489
Pivot Table using data from multiple sheets nabanco	by ryguy7272	1	970
Project a date and calculate a % in one formula bert_lady	by Sean Timmons	4	398
Changing zoom level automatically Xt	by Xt	2	3,617
Formatting a radio button Iriemon	by Dave Peterson	4	1,664
Formula Help Newfie809	by Pete_UK	5	511
Copying Formulas Kris	by John[_22_]	4	392
Problem with Functions and Formulas Kris	by Jacob Skaria	11	1,005
Sumif with multiple sets of duplicates Lou Nunez	by Tom Hutchins	4	1,396
#value! error in sum function Art	by T. Valko	9	640
Limit access in a pivot table Ken	by Tom Hutchins	2	667
adding actual numbers in columns geb	by T. Valko	3	505
Calc occurrances for weekday omitting weekend data dtoney	by Bernard Liengme[_3_]	4	760
IF statements with multiple criteria LWilson	by LWilson	2	1,609
Function to Filter Unique Records Tevuna	by MPI Planner[_2_]	6	777
convert currency to word Soumya Samanthan	by Bob Phillips[_3_]	2	464
Validation List Steve HKG[_2_]	by Steve HKG[_2_]	0	356
Mid function Maria[_4_]	by Bob Phillips[_3_]	2	346
removing blanks from range (mr Pearson) Atishoo	by Atishoo	1	321
Help with formula Jack Deuce	by Bob Phillips[_3_]	3	601
Rearranging a report Rick	by Pete_UK	7	370
Combining text from several cells into 1 cell Rick	by Rick	4	1,796
Vlookups (sum of) Caroline	by Caroline	7	515
Transpose data and retain links to original data Neil	by David Biddulph[_2_]	2	607
Counting Closed Date < 2 weeks of Open Date etc gcw	by gcw	0	590