Excel Worksheet Functions - Page 1065

Thread / Thread Starter	Last Post	Replies	Views
formatting a sentence with functions Josh Craig	by Josh Craig	2	430
SumProd from 2 columns and date range roy.okinawa	by roy.okinawa	6	575
Additional IF Function Pran	by Pran	4	434
function to retrieve array name Monty	by Jacob Skaria	6	488
how to insert rows inbetween rows of data ? Azeem	by Jacob Skaria	1	489
Unique records formula & zero entries jc132568	by T. Valko	9	567
Moving Average Elton Law[_2_]	by Elton Law[_2_]	8	499
Remove hyperlink in Excel worksheet Kent	by Kent	5	968
SumPRODUCT - calculating result?? Dhazmo	by Dhazmo	5	370
Round it off Sri Harsha[_2_]	by Jacob Skaria	3	417
To remove numbers in a cell with out using the macro Vital_ar	by Vital_ar[_2_]	2	1,122
Pivot Table Constraints EÃ¡n[_2_]	by EÃ¡n[_2_]	0	896
Regional settings Ana via OfficeKB.com	by David Biddulph[_2_]	1	714
IF(AND with date comparison PSU35	by PSU35	4	435
Array formulas slows spreadsheet Huggy	by T. Valko	6	436
any ideas if this can be done CarlM[_2_]	by CarlM[_2_]	2	519
How do I display data refresh date and time Shree	by Srivathsava Madhugiri	2	3,686
how do i sort my excel worksheet in miabelladolce	by BEOPS	8	459
Simple Q - Multiple IF (And) Statement [email protected][_2_]	by Glenn	1	377
Locate merged cells to sort on 3 columns Rob B	by Luke M	2	424
Linking a workbook to worksheets Ron Purpura[_2_]	by Jacob Skaria	1	526
Copy Transpose and Link Data Neil	by Jacob Skaria	1	1,189
V lookup CandiC	by Sean Timmons	1	405
If statements in a Vlookup. Gallarita	by Sean Timmons	2	394
Excel function bfrad	by bfrad	5	498
Conditional format a column based on value in a different column Friday	by Jacob Skaria	3	2,348
sumif Judith	by T. Valko	2	355
Right align positive and neg numbers using brackets around neg #s Terri	by Jacob Skaria	1	1,667
Can "COUNTIFS" be utilized to return unique values? ascottbag-hcm	by ascottbag-hcm	0	1,111
Can "countifs" be utilized to return a count of unique values? ascottbag-hcm	by Jacob Skaria	1	1,868
Conditional Formatting - comparison with another cell Jezza	by Sean Timmons	4	626
DATEDIF vs. simple difference wal	by wal	0	526
Vlookup array formula problem Zach	by Zach	2	792
Linking Cells MickNick	by Mike H	1	352
variable formula LP23294	by T. Valko	4	484
macro to sum select columns in all workseets within a workbook Jodie	by Jodie	2	1,231
Difficulty with Sum+IF Function Gmania-1980	by T. Valko	10	875
how do i combine text and formula calculation in same cell gsm	by T. Valko	3	1,263
count scheduled staff between hours jat	by amin	2	674
trim cells with space in betwen numbers in cell Morten	by Luke M	2	1,115
Return cell referance of the first cell that equals a value? Enginerd	by T. Valko	5	2,061
Data Validation SB	by Sean Timmons	1	429
howdoIaddcolumnsfor atotal eagerbvr	by Sean Timmons	2	377
sorting text with numbers wavers3	by Luke M	2	509
formula assistance needed Eric_in_EVV[_2_]	by Luke M	2	409
What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087) Dorothy	by Dave Peterson	3	2,152
multiple ranking (sorting), based on diff. criteria Eddy Stan	by Eddy Stan	0	574
Can COUNTIFS be utilized to return unique values? ascottbag-hcm	by Herbert Seidenberg	1	1,168
Overwrite All Cells in Column TKS_Mark	by TKS_Mark	2	4,604
fill a form with specific data Carla	by zvkmpw	7	624
counting how many employees are scheduled to work by hour amin	by barry houdini[_37_]	3	768
Vlookup on partial match Robert_L_Ross	by Pete_UK	1	1,255
Unique count in access carrie	by Ashish Mathur[_2_]	3	608
HOW CAN DUPLICATES BE DELETED,NOT FILTERED? naminel	by Dan	17	1,179
Whole month total vice daily roy.okinawa	by Jacob Skaria	2	456
CONSOLIDATE SHEETS Roger	by Jacob Skaria	1	474
Moving info from rows to columns Mary Lou[_2_]	by Jacob Skaria	2	415
Conditional Formatting Issues Dmox	by T. Valko	1	431
Sumif but taking a value Mosqui	by T. Valko	5	606
Extraction for Ashish Mathur Donna[_2_]	by Ashish Mathur[_2_]	1	371
Why does "=SUM(E4,E8,E11,E14,E17)" display as text? blessed grandma	by blessed grandma[_2_]	4	744
Function to display file name Elton Law[_2_]	by Elton Law[_2_]	2	790
resizing list width in combo box Astericz	by Astericz	0	1,311
Sum the last 21 cells David	by David	15	926
Statutory Hrs Calculation Accounting Student in BC, Canada	by Accounting Student in BC, Canada	0	422
Counting No of character in a string Chandrashekar B	by Jacob Skaria	1	449
1 equals 3 Ilona	by Pete_UK	2	370
some numbers to be blank bill gras	by Mike H	1	309
Calculate between start and end times Lloyd	by Jacob Skaria	2	577
Convert Text to Columns EÃ¡n[_2_]	by Jacob Skaria	1	451
Varied Results obtained using Index and Match in Excel 2003 and 2007 Krish	by Krish	0	694
Inserting comma(,) after every two digits of a number from right t Senapati	by Jacob Skaria	2	2,828
Dynamic drop down list Bala	by Eduardo	2	558
Count If EÃ¡n[_2_]	by Dave Peterson	4	382
Excel TRANSPOSE lolita	by lolita	0	547