Excel Worksheet Functions - Page 305

Thread / Thread Starter	Last Post	Replies	Views
cell indicator flag jtaiariol	by Gord Dibben	2	777
Formula w/two columns to add the greater number Saul	by T. Valko	2	606
Top Ten Lists with a twist (or three). Bigfoot17	by Bigfoot17	0	363
If(AND) Statement KalliKay	by JP[_4_]	5	367
lookup a category for a part that contains a start and end value winnie123	by Pete_UK	6	575
Can I reduce (101.25) to only what's right of decimal? (25) jay45940	by Harlan Grove[_2_]	2	452
SumProduct with Date Range and One Condition that is Text Iona	by T. Valko	4	1,059
Excel Worksheet functions IOW	by Spiky	5	499
sum a range based on criteria in rowdata and column name L Davis	by L Davis	5	1,759
Frequency of Serial Number Andri	by Spiky	1	485
Number of days in a quarter between two date ranges Mike	by Bernd P	3	1,742
Decimals on a date calculation DianeG	by DianeG	5	731
Hyperlink not staying Active Susan	by Susan	0	710
Use horizontal lookup with pivot table Gerardo	by Gerardo	0	1,394
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter Greg in CO[_2_]	by Greg in CO[_2_]	0	3,215
linking rows Claire	by Pete_UK	1	545
I am getting formula displayed in some cells rather than the resul GG	by Niek Otten	2	481
Import a "custom list" from another user Chet	by Chet	0	410
Attempting to Copy a IF Function Andrew Holzman	by T. Valko	3	438
Initiate a trigger for clearing a list of check boxes? JGarland	by Joel	1	501
export from 07 excel to outlook contacts Bluedee	by Bluedee	0	585
text as a number Wiktor	by David Biddulph[_2_]	5	468
Pivot table updation Velu	by JP[_4_]	1	438
Changing a Formula Mark	by Pete_UK	2	483
Add values based on multiple criteria myersl	by Mike H	4	1,080
Macros Brian Henderson	by Brian Henderson	0	529
Remove space in front of number in a cell? Barcelona	by Barcelona	5	7,130
nested vlookups Louie	by Louie	4	623
Summing multiple account #s in one cell, by referencing Matt	by Matt	4	350
Find value within a range and extrapolating....(tiered commission) jazzii	by Pete_UK	1	545
Formatting and IF Statements PMarble	by Duke Carey	3	655
Mulitple if function [email protected]	by Bob Phillips[_3_]	2	372
why does when i drag a formula in excel gives the same value? oliver	by Roger Govier[_3_]	5	1,078
How do I add a control check box to control other checkboxes? JGarland	by Joel	1	618
How do i edit links automatically? Jaba	by Sam Wilson	1	429
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch Adeel	by Mike H	7	827
Identify numbers that only occur once in a column. Karen	by Stefi	4	399
working on a cell formula sarge	by Stefi	1	340
Hyperlink Update Douglas	by Douglas	0	385
value error Jrh	by Ashish Mathur[_2_]	4	361
Using SMALL Function with select data thscc1659	by T. Valko	6	478
unsorted lookup j.ruderman[_2_]	by Ashish Mathur[_2_]	2	433
Multiple Vlookup Alfredo_CPA	by Max	1	470
Formula to search for a word and put that entire row in a list Tracy	by Bob Bridges[_2_]	3	447
What does this formula mean? bmac	by Sheeloo[_2_]	2	1,132
Vlookup returning a YES or NO Rob	by Héctor Miguel	6	1,452
Fill Down reference of even number rows jyorraku	by Ron Coderre[_3_]	3	1,248
converting vertical inches in tank to gallons (have manual chart) Scotty	by Pete_UK	14	2,534
Pulling partial information from a cell Emeryville John	by Ron Coderre[_3_]	2	875
Need a Sum but involves Text & multiple functions v!v	by v!v	4	414
nested subtotal with sumproduct SteveDB1	by SteveDB1	0	802
Need help summing time ascottbag-hcm	by Peo Sjoblom[_2_]	6	690
Mix text and numbers with leading zeros Susan B	by Susan B	3	534
Combining functions: Subtraction and IF Jeguth1s	by T. Valko	1	536
Concatenate with carriage return- how to remove blanks? cindyc	by Gord Dibben	3	2,199
Address can not be more than 30 characters NeSchw6G	by Don Guillett	7	518
Last Friday of the month Alfredo_CPA	by T. Valko	9	2,268
Hybrid vlookup - sum function Emeryville John	by Dave Peterson	2	749
Vlookup mary/payroll	by mary/payroll	0	358
sumif or sum production - 3 or more criteria James	by Teethless mama	5	626
A mysterious if function to return a specific balance? hankach[_3_]	by hankach[_4_]	2	330
need formula to count non-zero items in an array based on a vlooku BKP	by BKP	2	644
Linking Workbooks crimlaw73	by crimlaw73	0	461
Complicated Countif application mpenkala	by mpenkala	4	425
Unable to activate "total row" in design tab SD Richmond	by SD Richmond	0	568
Average time values bpc	by Bob Umlas[_2_]	3	893
In a formula or function, what do the symbols "" mean. Rahne059	by David Biddulph[_2_]	3	2,054
Why result = 4 Andri	by Andri	4	371
Conditional Formatting of Checklist with several date variables [email protected]	by [email protected]	0	684
return first value greater than zero Rae	by Rae	3	3,208
named range link na	by Spiky	1	797
How do I find my worksheet tabs? Sherry	by PM	11	1,833
Vlookup with either/or [email protected]	by Teethless mama	5	7,190
Transpose Column to Row Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	9	1,068
INDEX MATCH formula Txlonghorn76	by Pete_UK	8	502