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	608
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	580
Can I reduce (101.25) to only what's right of decimal? (25) jay45940	by Harlan Grove[_2_]	2	454
SumProduct with Date Range and One Condition that is Text Iona	by T. Valko	4	1,060
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,760
Frequency of Serial Number Andri	by Spiky	1	488
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	732
Hyperlink not staying Active Susan	by Susan	0	710
Use horizontal lookup with pivot table Gerardo	by Gerardo	0	1,396
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter Greg in CO[_2_]	by Greg in CO[_2_]	0	3,226
linking rows Claire	by Pete_UK	1	546
I am getting formula displayed in some cells rather than the resul GG	by Niek Otten	2	482
Import a "custom list" from another user Chet	by Chet	0	411
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	586
text as a number Wiktor	by David Biddulph[_2_]	5	468
Pivot table updation Velu	by JP[_4_]	1	439
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,149
nested vlookups Louie	by Louie	4	632
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	546
Formatting and IF Statements PMarble	by Duke Carey	3	656
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,080
How do I add a control check box to control other checkboxes? JGarland	by Joel	1	620
How do i edit links automatically? Jaba	by Sam Wilson	1	430
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch Adeel	by Mike H	7	828
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	362
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	471
Formula to search for a word and put that entire row in a list Tracy	by Bob Bridges[_2_]	3	448
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,454
Fill Down reference of even number rows jyorraku	by Ron Coderre[_3_]	3	1,250
converting vertical inches in tank to gallons (have manual chart) Scotty	by Pete_UK	14	2,536
Pulling partial information from a cell Emeryville John	by Ron Coderre[_3_]	2	878
Need a Sum but involves Text & multiple functions v!v	by v!v	4	416
nested subtotal with sumproduct SteveDB1	by SteveDB1	0	803
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	541
Concatenate with carriage return- how to remove blanks? cindyc	by Gord Dibben	3	2,200
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,271
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	627
A mysterious if function to return a specific balance? hankach[_3_]	by hankach[_4_]	2	332
need formula to count non-zero items in an array based on a vlooku BKP	by BKP	2	645
Linking Workbooks crimlaw73	by crimlaw73	0	463
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,055
Why result = 4 Andri	by Andri	4	375
Conditional Formatting of Checklist with several date variables [email protected]	by [email protected]	0	685
return first value greater than zero Rae	by Rae	3	3,224
named range link na	by Spiky	1	828
How do I find my worksheet tabs? Sherry	by PM	11	1,834
Vlookup with either/or [email protected]	by Teethless mama	5	7,192
Transpose Column to Row Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	9	1,072
INDEX MATCH formula Txlonghorn76	by Pete_UK	8	508