Excel Worksheet Functions - Page 1109

Thread / Thread Starter	Last Post	Replies	Views
Counting the lack of a union of two lists Skippy Howenstein	by Rick Rothstein	2	392
how to undo scrolling tied to a single cell Tom	by JLatham	1	537
Sum If - 2 conditions penguin77	by JLatham	2	388
Conditional Formatting - Thick Border? fedude	by RabidExcel	6	2,898
Division of all cells by a common number Icegirl	by Luke M	3	1,537
sumproduct - find text in string BeSmart	by T. Valko	8	958
rounding up to the nearest 1000 tonia	by Mike H	1	1,023
Pocket Excel Carol D'Souza	by Carol D'Souza	0	529
Pivot Table accessing data from OLAP cube Neha Sachdeva	by Neha Sachdeva	0	646
How do I round Up to in Millions? Biju V	by Glenn	1	1,978
#REF errors in links srinivasan	by srinivasan	0	415
Use of "AND" Wally	by Pete_UK	2	497
Custom Spreadsheet Properties Rod	by Rod	0	552
Can these look ups be done using Worksheets functions Jan Kronsell	by Bernie Deitrick	6	581
counting the number of times shown klh84	by Gary''s Student	3	617
Copy formulas from one workbook to another Ming[_2_]	by tech1NJ	1	1,306
SUMIF Help RLock13	by T. Valko	1	422
Adding values that fall between 2 dates Dwells	by T. Valko	3	746
counting cells rbwn54	by T. Valko	3	315
moving row data to a colunm in sorted order moving row data to a column in a sorted	by Max	9	583
Last value in column before blank craig	by T. Valko	10	1,062
Reverse word Amnon Wilensky	by Amnon Wilensky	3	758
Hiding/Unhiding Rows Automatically Brad Resnick	by Don Guillett[_2_]	1	459
Instructions on how to use macros Sophie	by John[_22_]	1	399
obtaining data in text form from a table Chau	by Fred Smith[_4_]	1	418
obtaining data from a table Chau	by Fred Smith[_4_]	1	468
functions quit working Toby John	by David Biddulph[_2_]	2	437
Worksheets Donna[_2_]	by Dave Peterson	1	433
What function to use? Len? mklafert	by Max	11	1,205
Offset/Match Double Lookup LCW	by LCW	4	1,909
Sorting failure ela	by ela	2	434
replace a single character WITH FORMAT in a cell ela	by Ron Rosenfeld	9	1,472
Capturing Real Time Data Rob	by Rob	2	892
Add another value to a named range Rich	by Rich	0	549
How do i change a digit into word i,e 1 = one HARI KRISHNA	by Jacob Skaria	1	723
X Factor into Percent... Joseph Hand	by Pete_UK	3	456
Should be simple Gotroots	by Gotroots	1	426
Sorting complex worksheets Mark	by Per Jessen	1	698
Populating a range from tab b into tab a Xman	by Luke M[_4_]	1	513
Index, Match, Lookup HELP PLEASE! goodgirlinterrupted	by goodgirlinterrupted	4	411
Linking item between two worksheets CD	by Max	1	671
Indirect function with national language catherine	by Stefi	7	2,267
How to delete columns with headings but rows are empty Deb[_4_]	by Mike H	2	605
Formatting issue Iriemon	by Iriemon	2	563
Create a formula in a worksheet that links two other worksheets John	by John	0	584
saving a spreadsheet with form controls ld	by ld	0	464
Display information being cut short Frustrated	by Dave Peterson	1	534
Sumproduct error Gotroots	by Fred Smith[_4_]	8	577
If yes then display information in cell Frustrated	by Frustrated	2	5,607
Find cell value within table caroline	by caroline	2	651
Help with a really big IF statement Emmaly	by T. Valko	9	799
Vlookup Arsenal Lady 09[_2_]	by T. Valko	2	416
Replacing a data range in a nested array function Julie	by T. Valko	1	550
Problem in displaying number hsg	by hsg	4	471
Multiple lists in a cell Xman	by Eduardo	1	465
Round Function duketter	by Joe User[_2_]	5	526
Finding the cell loacation that matches a specific value in a rang Zuo	by Zuo	3	2,138
Conditional Format Pam[_3_]	by Pam[_3_]	1	405
tracking changes in excel in an unshared workbook Clerk	by Otto Moehrbach[_2_]	1	733
formula range doesn't update for new rows lharp21	by Max	1	748
Linked Files cause large file sizes when saved Steve[_24_]	by Steve[_24_]	0	626
Cell formula that will give back the address of the cursor? Byron	by T. Valko	1	1,211
Aging Report JoeM[_3_]	by Fred Smith[_4_]	7	814
List of Contents by Criteria RoadKill	by Fred Smith[_4_]	3	463
Calculate Loan Term Joe User[_2_]	by Joe User[_2_]	0	2,845
Conditional formatting with dates GeneWan	by CellShocked	2	501
Links to Dynamic Named Range = Problem Code Numpty	by CellShocked	8	853
Entering a Value & Updating the Next Empty Cell in a Range Stilltrader47	by Stilltrader47	6	967
Converting text format of time/date into Excel time/date for subtr YY san.[_2_]	by David Biddulph[_2_]	6	2,596
Finding the corresponding value in a range? Zuo	by Fred Smith[_4_]	4	743
Count for text Pran	by Rohinikumar	4	455
Comment Edit Outook Calendar Problem	by Outook Calendar Problem	1	399
Can multiple criteria be used for IF formulas? CHaney	by Joe User[_2_]	1	415
VLOOKUP - Not returning the proper number (Caro) Caroline	by Niek Otten	1	727
Create a formula by joining text and the value from a formula Jesper Audi	by Jesper Audi	3	534