Excel Worksheet Functions - Page 369

Thread / Thread Starter	Last Post	Replies	Views
Extracting part of a cell [email protected]	by Gord Dibben	6	838
Only adding nonzeroes BryGuy77	by Gord Dibben	2	295
Vlookup for different columns in worksheet Haz	by Max	6	549
Transpond one very long column to several columns of specified len Magnus	by Max	5	1,195
Suggestions for Excel / Access interaction? Malvaro	by Malvaro	0	366
auto saving & closing file prtcorvette	by Spiky	1	377
sumif Sue	by Bob Phillips	3	311
complex function----Help! narp[_2_]	by Marcelo	5	391
converting text to numbers northerner	by Marcelo	4	292
Excel SUMIF formula statisfying two conditions Eva L	by Marcelo	8	425
password protecting cell in a protected file that are not protecte prtcorvette	by [email protected]	1	373
budget forecasting bridgeman	by bridgeman	0	341
Using VLOOKUP results in a DSUM criteria range bluefish	by bluefish	2	1,439
Lookup & Match question Learn-more	by T. Valko	3	343
How can you sort an Excel table by the color a row is shaded? Mack	by mikebres	1	359
Conditional Formatting Formula bdmatlock	by bdmatlock	5	423
custom data validation Gareth[_2_]	by Gareth[_2_]	4	678
filtering dates in order Dawn	by Hardeep_kanwar[_2_]	3	388
IF & VLOOKUP Carolina	by Pete_UK	4	527
use cell text in lookup function rsmith	by rsmith	3	768
Function neede which checks if a value in a cell is in a defined s LastPhilippe	by Marcelo	3	458
converting text to numbers northerner	by Marcelo	4	465
Lookup from a list of numbers Dean	by Dean	2	396
conditional change to absolute COB	by COB	2	650
Excel 2003 - sort by more than 3 criteria? outlook user needs shelp	by Pete_UK	1	621
LookUp CherylH	by Spiky	1	265
converting text to numbers northerner	by Spiky	2	434
Why does "Show Formulas" in Excel 2007 lock column alignment Collingwood	by Spiky	1	904
paste-special-All qrjhaik	by Spiky	4	348
Excel - count the number of records between two specific dates. DK	by DK	4	1,348
change content of a given cell as different cells are indicated sarah	by Pete_UK	1	587
How can I convert text to number? northerner	by Niek Otten	1	380
Subtract two columns, but only for cells identified by if statemen Amanda	by Bob Phillips	11	1,081
can i automaticity sort data in a table allan	by Judy Rose	3	462
Find the figur that are represented most times in at list Palle korsholm	by Gary''s Student	1	414
COUNTIF with text criteria Alexey[_3_]	by Alexey[_3_]	2	1,429
Conditional sums GTIGUY	by Max	1	391
VLOOKUP help needed.!! RickJB	by Max	3	395
VLOOKUP AP	by AP	2	305
how do i auto copy the result of a filter ddt	by ddt	0	433
if function help Haz	by Pete_UK	3	378
Enter number in a cell and it is to display time. Peter	by Dave Curtis	2	581
CF 2007 - Highlight entire row based on one cell BryGuy77	by David Biddulph[_2_]	1	1,188
how many inbedded if statements can i have? Brooke	by T. Valko	5	492
delete color cells climate	by climate	4	1,075
How to create & delete sheets in a shared Excel workbook? Gemma @ Sweeney	by Gemma @ Sweeney	0	1,187
Holding the result of a formula constant or frozen Jumbo Jock	by eliano	1	368
Nested Functions in Excel2003 BDUB	by Teethless mama	1	327
De-identify data Eilean	by Eilean	2	6,213
COPY DOWN INCREASING WORKSHEET REFERENCE BY 1 robzrob	by robzrob	10	823
Steps to performing R2 function with excel ICP Jon	by Jim Cone[_2_]	3	1,507
Compare text in 2 separate spreadsheets, when match found display cocoblue	by cocoblue	3	586
Office web component . Ermias	by Ermias	0	636
multiple Hyperlinks one Excel cell? Jody	by Dave Peterson	4	3,526
Named Ranges in Array Formulas jfitzpat	by jfitzpat	2	834
Picking a value from a table using Column and Row ranges? James Dalton[_2_]	by James Dalton[_2_]	2	785
Finding the Value of a range in another column and showing resulti TXDalessandros	by Bernard Liengme	1	400
Thanks Pete_UK & T. Valko... robzrob	by Pete_UK	1	498
vlookup TAK	by Pete_UK	8	599
linking workbooks Phillip2419	by Phillip2419	0	301
XIRR Problem Dkline	by Dkline	8	1,156
Excel 2003 vs Excel 2007 AuntGal	by AuntGal	0	296
Formula to place the same value in a specific number of cells flarunner	by flarunner	4	535
Table_Array arg for VLOOKUP TMac71	by ShaneDevenshire	1	380
IF-more than 7 arguments in Carolina	by Carolina	2	462
Sum If with two ranges and condition Nuno JÃ¡come	by RobinMass	6	858
Control tab Fairfax	by Gord Dibben	1	436
Excell is not allowing me to click onto a single cell. WHY? typeover	by Gord Dibben	1	709
Subtotal variable range JDaywalt	by vezerid	1	769
Extracting values from formulas servboss02	by T. Valko	3	435
HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS MickeyMouse	by David Biddulph[_2_]	2	399
How to truncate digits? Robert Blass	by Robert Blass	6	1,025
Summarizing data into different worksheet Liztd	by vezerid	1	606
Count times that are more than 5 minutes in a range from a newworksheet Lenchik	by T. Valko	1	684
Connect Two Cells Freshman	by T. Valko	3	1,064