Excel Worksheet Functions - Page 75

Thread / Thread Starter	Last Post	Replies	Views
Find cell value within table caroline	by caroline	2	658
If yes then display information in cell Frustrated	by Frustrated	2	5,649
Sumproduct error Gotroots	by Fred Smith[_4_]	8	585
Display information being cut short Frustrated	by Dave Peterson	1	541
saving a spreadsheet with form controls ld	by ld	0	477
Create a formula in a worksheet that links two other worksheets John	by John	0	594
Formatting issue Iriemon	by Iriemon	2	571
How to delete columns with headings but rows are empty Deb[_4_]	by Mike H	2	620
Indirect function with national language catherine	by Stefi	7	2,287
Linking item between two worksheets CD	by Max	1	676
Index, Match, Lookup HELP PLEASE! goodgirlinterrupted	by goodgirlinterrupted	4	424
Populating a range from tab b into tab a Xman	by Luke M[_4_]	1	530
Sorting complex worksheets Mark	by Per Jessen	1	710
Should be simple Gotroots	by Gotroots	1	432
X Factor into Percent... Joseph Hand	by Pete_UK	3	460
How do i change a digit into word i,e 1 = one HARI KRISHNA	by Jacob Skaria	1	729
Add another value to a named range Rich	by Rich	0	554
Capturing Real Time Data Rob	by Rob	2	915
replace a single character WITH FORMAT in a cell ela	by Ron Rosenfeld	9	1,492
Sorting failure ela	by ela	2	447
Offset/Match Double Lookup LCW	by LCW	4	1,930
What function to use? Len? mklafert	by Max	11	1,215
Worksheets Donna[_2_]	by Dave Peterson	1	454
functions quit working Toby John	by David Biddulph[_2_]	2	448
obtaining data from a table Chau	by Fred Smith[_4_]	1	477
obtaining data in text form from a table Chau	by Fred Smith[_4_]	1	442
Instructions on how to use macros Sophie	by John[_22_]	1	411
Hiding/Unhiding Rows Automatically Brad Resnick	by Don Guillett[_2_]	1	476
Reverse word Amnon Wilensky	by Amnon Wilensky	3	767
Last value in column before blank craig	by T. Valko	10	1,072
moving row data to a colunm in sorted order moving row data to a column in a sorted	by Max	9	588
counting cells rbwn54	by T. Valko	3	330
Adding values that fall between 2 dates Dwells	by T. Valko	3	778
SUMIF Help RLock13	by T. Valko	1	434
Copy formulas from one workbook to another Ming[_2_]	by tech1NJ	1	1,314
counting the number of times shown klh84	by Gary''s Student	3	627
Can these look ups be done using Worksheets functions Jan Kronsell	by Bernie Deitrick	6	593
Custom Spreadsheet Properties Rod	by Rod	0	565
Use of "AND" Wally	by Pete_UK	2	508
#REF errors in links srinivasan	by srinivasan	0	420
How do I round Up to in Millions? Biju V	by Glenn	1	1,989
Pivot Table accessing data from OLAP cube Neha Sachdeva	by Neha Sachdeva	0	670
Pocket Excel Carol D'Souza	by Carol D'Souza	0	539
rounding up to the nearest 1000 tonia	by Mike H	1	1,035
sumproduct - find text in string BeSmart	by T. Valko	8	1,001
Division of all cells by a common number Icegirl	by Luke M	3	1,543
Conditional Formatting - Thick Border? fedude	by RabidExcel	6	2,980
Sum If - 2 conditions penguin77	by JLatham	2	396
how to undo scrolling tied to a single cell Tom	by JLatham	1	548
Counting the lack of a union of two lists Skippy Howenstein	by Rick Rothstein	2	412
How to run an event upon changing the value of a specific cell? Wael Fathy	by Luke M	1	531
Get all sheets names in one sheet Need Macro::Consolidating 500 sheets in	by Eduardo	1	1,160
How can I SUMIF between rows rather than columns? Robnarc	by Bernard Liengme[_2_]	2	961
If formula Horacio[_4_]	by Horacio[_4_]	4	455
percentage of green cells in list rslc[_3_]	by rslc[_3_]	3	556
Countif Limitations Booey	by Bernd P	3	1,249
My Excel operates as if Ctrl is always depressed. Help! parsochr	by Bob Bridges[_2_]	1	593
FIX FOR =N/A errors from EOMONTH Drew[_5_]	by Drew[_5_]	0	452
If data present, then display graph. Solomon	by Ashish Mathur[_2_]	2	1,148
Counting NON-Blank fields Phyllsf	by tompl	2	886
v look up Donna[_2_]	by Donna[_2_]	1	402
Excel "IF" functions Katrina	by Fred Smith[_4_]	1	354
Sum with multiple conditions Curtis	by Max	6	622
How do I use Excel to convert feet to kilometers? CedarHillMatt	by FSt1	3	2,498
Insert a semicolon in lieu of ALT Enter Access Joe	by Access Joe	4	1,264
Protecting/Unprotecting all sheets with macro leads to "image" iss MikeR	by MikeR	3	855
How to Sum Time in Hours & Minutes Teri	by T. Valko	9	1,024
changing a calculation in a pivot table pat67	by pat67	0	518
Forms Rosie	by Gord Dibben	1	429
How do I print my spreadsheet to show the formulas of a cell? Donna	by Gord Dibben	3	524
Extracting the latest info from 1st sheet and placing into a 2nd s tech1NJ	by Glenn	1	483
Locating values in a range and bringing up the corresponding price Zuo	by Zuo	3	493
Help simplifying a formula with multiple if's added together... Marc T	by Daryl S	7	544
Macro help - Investor sheet Goaliemenace	by Goaliemenace	2	416
Merge data from two separate tables brownmre	by Duke Carey	1	581