Excel Worksheet Functions - Page 369

Thread / Thread Starter	Last Post	Replies	Views
Extracting part of a cell [email protected]	by Gord Dibben	6	828
Only adding nonzeroes BryGuy77	by Gord Dibben	2	290
Vlookup for different columns in worksheet Haz	by Max	6	542
Transpond one very long column to several columns of specified len Magnus	by Max	5	1,182
Suggestions for Excel / Access interaction? Malvaro	by Malvaro	0	366
auto saving & closing file prtcorvette	by Spiky	1	366
sumif Sue	by Bob Phillips	3	311
complex function----Help! narp[_2_]	by Marcelo	5	383
converting text to numbers northerner	by Marcelo	4	284
Excel SUMIF formula statisfying two conditions Eva L	by Marcelo	8	415
password protecting cell in a protected file that are not protecte prtcorvette	by [email protected]	1	364
budget forecasting bridgeman	by bridgeman	0	338
Using VLOOKUP results in a DSUM criteria range bluefish	by bluefish	2	1,428
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	348
Conditional Formatting Formula bdmatlock	by bdmatlock	5	423
custom data validation Gareth[_2_]	by Gareth[_2_]	4	677
filtering dates in order Dawn	by Hardeep_kanwar[_2_]	3	377
IF & VLOOKUP Carolina	by Pete_UK	4	520
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	448
converting text to numbers northerner	by Marcelo	4	455
Lookup from a list of numbers Dean	by Dean	2	386
conditional change to absolute COB	by COB	2	648
Excel 2003 - sort by more than 3 criteria? outlook user needs shelp	by Pete_UK	1	621
LookUp CherylH	by Spiky	1	262
converting text to numbers northerner	by Spiky	2	427
Why does "Show Formulas" in Excel 2007 lock column alignment Collingwood	by Spiky	1	893
paste-special-All qrjhaik	by Spiky	4	347
Excel - count the number of records between two specific dates. DK	by DK	4	1,340
change content of a given cell as different cells are indicated sarah	by Pete_UK	1	579
How can I convert text to number? northerner	by Niek Otten	1	371
Subtract two columns, but only for cells identified by if statemen Amanda	by Bob Phillips	11	1,074
can i automaticity sort data in a table allan	by Judy Rose	3	452
Find the figur that are represented most times in at list Palle korsholm	by Gary''s Student	1	411
COUNTIF with text criteria Alexey[_3_]	by Alexey[_3_]	2	1,422
Conditional sums GTIGUY	by Max	1	385
VLOOKUP help needed.!! RickJB	by Max	3	389
VLOOKUP AP	by AP	2	298
how do i auto copy the result of a filter ddt	by ddt	0	423
if function help Haz	by Pete_UK	3	369
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,181
how many inbedded if statements can i have? Brooke	by T. Valko	5	486
delete color cells climate	by climate	4	1,069
How to create & delete sheets in a shared Excel workbook? Gemma @ Sweeney	by Gemma @ Sweeney	0	1,186
Holding the result of a formula constant or frozen Jumbo Jock	by eliano	1	367
Nested Functions in Excel2003 BDUB	by Teethless mama	1	327
De-identify data Eilean	by Eilean	2	6,204
COPY DOWN INCREASING WORKSHEET REFERENCE BY 1 robzrob	by robzrob	10	817
Steps to performing R2 function with excel ICP Jon	by Jim Cone[_2_]	3	1,497
Compare text in 2 separate spreadsheets, when match found display cocoblue	by cocoblue	3	576
Office web component . Ermias	by Ermias	0	635
multiple Hyperlinks one Excel cell? Jody	by Dave Peterson	4	3,516
Named Ranges in Array Formulas jfitzpat	by jfitzpat	2	831
Picking a value from a table using Column and Row ranges? James Dalton[_2_]	by James Dalton[_2_]	2	774
Finding the Value of a range in another column and showing resulti TXDalessandros	by Bernard Liengme	1	395
Thanks Pete_UK & T. Valko... robzrob	by Pete_UK	1	498
vlookup TAK	by Pete_UK	8	592
linking workbooks Phillip2419	by Phillip2419	0	296
XIRR Problem Dkline	by Dkline	8	1,147
Excel 2003 vs Excel 2007 AuntGal	by AuntGal	0	287
Formula to place the same value in a specific number of cells flarunner	by flarunner	4	526
Table_Array arg for VLOOKUP TMac71	by ShaneDevenshire	1	380
IF-more than 7 arguments in Carolina	by Carolina	2	459
Sum If with two ranges and condition Nuno JÃ¡come	by RobinMass	6	856
Control tab Fairfax	by Gord Dibben	1	431
Excell is not allowing me to click onto a single cell. WHY? typeover	by Gord Dibben	1	706
Subtotal variable range JDaywalt	by vezerid	1	759
Extracting values from formulas servboss02	by T. Valko	3	427
HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS MickeyMouse	by David Biddulph[_2_]	2	394
How to truncate digits? Robert Blass	by Robert Blass	6	1,025
Summarizing data into different worksheet Liztd	by vezerid	1	597
Count times that are more than 5 minutes in a range from a newworksheet Lenchik	by T. Valko	1	675
Connect Two Cells Freshman	by T. Valko	3	1,052