Excel Worksheet Functions - Page 305

Thread / Thread Starter	Last Post	Replies	Views
cell indicator flag jtaiariol	by Gord Dibben	2	764
Formula w/two columns to add the greater number Saul	by T. Valko	2	598
Top Ten Lists with a twist (or three). Bigfoot17	by Bigfoot17	0	348
If(AND) Statement KalliKay	by JP[_4_]	5	358
lookup a category for a part that contains a start and end value winnie123	by Pete_UK	6	555
Can I reduce (101.25) to only what's right of decimal? (25) jay45940	by Harlan Grove[_2_]	2	446
SumProduct with Date Range and One Condition that is Text Iona	by T. Valko	4	1,020
Excel Worksheet functions IOW	by Spiky	5	483
sum a range based on criteria in rowdata and column name L Davis	by L Davis	5	1,726
Frequency of Serial Number Andri	by Spiky	1	474
Number of days in a quarter between two date ranges Mike	by Bernd P	3	1,730
Decimals on a date calculation DianeG	by DianeG	5	709
Hyperlink not staying Active Susan	by Susan	0	684
Use horizontal lookup with pivot table Gerardo	by Gerardo	0	1,387
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter Greg in CO[_2_]	by Greg in CO[_2_]	0	3,168
linking rows Claire	by Pete_UK	1	537
I am getting formula displayed in some cells rather than the resul GG	by Niek Otten	2	476
Import a "custom list" from another user Chet	by Chet	0	402
Attempting to Copy a IF Function Andrew Holzman	by T. Valko	3	426
Initiate a trigger for clearing a list of check boxes? JGarland	by Joel	1	491
export from 07 excel to outlook contacts Bluedee	by Bluedee	0	575
text as a number Wiktor	by David Biddulph[_2_]	5	424
Pivot table updation Velu	by JP[_4_]	1	432
Changing a Formula Mark	by Pete_UK	2	472
Add values based on multiple criteria myersl	by Mike H	4	1,073
Macros Brian Henderson	by Brian Henderson	0	504
Remove space in front of number in a cell? Barcelona	by Barcelona	5	7,005
nested vlookups Louie	by Louie	4	588
Summing multiple account #s in one cell, by referencing Matt	by Matt	4	341
Find value within a range and extrapolating....(tiered commission) jazzii	by Pete_UK	1	540
Formatting and IF Statements PMarble	by Duke Carey	3	651
Mulitple if function [email protected]	by Bob Phillips[_3_]	2	366
why does when i drag a formula in excel gives the same value? oliver	by Roger Govier[_3_]	5	1,060
How do I add a control check box to control other checkboxes? JGarland	by Joel	1	594
How do i edit links automatically? Jaba	by Sam Wilson	1	418
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch Adeel	by Mike H	7	798
Identify numbers that only occur once in a column. Karen	by Stefi	4	386
working on a cell formula sarge	by Stefi	1	335
Hyperlink Update Douglas	by Douglas	0	380
value error Jrh	by Ashish Mathur[_2_]	4	353
Using SMALL Function with select data thscc1659	by T. Valko	6	468
unsorted lookup j.ruderman[_2_]	by Ashish Mathur[_2_]	2	419
Multiple Vlookup Alfredo_CPA	by Max	1	459
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,128
Vlookup returning a YES or NO Rob	by Héctor Miguel	6	1,428
Fill Down reference of even number rows jyorraku	by Ron Coderre[_3_]	3	1,234
converting vertical inches in tank to gallons (have manual chart) Scotty	by Pete_UK	14	2,477
Pulling partial information from a cell Emeryville John	by Ron Coderre[_3_]	2	861
Need a Sum but involves Text & multiple functions v!v	by v!v	4	386
nested subtotal with sumproduct SteveDB1	by SteveDB1	0	771
Need help summing time ascottbag-hcm	by Peo Sjoblom[_2_]	6	672
Mix text and numbers with leading zeros Susan B	by Susan B	3	526
Combining functions: Subtraction and IF Jeguth1s	by T. Valko	1	514
Concatenate with carriage return- how to remove blanks? cindyc	by Gord Dibben	3	2,167
Address can not be more than 30 characters NeSchw6G	by Don Guillett	7	509
Last Friday of the month Alfredo_CPA	by T. Valko	9	2,254
Hybrid vlookup - sum function Emeryville John	by Dave Peterson	2	742
Vlookup mary/payroll	by mary/payroll	0	354
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	322
need formula to count non-zero items in an array based on a vlooku BKP	by BKP	2	631
Linking Workbooks crimlaw73	by crimlaw73	0	442
Complicated Countif application mpenkala	by mpenkala	4	383
Unable to activate "total row" in design tab SD Richmond	by SD Richmond	0	559
Average time values bpc	by Bob Umlas[_2_]	3	883
In a formula or function, what do the symbols "" mean. Rahne059	by David Biddulph[_2_]	3	2,037
Why result = 4 Andri	by Andri	4	367
Conditional Formatting of Checklist with several date variables [email protected]	by [email protected]	0	678
return first value greater than zero Rae	by Rae	3	3,173
named range link na	by Spiky	1	777
How do I find my worksheet tabs? Sherry	by PM	11	1,818
Vlookup with either/or [email protected]	by Teethless mama	5	7,126
Transpose Column to Row Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	9	1,051
INDEX MATCH formula Txlonghorn76	by Pete_UK	8	487