Excel Worksheet Functions - Page 120

Thread / Thread Starter	Last Post	Replies	Views
IF to group months John McDonnell	by Ashish Mathur[_2_]	3	407
FAO Mike Caroline	by Glenn	10	910
? enter a static time (Excel) in a cell using the IF function Dave Peterson	by Dave Peterson	0	718
help formula (ranking) Eddy Stan	by JLatham	1	408
More columne sorting BEOPS	by David Biddulph[_2_]	5	358
Look up last and next entry Huggy	by Huggy	5	319
sumif using "AND" and "Date" Excel_Kiwi[_2_]	by Jacob Skaria	2	370
Formula have a VLOOKUP but want it to =0 if no value is found Nicole	by T. Valko	3	1,891
Formula for payout & interest Atreyu	by JoeU2004	3	1,210
User Defined Function and VLookUP Kevin	by Kevin	11	1,147
Match value return a text ppp	by Jacob Skaria	6	557
Allocate Value Across Monthly Periods AlanR[_2_]	by Jacob Skaria	1	3,021
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	446
nper cdh625	by Ron Rosenfeld	1	507
custom created table styles TinaW	by Gord Dibben	6	1,134
Workday function returns the wrong date when the duration is 5 day KarenMA	by Ron Rosenfeld	5	1,168
Split list query for Vlookups CellShocked	by BSc Chem Eng Rick	1	434
help with data match ppp	by ppp	0	475
WildCards in Sumif Function Hardeep Kanwar	by Bob Phillips[_3_]	2	568
display number if date is in a range lmarty	by David Biddulph[_2_]	5	413
Help with formula (decimal to fraction) Jack Deuce	by David Biddulph[_2_]	2	2,152
Local Apparent Time (LAT) - real / actual solar time ? Kelvin	by David Biddulph[_2_]	2	3,775
Counting Unique occurences of text in a column Bernd P	by Bernd P	0	467
Numbering years and months Colin Hayes	by Colin Hayes	5	502
Colors too dark! BiT212	by JLatham	1	1,060
External data connections CellShocked	by CellShocked	2	881
SUMIFs function lefty	by Gord Dibben	2	563
Using wildcard * in MATCH berniean	by Max	6	978
how do i use IF to substitute for another cell? Tim	by Gord Dibben	1	357
using sort in excel 2003 naj	by Gord Dibben	2	437
Copying formulas from one cell to another Woodie6	by Gord Dibben	7	608
SUMIFS function lefty	by Teethless mama	4	529
I have a column of 50 numbers Skip[_2_]	by Pete_UK	5	298
Do while not last row littleredhairedgirl	by Mike H	2	599
BeforeRightClick gk	by gk	4	495
Create Sheet & Copy Stuff littleredhairedgirl	by littleredhairedgirl	0	392
Text Item Processor littleredhairedgirl	by littleredhairedgirl	1	402
formula in excel Laundone	by Jacob Skaria	2	319
Weighted grades Otyokwa	by T. Valko	2	491
What formula would I use? Redland	by Redland	2	383
Simpler way to pull a cell value from a group based on 2 factors? ker_01	by smartin	1	317
Table Lookup JeffK	by JeffK	3	316
to link information between two lists Bklynhyc	by Ashish Mathur[_2_]	16	1,079
Macro to copy data when data is detected in another column(s). Richard	by Gord Dibben	2	578
Vlookup JeffK	by JeffK	5	442
Is there a Dolph-Chebychev function in Excel? richrdsn70	by richrdsn70	0	442
scrolling columns behind previous columns gfw	by Gord Dibben	4	858
Sumproduct Help Curtis	by Curtis	3	479
Vlookup PAL	by Tom Hutchins	2	305
Difference between these two formulas? ker_01	by ker_01	5	484
Pivot Table using data from multiple sheets nabanco	by ryguy7272	1	967
Project a date and calculate a % in one formula bert_lady	by Sean Timmons	4	394
Changing zoom level automatically Xt	by Xt	2	3,604
Formatting a radio button Iriemon	by Dave Peterson	4	1,618
Formula Help Newfie809	by Pete_UK	5	501
Copying Formulas Kris	by John[_22_]	4	386
Problem with Functions and Formulas Kris	by Jacob Skaria	11	988
Sumif with multiple sets of duplicates Lou Nunez	by Tom Hutchins	4	1,382
#value! error in sum function Art	by T. Valko	9	636
Limit access in a pivot table Ken	by Tom Hutchins	2	651
adding actual numbers in columns geb	by T. Valko	3	502
Calc occurrances for weekday omitting weekend data dtoney	by Bernard Liengme[_3_]	4	753
IF statements with multiple criteria LWilson	by LWilson	2	1,596
Function to Filter Unique Records Tevuna	by MPI Planner[_2_]	6	759
convert currency to word Soumya Samanthan	by Bob Phillips[_3_]	2	451
Validation List Steve HKG[_2_]	by Steve HKG[_2_]	0	342
Mid function Maria[_4_]	by Bob Phillips[_3_]	2	341
removing blanks from range (mr Pearson) Atishoo	by Atishoo	1	311
Help with formula Jack Deuce	by Bob Phillips[_3_]	3	592
Rearranging a report Rick	by Pete_UK	7	357
Combining text from several cells into 1 cell Rick	by Rick	4	1,781
Vlookups (sum of) Caroline	by Caroline	7	494
Transpose data and retain links to original data Neil	by David Biddulph[_2_]	2	598
Counting Closed Date < 2 weeks of Open Date etc gcw	by gcw	0	571