Excel Discussion (Misc queries) - Page 409

Thread / Thread Starter	Last Post	Replies	Views
Excel 07 compatability checker Dave F[_2_]	by Dave F[_2_]	0	484
=NOT(ISNUMBER(RIGH(V670,5))) Dave F[_2_]	by Dave F[_2_]	4	1,282
a more efficient way of performing this calculation? Dave F[_2_]	by Peo Sjoblom	1	357
defining an array for INDEX Dave F[_2_]	by Dave F[_2_]	1	500
custom number format Dave F[_2_]	by Gary''s Student	1	354
using OFFSET(INDEX(MATCH))) Dave F[_2_]	by Peo Sjoblom	3	5,598
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4 ) Dave F[_2_]	by Duke Carey	3	962
ignore MAX and MIN values in a set to calculate average Dave F[_2_]	by JE McGimpsey	5	1,944
=INDEX($B$2:$P$2,COLUMNS(B$2:$P$2)) Dave F[_2_]	by RagDyeR	3	1,091
=ADDRESS(8,INDEX(MATCH(AO5,E5:P5,0),,)+4) Dave F[_2_]	by Marcelo	2	453
return a cell address based on a matched value.. Dave F[_2_]	by Dave F[_2_]	4	2,180
using INDIRECT(ADDRESS(...)) Dave F[_2_]	by Tyro[_2_]	4	603
OFFSET vs INDEX(MATCH(...)) Dave F[_2_]	by Bob Phillips	1	2,379
pivot table data field defaults to COUNT, would like it to default toSUM Dave F[_2_]	by Dave F[_2_]	2	608
LEN = 0; ISBLANK = FALSE Dave F[_2_]	by Dave F[_2_]	6	2,763
SUMIF using #N/A error as criteria Dave F[_2_]	by ExcelBanter AI	4	9,864
cell address for first value to appear in a range Dave F[_2_]	by Dave F[_2_]	5	1,571
MAX, MAXA functions Dave F[_2_]	by T. Valko	3	1,502
convert relative cell references to absolute cell references via amacro? Dave F[_2_]	by Bob Phillips	1	1,988
SUMIF vs SUMPRODUCT Dave F[_2_]	by RagDyer	5	412
geometric mean of a series of negative asset returns Dave F[_2_]	by Ron Rosenfeld	8	1,516
remove named ranges from formulas?? Dave F[_2_]	by Dave Peterson	2	533
determining the largest value in a sequence of text strings Dave F[_2_]	by Dave F[_2_]	6	642
how does this formula work: =LOOKUP(2,1/((COUNTIF(D6:D41,""&D6:D41)=0)*(D6:D41<"")),D6:D 41) Dave F[_2_]	by T. Valko	7	991
bad edges on 3D charts Dave F[_3_]	by Jon Peltier	1	525
Chart formatting Dave F[_3_]	by Dave F[_3_]	0	371
Paste from Word table so that 1 table cell = 1 Excel cell Dave G	by Dave Peterson	4	1,704
Office Communities in 2007 Dave G	by Dave G	0	413
Excel Dave G.	by Sheeloo[_2_]	1	366
Excel screws up my computer display Dave Gilblom	by Ron Rosenfeld	3	466
nested ifs dave glynn	by dave glynn	4	438
printing zero values dave glynn	by Carole O	1	448
inserting quotation marks dave glynn	by dave glynn	2	813
hiding columns automatically dave glynn	by	2	800
can i copy data without row numbers? dave glynn	by IanRoy	15	1,331
i have fields that are formatted for text that randomly convert t. dave glynn	by dave glynn	2	858
involuntary format changes dave glynn	by dave glynn	2	719
repeat macro formula to all cells dave glynn	by Bob Phillips	8	780
hiding columns automatically dave glynn	by dave glynn	0	723
filtering dave glynn	by dave glynn	6	475
prompting for filenames dave glynn	by Jim Cone	7	569
Macro won't run macro dave glynn	by dave glynn	0	632
how do i convert names to initials in excel dave glynn	by dave glynn	2	1,524
macros dave glynn	by Gary''s Student	1	358
worksheet references dave glynn	by bigwheel	1	342
updating links dave glynn	by dave glynn	1	509
How can i use data from multiple sheets in a formula? Dave Grainger	by Dannyg10	3	371
best way to combine logical and countif Dave H	by wickedchew	1	1,008
Formula Bar Doesn't Display Contents Dave H	by Dave H	0	1,428
Can I keep external connections in a table? Dave H	by Dave H	0	652
MS Query refresh question Dave H	by Dave H	0	1,699
2007 to 2003 formatting troubleshooting Dave H	by Dave H	0	487
How to determine what is causing large size Dave H	by Jim Thomlinson	1	2,173
Pivot Table Difference Columns Dave H	by Dave H	0	1,173
summing a table based on a cell reference? Dave H	by Dave H	0	1,265
SUMIF alternative Dave H	by XLS S	3	1,002
Excel 2013 shift end down Dave H	by mikerickson	1	1,150
Sum of selected cells ? Dave H	by RagDyeR	2	658
How to open without losing data? Dave H	by Dave H	2	402
Linking Tab Name to a Cell Dave H	by Gord Dibben	3	354
Macro hanging up on 2nd use and later. Dave H	by Dave H	2	433
MSQuery editing source data? Dave H	by Dave H	0	394
Default Cell Value with Validation Drop-Down List Dave H	by Dave H	0	1,398
How do I pause a macro? Dave H	by HOBOBOAT	5	1,500
unable to read file Dave Hall	by Dave Hall	0	805
Formula to change figures into words Dave Hebert	by G McPherson	2	600
Formula: figures to words Dave Hebert	by Steve[_13_]	1	609
formula to change figures into words Dave Hebert	by Bob Phillips	3	819
Lookup multiple criteria for a single result Dave H[_3_]	by Herbert Seidenberg	1	778
Opening Symphony Files Dave I,m too old for this	by Dave I,m too old for this[_2_]	2	684
File Open display in Excel 2007 Dave iii	by Dave Peterson	2	494
IF statements Dave in Ampthill[_2_]	by Stefi	3	351
merging sheet data Dave in Ampthill[_2_]	by Dave in Ampthill[_2_]	1	413
Hot key for time? Dave in Des Moines	by CLR	1	1,156
how to use multiple regression Dave in naigeria	by Jerry W. Lewis	4	468