Excel Worksheet Functions - Page 305

Thread / Thread Starter	Last Post	Replies	Views
cell indicator flag jtaiariol	by Gord Dibben	2	769
Formula w/two columns to add the greater number Saul	by T. Valko	2	600
Top Ten Lists with a twist (or three). Bigfoot17	by Bigfoot17	0	349
If(AND) Statement KalliKay	by JP[_4_]	5	364
lookup a category for a part that contains a start and end value winnie123	by Pete_UK	6	558
Can I reduce (101.25) to only what's right of decimal? (25) jay45940	by Harlan Grove[_2_]	2	448
SumProduct with Date Range and One Condition that is Text Iona	by T. Valko	4	1,022
Excel Worksheet functions IOW	by Spiky	5	487
sum a range based on criteria in rowdata and column name L Davis	by L Davis	5	1,731
Frequency of Serial Number Andri	by Spiky	1	475
Number of days in a quarter between two date ranges Mike	by Bernd P	3	1,731
Decimals on a date calculation DianeG	by DianeG	5	719
Hyperlink not staying Active Susan	by Susan	0	687
Use horizontal lookup with pivot table Gerardo	by Gerardo	0	1,388
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter Greg in CO[_2_]	by Greg in CO[_2_]	0	3,176
linking rows Claire	by Pete_UK	1	538
I am getting formula displayed in some cells rather than the resul GG	by Niek Otten	2	478
Import a "custom list" from another user Chet	by Chet	0	404
Attempting to Copy a IF Function Andrew Holzman	by T. Valko	3	432
Initiate a trigger for clearing a list of check boxes? JGarland	by Joel	1	496
export from 07 excel to outlook contacts Bluedee	by Bluedee	0	576
text as a number Wiktor	by David Biddulph[_2_]	5	457
Pivot table updation Velu	by JP[_4_]	1	434
Changing a Formula Mark	by Pete_UK	2	475
Add values based on multiple criteria myersl	by Mike H	4	1,075
Macros Brian Henderson	by Brian Henderson	0	525
Remove space in front of number in a cell? Barcelona	by Barcelona	5	7,115
nested vlookups Louie	by Louie	4	612
Summing multiple account #s in one cell, by referencing Matt	by Matt	4	343
Find value within a range and extrapolating....(tiered commission) jazzii	by Pete_UK	1	541
Formatting and IF Statements PMarble	by Duke Carey	3	653
Mulitple if function [email protected]	by Bob Phillips[_3_]	2	367
why does when i drag a formula in excel gives the same value? oliver	by Roger Govier[_3_]	5	1,066
How do I add a control check box to control other checkboxes? JGarland	by Joel	1	603
How do i edit links automatically? Jaba	by Sam Wilson	1	423
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch Adeel	by Mike H	7	809
Identify numbers that only occur once in a column. Karen	by Stefi	4	388
working on a cell formula sarge	by Stefi	1	336
Hyperlink Update Douglas	by Douglas	0	380
value error Jrh	by Ashish Mathur[_2_]	4	354
Using SMALL Function with select data thscc1659	by T. Valko	6	472
unsorted lookup j.ruderman[_2_]	by Ashish Mathur[_2_]	2	424
Multiple Vlookup Alfredo_CPA	by Max	1	460
Formula to search for a word and put that entire row in a list Tracy	by Bob Bridges[_2_]	3	432
What does this formula mean? bmac	by Sheeloo[_2_]	2	1,130
Vlookup returning a YES or NO Rob	by Héctor Miguel	6	1,437
Fill Down reference of even number rows jyorraku	by Ron Coderre[_3_]	3	1,237
converting vertical inches in tank to gallons (have manual chart) Scotty	by Pete_UK	14	2,486
Pulling partial information from a cell Emeryville John	by Ron Coderre[_3_]	2	862
Need a Sum but involves Text & multiple functions v!v	by v!v	4	392
nested subtotal with sumproduct SteveDB1	by SteveDB1	0	772
Need help summing time ascottbag-hcm	by Peo Sjoblom[_2_]	6	678
Mix text and numbers with leading zeros Susan B	by Susan B	3	528
Combining functions: Subtraction and IF Jeguth1s	by T. Valko	1	519
Concatenate with carriage return- how to remove blanks? cindyc	by Gord Dibben	3	2,172
Address can not be more than 30 characters NeSchw6G	by Don Guillett	7	511
Last Friday of the month Alfredo_CPA	by T. Valko	9	2,255
Hybrid vlookup - sum function Emeryville John	by Dave Peterson	2	744
Vlookup mary/payroll	by mary/payroll	0	355
sumif or sum production - 3 or more criteria James	by Teethless mama	5	620
A mysterious if function to return a specific balance? hankach[_3_]	by hankach[_4_]	2	328
need formula to count non-zero items in an array based on a vlooku BKP	by BKP	2	633
Linking Workbooks crimlaw73	by crimlaw73	0	450
Complicated Countif application mpenkala	by mpenkala	4	412
Unable to activate "total row" in design tab SD Richmond	by SD Richmond	0	559
Average time values bpc	by Bob Umlas[_2_]	3	888
In a formula or function, what do the symbols "" mean. Rahne059	by David Biddulph[_2_]	3	2,048
Why result = 4 Andri	by Andri	4	367
Conditional Formatting of Checklist with several date variables [email protected]	by [email protected]	0	681
return first value greater than zero Rae	by Rae	3	3,182
named range link na	by Spiky	1	784
How do I find my worksheet tabs? Sherry	by PM	11	1,826
Vlookup with either/or [email protected]	by Teethless mama	5	7,137
Transpose Column to Row Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	9	1,056
INDEX MATCH formula Txlonghorn76	by Pete_UK	8	490