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,559
Naming a worksheet tab from a reference cell Finance Guru	by Luke M	2	591
Can't analyze web data willemeulen[_45_]	by willemeulen[_45_]	0	443
Excel 2007 -- SUMIFS v SUMPRODUCT MurrayBarn	by Jacob Skaria	4	875
Cell value determined by the current time and date jschae	by Jacob Skaria	4	531
Problem with Syntax? MurrayBarn	by MurrayBarn	8	451
Go to a chosen worksheet Bob[_16_]	by Jacob Skaria	1	350
macro to grab current workbook filename TR Young	by Eduardo	3	2,035
Help: Assigning a "word" a numerical value Eric	by Jacob Skaria	1	462
Less than, Greater Than, equal to conditional formatting Lee West	by Lee West	4	2,914
Countif cell is conditionally formatted RicG	by David Biddulph[_2_]	1	645
Hiding columns in Excel 2003 Les	by Harlan Grove[_2_]	2	665
Inverse wieghted average/ratio dtacotts	by Jim Cone[_2_]	1	1,413
Sums including #NAME? Fred Holmes	by Fred Holmes	2	326
Trying to highlight cells that have the same value as the active c Excel_Rookie	by Jacob Skaria	9	501
Remove last n rows Colin Hayes	by Colin Hayes	6	424
count number of occurances between 2 values Peters	by smartin	3	872
Sort Block of Data lab-guy	by CLR	3	427
How to import PDF into Excel? JoeU2004	by JoeU2004	1	821
Sumproduct with blanks EZ[_2_]	by EZ[_2_]	10	985
Eliminating Duplicates in Excel 2007 TÃ©	by TÃ©	2	407
How do I copy subtotaled data without underlying details in Excel Diletto	by Shane Devenshire[_2_]	1	623
How can I convert many rows of hyperlinks to BASE links? EnduroGal	by Shane Devenshire[_2_]	2	399
Need help with formula Donna	by Gord Dibben	2	343
How do I create a VERY complicated spreadsheet? Kerri	by Gord Dibben	1	765
delete numbers in each cell in same column Anna Huber	by RagDyer	7	660
Pivot across several tabs Tami	by Tami	2	336
Combo box selection will not calculate Perrysbox2	by T. Valko	1	437
What Formula to use? Paul Chung	by Paul Chung	6	556
How do I change date format m/d/yyyy to mmddyyyy toremove the dash CyndiR	by David Biddulph[_2_]	3	3,721
Subtotals from Named Range on other worksheet sgodschalk	by Glenn	5	488
Importing newbo	by newbo	0	325
VBA Converter for Excel 2007 RBB	by Dave Peterson	1	889
Formula for rating results Nadine	by Nadine	4	701
standings Kashyap	by Justin Case	3	313
Using the "Count" function with filters? Irv	by icsonu	13	1,074
Conditional Formatting Based on Due Dates Morgimo	by Morgimo	3	760
Summing data based on certain cells MurrayBarn	by RagDyeR	4	601
Updating & Archiving Records sandy	by sandy	4	356
IF with #N/A Rahim	by Shane Devenshire[_2_]	3	331
SUMPRODUCT PAL	by PAL	4	411
Using Multiple Criteria to filter for multiple users fgwiii[_2_]	by Luke M	5	656
Conditional formatting from Dates DavidM	by David Biddulph[_2_]	3	543
Restrict data entry to specified cells ajsguinness	by ajsguinness	2	645
Problem with Using "Multiply by 1" A	by A	5	368
IF or VLOOKUP - help please ..... EÃ¡n[_2_]	by Roger Govier[_3_]	4	322
If or VLOOKUP EÃ¡n[_2_]	by Simon Lloyd[_268_]	4	421
Internet Explorer opens jpeg from a hyperlink ??? Roman	by Roman	0	525
HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003? TEJAS SHAH	by Jacob Skaria	3	3,405
Give me a Function Fareez	by Eduardo	1	990
use sumif / Sumproduct for year data Chris26	by Jacob Skaria	5	546
Display 2 worksheets simultaneously Kent	by Kent	2	748
Counting in columns Deb	by ytayta555	5	411
How to create one additional warning flag into my logic? Danny Boy	by Roger Govier[_3_]	1	477
Formula and worksheet will not working properly nathanv3223[_3_]	by Simon Lloyd[_264_]	7	667
excel Beautiful	by JLatham	3	366
need lookup help Mike Coleman	by Jacob Skaria	3	385
Fitting data with a negative exponential [email protected]	by [email protected]	0	1,727
default border color DeAna	by DeAna	2	1,207
excel bbillybax	by Gord Dibben	1	360
how do i count using two criteria IHF	by David Biddulph[_2_]	3	583
Bin Array--Frequency Excel User	by Domenic[_2_]	1	1,513
Count w/ multiple variables & text values king60611	by T. Valko	5	1,222
Multiple function queries in same cell Donna	by Donna	2	431
Auto Assigning Number to Excel Invoice Angela Rose	by Gord Dibben	5	1,682
undo feature non-functioinal in Excel Bonnie P	by Bonnie P	0	351
IF _Different Values- Rick.	by Bernie Deitrick	1	370
Percentage of a count data in Pivot table Krish	by Krish	0	1,398
If specific # of certain characters in a range, "OK", if not "Aler Steve	by T. Valko	4	561
how to use data table steve	by steve	3	385
Test whether formula in cell is an expression or a number/text Fred Holmes	by T. Valko	3	633
YTD budget formula based on current actual input Sanj	by Ashish Mathur[_2_]	4	3,795
Please help Nina	by Ashish Mathur[_2_]	2	348
Ranking Question PJFry	by T. Valko	3	483
Entering time C	by T. Valko	1	458