Excel Worksheet Functions - Page 407

Thread / Thread Starter	Last Post	Replies	Views
create blank/empty cell - don't want a zero to be plotted in chart GJS001	by Ashish Mathur[_2_]	6	1,876
Conditional Formatting gjuarez	by Sheeloo	1	308
Excedl Password GK	by Bernard Liengme	1	394
BeforeRightClick gk	by gk	4	505
Excel - change the primary Mousebutton to left ButtonClick gk	by gk	0	473
lookup functions and text comparisons GK	by Max	1	416
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,482
detect when columns being written to a worksheet “cross” a vertical page break gkb_cardiff	by gkb_cardiff	0	459
Counting "rows", i.e. simultaneous criteria for multiple cells gkline	by JulieD	2	1,580
Check Box gkrapf	by gkrapf	2	506
Trying to HLOOKUP a value from another sheet and display all the d gktan	by Jacob Skaria	4	2,074
Automatic recognition of a starting point for a column calculation GK[_2_]	by Marcelo	2	594
Insert value based on range GL	by T. Valko	3	835
Time difference between two times GL	by David Biddulph[_2_]	1	866
Does Excel have a "sumnegative" function like Lotus? GladesTiger	by Ashish Mathur	3	414
Row height will not auto format gladfelterk	by gladfelterk	0	1,538
negative time summation calculation for a standard day Glamb	by Fred Smith[_4_]	2	679
How can I create custom format cells for Ohms(Î©)?? GlanzaV	by Ron Rosenfeld	1	2,661
how do I auto cut & paste from one spreadsheet to another? glasgowp	by glasgowp	2	537
How do I find a mode while disregarding a specific cell value? glasskit	by Peo Sjoblom	1	724
How do I color one cell and have another cell get same color glassman	by Otto Moehrbach[_2_]	1	1,529
Find a value Using a lookup table multiple columns and rows glasspumpkin	by glasspumpkin	4	1,843
Unique Names w/ Conditions Glempy	by Herbert Seidenberg	2	426
linking colour format between sheets glen	by glen	0	452
Average Glen	by T. Valko	1	358
Parse data where break is a first uppercase character in a string? Glen	by Ron Rosenfeld	5	1,043
reccuring date on spread sheet Glen	by Glen	0	316
Default work sheet size Glen	by Gord Dibben	1	538
How can I add a percentage sign to a cell with data validation Glen	by Glen	4	911
tools options greyed out Glen Brittle	by Glen Brittle	0	829
Using the VLOOKUP Command Glen Disteafno	by Biff	2	548
Excel 2007 - Change link source requiring multiple entry of passwo Glen Miller	by Glen Miller	0	528
Filter problem [email protected]	by DOR	1	604
Worksheet several pages, Want name to show up on each page Glenda	by Gord Dibben	2	451
Extending the worksheet beyond the 'IV' cell Glenda	by Pete_UK	2	955
EXCEL -- want to do have ''averageif'' - like sumif function - H. Glenda	by Chip Pearson	1	915
How do I use countif to count values excluding blank cells Glenda	by PCLIVE	4	4,796
how to search within a row or colomn for a particular string Glenda701	by Rick Rothstein	1	595
I am having trouble adding a row in Excel. What am i doing wrong? Glendie	by Gord Dibben	1	601
password protected a check box Glendon MacBurnie	by Glendon MacBurnie	0	474
Looking for an ID number in a column Glenn	by Fred Smith[_5_]	1	325
need help using "RANDBETWEEN" in excel glenn	by David Biddulph[_2_]	4	755
how to count if a cell value falls between two numbers Glenn	by Jacob Skaria	4	4,506
Averaging blank or cells with Zeros in them. Glenn	by Glenn	4	645
SUMPRODUCT and Dates Glenn	by Glenn	2	553
find a sequence Glenn	by Glenn	0	350
Consolidate excel 2007 Glenn	by Dave Peterson	4	689
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,688
Calculation formula Glenn	by Glenn	0	376
CountIF Help Glenn	by Glenn	3	360
insert verticle lines between columns Glenn	by Debra Dalgleish	2	2,136
Formula contains "" but cell still shows a value Glenn	by Keith Howard	4	476
#VALUE! Glenn	by T. Valko	5	376
Prevent duplication across sheets Glenn	by Glenn	2	601
Trouble with an IF formula glenn	by SimonCC	1	392
Inventory Control Glenn	by Ola Sigurdh	1	488
Totalling values across columns Glenn	by Max	3	661
Counting data in a range Glenn L.	by T. Valko	7	560
Formula constants? Glenn L.[_2_]	by Glenn L.[_2_]	2	461
Do not propmt to save data on exit Glenn Rathke $Soft Design Consulting$	by Glenn Rathke $Soft Design Consulting$	3	875
Excel in a Browser and Security Glenn Rathke $Soft Design Consulting$	by Glenn Rathke $Soft Design Consulting$	0	333
Hyperlink problem Glenn Richardson	by Glenn Richardson	2	442
Hyperlink probelm Glenn Richardson	by Dave Peterson	2	377
How do I convert a row of cells into a two-dimensional array? Glenn@stress	by Alan Beban	7	782
Formula Workdays-Holidays-adjustments Glenna	by Glenna	4	486
Using variable cell references in Excel? eg A[B42] instead of A7 GlennC	by T. Valko	1	466
Delete asterisks from text in cells? Glennlane1	by Jason Morin	1	524
vlookup does not work between 71% to 79% refernceing roundup numb Glennrbt	by Glennrbt	4	1,049
Help Pleasssssse Glennyboy	by Domenic	2	372
Report Glennyboy	by Glennyboy	0	536
copy & paste formula between spreadsheets - not working Glibby Gibson	by Glibby Gibson	0	1,797
add column of minutes, show total in hours & minutes glider pilot	by Peo Sjoblom	1	1,616
Sheet to Sheet info transfer gLightFoto	by Gord Dibben	1	399
Counting (sub)totals glince	by glince	0	302
the name tabs at the bottom of each page, how can they be made big glindamm	by Roger Govier	2	608