Excel Worksheet Functions - Page 369

Thread / Thread Starter	Last Post	Replies	Views
Extracting part of a cell [email protected]	by Gord Dibben	6	816
Only adding nonzeroes BryGuy77	by Gord Dibben	2	287
Vlookup for different columns in worksheet Haz	by Max	6	531
Transpond one very long column to several columns of specified len Magnus	by Max	5	1,156
Suggestions for Excel / Access interaction? Malvaro	by Malvaro	0	349
auto saving & closing file prtcorvette	by Spiky	1	350
sumif Sue	by Bob Phillips	3	306
complex function----Help! narp[_2_]	by Marcelo	5	371
converting text to numbers northerner	by Marcelo	4	282
Excel SUMIF formula statisfying two conditions Eva L	by Marcelo	8	411
password protecting cell in a protected file that are not protecte prtcorvette	by [email protected]	1	348
budget forecasting bridgeman	by bridgeman	0	336
Using VLOOKUP results in a DSUM criteria range bluefish	by bluefish	2	1,417
Lookup & Match question Learn-more	by T. Valko	3	340
How can you sort an Excel table by the color a row is shaded? Mack	by mikebres	1	343
Conditional Formatting Formula bdmatlock	by bdmatlock	5	403
custom data validation Gareth[_2_]	by Gareth[_2_]	4	647
filtering dates in order Dawn	by Hardeep_kanwar[_2_]	3	366
IF & VLOOKUP Carolina	by Pete_UK	4	518
use cell text in lookup function rsmith	by rsmith	3	746
Function neede which checks if a value in a cell is in a defined s LastPhilippe	by Marcelo	3	432
converting text to numbers northerner	by Marcelo	4	441
Lookup from a list of numbers Dean	by Dean	2	381
conditional change to absolute COB	by COB	2	627
Excel 2003 - sort by more than 3 criteria? outlook user needs shelp	by Pete_UK	1	612
LookUp CherylH	by Spiky	1	259
converting text to numbers northerner	by Spiky	2	424
Why does "Show Formulas" in Excel 2007 lock column alignment Collingwood	by Spiky	1	891
paste-special-All qrjhaik	by Spiky	4	342
Excel - count the number of records between two specific dates. DK	by DK	4	1,329
change content of a given cell as different cells are indicated sarah	by Pete_UK	1	552
How can I convert text to number? northerner	by Niek Otten	1	358
Subtract two columns, but only for cells identified by if statemen Amanda	by Bob Phillips	11	1,058
can i automaticity sort data in a table allan	by Judy Rose	3	434
Find the figur that are represented most times in at list Palle korsholm	by Gary''s Student	1	400
COUNTIF with text criteria Alexey[_3_]	by Alexey[_3_]	2	1,417
Conditional sums GTIGUY	by Max	1	380
VLOOKUP help needed.!! RickJB	by Max	3	378
VLOOKUP AP	by AP	2	296
how do i auto copy the result of a filter ddt	by ddt	0	400
if function help Haz	by Pete_UK	3	366
Enter number in a cell and it is to display time. Peter	by Dave Curtis	2	569
CF 2007 - Highlight entire row based on one cell BryGuy77	by David Biddulph[_2_]	1	1,174
how many inbedded if statements can i have? Brooke	by T. Valko	5	465
delete color cells climate	by climate	4	1,055
How to create & delete sheets in a shared Excel workbook? Gemma @ Sweeney	by Gemma @ Sweeney	0	1,168
Holding the result of a formula constant or frozen Jumbo Jock	by eliano	1	361
Nested Functions in Excel2003 BDUB	by Teethless mama	1	323
De-identify data Eilean	by Eilean	2	6,177
COPY DOWN INCREASING WORKSHEET REFERENCE BY 1 robzrob	by robzrob	10	802
Steps to performing R2 function with excel ICP Jon	by Jim Cone[_2_]	3	1,491
Compare text in 2 separate spreadsheets, when match found display cocoblue	by cocoblue	3	559
Office web component . Ermias	by Ermias	0	615
multiple Hyperlinks one Excel cell? Jody	by Dave Peterson	4	3,506
Named Ranges in Array Formulas jfitzpat	by jfitzpat	2	813
Picking a value from a table using Column and Row ranges? James Dalton[_2_]	by James Dalton[_2_]	2	766
Finding the Value of a range in another column and showing resulti TXDalessandros	by Bernard Liengme	1	389
Thanks Pete_UK & T. Valko... robzrob	by Pete_UK	1	478
vlookup TAK	by Pete_UK	8	587
linking workbooks Phillip2419	by Phillip2419	0	291
XIRR Problem Dkline	by Dkline	8	1,136
Excel 2003 vs Excel 2007 AuntGal	by AuntGal	0	277
Formula to place the same value in a specific number of cells flarunner	by flarunner	4	517
Table_Array arg for VLOOKUP TMac71	by ShaneDevenshire	1	370
IF-more than 7 arguments in Carolina	by Carolina	2	438
Sum If with two ranges and condition Nuno JÃ¡come	by RobinMass	6	822
Control tab Fairfax	by Gord Dibben	1	421
Excell is not allowing me to click onto a single cell. WHY? typeover	by Gord Dibben	1	701
Subtotal variable range JDaywalt	by vezerid	1	746
Extracting values from formulas servboss02	by T. Valko	3	413
HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS MickeyMouse	by David Biddulph[_2_]	2	384
How to truncate digits? Robert Blass	by Robert Blass	6	1,008
Summarizing data into different worksheet Liztd	by vezerid	1	581
Count times that are more than 5 minutes in a range from a newworksheet Lenchik	by T. Valko	1	659
Connect Two Cells Freshman	by T. Valko	3	1,042