Excel Worksheet Functions - Page 2

Thread / Thread Starter	Last Post	Replies	Views
Search, find or lookup defined text in text string zzxxcc	by Ron Rosenfeld	9	1,201
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t zzxxcc	by zzxxcc	2	2,227
How do I convert a cell(s) from the formula to it's contents? ZZBC	by Otto Moehrbach	9	532
How can I test if a Macro if firing? ZZBC	by ZZBC	6	481
Converting Text to Number ZZ top[_2_]	by ZZ top[_2_]	3	415
Format Changes 2007 ZZ top	by ZZ top[_2_]	2	411
Excel 2007 Function Qt zyzzyva	by Bob Bridges[_2_]	2	985
Problem converting Hours to Days, Hours, Minutes Zyzzx	by Zyzzx	4	2,433
Indirect.ext Zyvind	by Peo Sjoblom	3	570
Why do formulas turn to values wen copying in Excel 2003... zyphyl	by K.S.Warrier	1	1,052
Reply for Macropod Zygy	by Zygy	7	589
Negative Values Zygy	by broro183	4	337
YTD average cust calulation zy1972	by NoodNutt	3	678
Multi YTD Summary zy1972	by zy1972	3	443
How to get YTD Summary zy1972	by zy1972	4	1,366
Number of Specific Day within Dates zxcv[_2_]	by zxcv[_2_]	2	363
toolbar keeps coming back zxcv[_2_]	by zxcv[_2_]	1	591
#REF! error with Multiple Documents zxcvbnm6000	by zxcvbnm6000	7	626
=OR(IF(AND(....),HYPERLINK.... zx6roo	by Max	3	383
Index, match, multiple IFs query zx6roo	by Ashish Mathur[_2_]	9	1,915
under standing if statments zx12rbullet	by Gord Dibben	2	456
I can't open PDF files when using the hyperlink zwalbij	by zwalbij	12	4,644
Conditions zvroom	by Rick Rothstein	3	518
reorganising data zvonul	by Max	4	506
FLOATING CELLS zvone	by Peo Sjoblom	1	607
Inserting automatic text in Excel [email protected]	by hans bal(nl)	1	1,760
combining conditional formatting and functions zvi	by zvi	2	646
Why does the right 'Alt' key not work in Excel? zuzartej	by zuzartej	4	1,227
Adding a constant to a formula. Problems w/filling in zuri125	by Biff	4	508
a function that counts the number of cells with information zuri125	by VN	1	772
how to add values of cells only if a corresponding cell has information on it zuri125	by Ardus Petus	1	418
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? zurafz6	by Biff	7	1,156
Trouble With Data Validation And Filtering On A Dropdown zura04	by zura04	0	740
change operating cells dynamically according to the value of a fixed cell Zuohong	by Zuohong	2	938
Simple calculation where values change to letters? Zuo	by Zuo	3	667
Matching two sets of data? Zuo	by Zuo	5	593
Match value in one column and return value in same row in next col Zuo	by Zuo	2	1,973
Finding the corresponding value in a range? Zuo	by Fred Smith[_4_]	4	743
Finding the cell loacation that matches a specific value in a rang Zuo	by Zuo	3	2,138
Locating values in a range and bringing up the corresponding price Zuo	by Zuo	3	482
Copying data from 205 columns to 1 column Zuo	by Max	4	583
Satisfying two conditions? Zuo	by Fred Smith[_4_]	8	1,471
Changing a formula to read a general value? Zuo	by T. Valko	1	705
Fixing a formula to read a general format? Zuo	by Per Jessen[_2_]	1	510
How can I prevent users from linking to other sources in Excel? Zuni	by Barb Reinhardt	2	427
ACCRINTM() function Zumble	by Niek Otten	1	454
Excel - Convert int value secs past midnight into time 53100=2:45 Zuly	by ExcelBanter AI	2	9,621
Merge & Center function is turned off...how do I turn it back on? zulumaster	by Anne Troy	1	1,457
Ladder Help Zulu	by Zulu	2	357
Help with a Ladder Zulu	by Zulu	9	827
if negative figure Zul	by Dave	10	837
Help with IF zuketrax	by JMB	1	335
need an aswer- URGENT! zue	by Gord Dibben	2	317
Transpose multiple Columns to rows Zucco	by Max	8	886
add a column only if 5 other cells on the row satisfy criteria zubin	by Bob Phillips	1	560
Conditional Formatting Zubbus	by Stilla	2	352
Making an ouput file Zubair	by Zubair	1	456
Help on Prompt Zubair	by Zubair	0	604
Save as or export with values only Zubair	by Norman Jones	3	715
Arranging words in a column in dictionary wise order Zubair	by Ashish Mathur[_2_]	4	1,066
Prompt before updating values Zubair	by Zubair	0	618
Schedule an xl file Zubair	by arno	3	412
Multiple Dependent Drop Downs Zubair	by Zubair	0	455
Multiple Dependent Drop Down Zubair	by Zubair	1	655
Lookup Multiple Values Zubair	by T. Valko	7	591
Countif IsErr ZTamsen	by Bernd P	6	708
Index Match Max? Zsoup	by Kevin@Radstock	3	765
VLOOKUP IF Zsolt SzabÃ³	by [email protected]	1	376
NEED A COST SHEET TO TRACK TIME AND BUDGET -CONTRACTOR Zsolt	by Zsolt	0	538
Formula to multiply only a portion of a cell number? zsboppie	by zsboppie	4	1,187
Help! Replacing Existing Information with New Entries Zquip	by Gord Dibben	3	345
How batch calculations? ZPXY	by Rowan	2	1,517
how fill adatabasein domino designer with information of excel zoy	by zoy	0	489
Running total over a find number of days Zorro[_2_]	by Zorro[_2_]	15	1,212
Pictures in a worksheet ZorroZ	by ZorroZ	3	336