Excel Worksheet Functions - Page 173

Thread / Thread Starter	Last Post	Replies	Views
change cell colour according to date..... RichLive	by Bernard Liengme[_3_]	2	1,589
Naming a worksheet tab from a reference cell Finance Guru	by Luke M	2	627
Can't analyze web data willemeulen[_45_]	by willemeulen[_45_]	0	470
Excel 2007 -- SUMIFS v SUMPRODUCT MurrayBarn	by Jacob Skaria	4	901
Cell value determined by the current time and date jschae	by Jacob Skaria	4	569
Problem with Syntax? MurrayBarn	by MurrayBarn	8	476
Go to a chosen worksheet Bob[_16_]	by Jacob Skaria	1	358
macro to grab current workbook filename TR Young	by Eduardo	3	2,063
Help: Assigning a "word" a numerical value Eric	by Jacob Skaria	1	485
Less than, Greater Than, equal to conditional formatting Lee West	by Lee West	4	2,959
Countif cell is conditionally formatted RicG	by David Biddulph[_2_]	1	665
Hiding columns in Excel 2003 Les	by Harlan Grove[_2_]	2	693
Inverse wieghted average/ratio dtacotts	by Jim Cone[_2_]	1	1,460
Sums including #NAME? Fred Holmes	by Fred Holmes	2	340
Trying to highlight cells that have the same value as the active c Excel_Rookie	by Jacob Skaria	9	533
Remove last n rows Colin Hayes	by Colin Hayes	6	456
count number of occurances between 2 values Peters	by smartin	3	904
Sort Block of Data lab-guy	by CLR	3	454
How to import PDF into Excel? JoeU2004	by JoeU2004	1	842
Sumproduct with blanks EZ[_2_]	by EZ[_2_]	10	1,002
Eliminating Duplicates in Excel 2007 TÃ©	by TÃ©	2	447
How do I copy subtotaled data without underlying details in Excel Diletto	by Shane Devenshire[_2_]	1	654
How can I convert many rows of hyperlinks to BASE links? EnduroGal	by Shane Devenshire[_2_]	2	430
Need help with formula Donna	by Gord Dibben	2	352
How do I create a VERY complicated spreadsheet? Kerri	by Gord Dibben	1	792
delete numbers in each cell in same column Anna Huber	by RagDyer	7	681
Pivot across several tabs Tami	by Tami	2	355
Combo box selection will not calculate Perrysbox2	by T. Valko	1	469
What Formula to use? Paul Chung	by Paul Chung	6	576
How do I change date format m/d/yyyy to mmddyyyy toremove the dash CyndiR	by David Biddulph[_2_]	3	3,848
Subtotals from Named Range on other worksheet sgodschalk	by Glenn	5	499
Importing newbo	by newbo	0	351
VBA Converter for Excel 2007 RBB	by Dave Peterson	1	926
Formula for rating results Nadine	by Nadine	4	724
standings Kashyap	by Justin Case	3	323
Using the "Count" function with filters? Irv	by icsonu	13	1,096
Conditional Formatting Based on Due Dates Morgimo	by Morgimo	3	792
Summing data based on certain cells MurrayBarn	by RagDyeR	4	632
Updating & Archiving Records sandy	by sandy	4	385
IF with #N/A Rahim	by Shane Devenshire[_2_]	3	354
SUMPRODUCT PAL	by PAL	4	424
Using Multiple Criteria to filter for multiple users fgwiii[_2_]	by Luke M	5	713
Conditional formatting from Dates DavidM	by David Biddulph[_2_]	3	570
Restrict data entry to specified cells ajsguinness	by ajsguinness	2	676
Problem with Using "Multiply by 1" A	by A	5	395
IF or VLOOKUP - help please ..... EÃ¡n[_2_]	by Roger Govier[_3_]	4	344
If or VLOOKUP EÃ¡n[_2_]	by Simon Lloyd[_268_]	4	444
Internet Explorer opens jpeg from a hyperlink ??? Roman	by Roman	0	555
HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003? TEJAS SHAH	by Jacob Skaria	3	3,466
Give me a Function Fareez	by Eduardo	1	1,029
use sumif / Sumproduct for year data Chris26	by Jacob Skaria	5	568
Display 2 worksheets simultaneously Kent	by Kent	2	772
Counting in columns Deb	by ytayta555	5	441
How to create one additional warning flag into my logic? Danny Boy	by Roger Govier[_3_]	1	502
Formula and worksheet will not working properly nathanv3223[_3_]	by Simon Lloyd[_264_]	7	695
excel Beautiful	by JLatham	3	397
need lookup help Mike Coleman	by Jacob Skaria	3	410
Fitting data with a negative exponential [email protected]	by [email protected]	0	1,786
default border color DeAna	by DeAna	2	1,238
excel bbillybax	by Gord Dibben	1	386
how do i count using two criteria IHF	by David Biddulph[_2_]	3	604
Bin Array--Frequency Excel User	by Domenic[_2_]	1	1,535
Count w/ multiple variables & text values king60611	by T. Valko	5	1,256
Multiple function queries in same cell Donna	by Donna	2	445
Auto Assigning Number to Excel Invoice Angela Rose	by Gord Dibben	5	1,703
undo feature non-functioinal in Excel Bonnie P	by Bonnie P	0	368
IF _Different Values- Rick.	by Bernie Deitrick	1	390
Percentage of a count data in Pivot table Krish	by Krish	0	1,429
If specific # of certain characters in a range, "OK", if not "Aler Steve	by T. Valko	4	594
how to use data table steve	by steve	3	405
Test whether formula in cell is an expression or a number/text Fred Holmes	by T. Valko	3	686
YTD budget formula based on current actual input Sanj	by Ashish Mathur[_2_]	4	3,824
Please help Nina	by Ashish Mathur[_2_]	2	365
Ranking Question PJFry	by T. Valko	3	498
Entering time C	by T. Valko	1	486