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,580
Naming a worksheet tab from a reference cell Finance Guru	by Luke M	2	614
Can't analyze web data willemeulen[_45_]	by willemeulen[_45_]	0	459
Excel 2007 -- SUMIFS v SUMPRODUCT MurrayBarn	by Jacob Skaria	4	895
Cell value determined by the current time and date jschae	by Jacob Skaria	4	554
Problem with Syntax? MurrayBarn	by MurrayBarn	8	463
Go to a chosen worksheet Bob[_16_]	by Jacob Skaria	1	357
macro to grab current workbook filename TR Young	by Eduardo	3	2,056
Help: Assigning a "word" a numerical value Eric	by Jacob Skaria	1	470
Less than, Greater Than, equal to conditional formatting Lee West	by Lee West	4	2,947
Countif cell is conditionally formatted RicG	by David Biddulph[_2_]	1	656
Hiding columns in Excel 2003 Les	by Harlan Grove[_2_]	2	677
Inverse wieghted average/ratio dtacotts	by Jim Cone[_2_]	1	1,459
Sums including #NAME? Fred Holmes	by Fred Holmes	2	335
Trying to highlight cells that have the same value as the active c Excel_Rookie	by Jacob Skaria	9	520
Remove last n rows Colin Hayes	by Colin Hayes	6	443
count number of occurances between 2 values Peters	by smartin	3	896
Sort Block of Data lab-guy	by CLR	3	439
How to import PDF into Excel? JoeU2004	by JoeU2004	1	831
Sumproduct with blanks EZ[_2_]	by EZ[_2_]	10	1,001
Eliminating Duplicates in Excel 2007 TÃ©	by TÃ©	2	433
How do I copy subtotaled data without underlying details in Excel Diletto	by Shane Devenshire[_2_]	1	642
How can I convert many rows of hyperlinks to BASE links? EnduroGal	by Shane Devenshire[_2_]	2	417
Need help with formula Donna	by Gord Dibben	2	351
How do I create a VERY complicated spreadsheet? Kerri	by Gord Dibben	1	779
delete numbers in each cell in same column Anna Huber	by RagDyer	7	666
Pivot across several tabs Tami	by Tami	2	343
Combo box selection will not calculate Perrysbox2	by T. Valko	1	456
What Formula to use? Paul Chung	by Paul Chung	6	571
How do I change date format m/d/yyyy to mmddyyyy toremove the dash CyndiR	by David Biddulph[_2_]	3	3,837
Subtotals from Named Range on other worksheet sgodschalk	by Glenn	5	494
Importing newbo	by newbo	0	341
VBA Converter for Excel 2007 RBB	by Dave Peterson	1	913
Formula for rating results Nadine	by Nadine	4	712
standings Kashyap	by Justin Case	3	323
Using the "Count" function with filters? Irv	by icsonu	13	1,089
Conditional Formatting Based on Due Dates Morgimo	by Morgimo	3	781
Summing data based on certain cells MurrayBarn	by RagDyeR	4	619
Updating & Archiving Records sandy	by sandy	4	375
IF with #N/A Rahim	by Shane Devenshire[_2_]	3	344
SUMPRODUCT PAL	by PAL	4	423
Using Multiple Criteria to filter for multiple users fgwiii[_2_]	by Luke M	5	703
Conditional formatting from Dates DavidM	by David Biddulph[_2_]	3	560
Restrict data entry to specified cells ajsguinness	by ajsguinness	2	661
Problem with Using "Multiply by 1" A	by A	5	382
IF or VLOOKUP - help please ..... EÃ¡n[_2_]	by Roger Govier[_3_]	4	332
If or VLOOKUP EÃ¡n[_2_]	by Simon Lloyd[_268_]	4	430
Internet Explorer opens jpeg from a hyperlink ??? Roman	by Roman	0	551
HOW CAN CREATE THE PRICE RANGE IN EXCEL 2003? TEJAS SHAH	by Jacob Skaria	3	3,458
Give me a Function Fareez	by Eduardo	1	1,022
use sumif / Sumproduct for year data Chris26	by Jacob Skaria	5	564
Display 2 worksheets simultaneously Kent	by Kent	2	765
Counting in columns Deb	by ytayta555	5	439
How to create one additional warning flag into my logic? Danny Boy	by Roger Govier[_3_]	1	500
Formula and worksheet will not working properly nathanv3223[_3_]	by Simon Lloyd[_264_]	7	692
excel Beautiful	by JLatham	3	381
need lookup help Mike Coleman	by Jacob Skaria	3	400
Fitting data with a negative exponential [email protected]	by [email protected]	0	1,779
default border color DeAna	by DeAna	2	1,224
excel bbillybax	by Gord Dibben	1	371
how do i count using two criteria IHF	by David Biddulph[_2_]	3	591
Bin Array--Frequency Excel User	by Domenic[_2_]	1	1,527
Count w/ multiple variables & text values king60611	by T. Valko	5	1,244
Multiple function queries in same cell Donna	by Donna	2	439
Auto Assigning Number to Excel Invoice Angela Rose	by Gord Dibben	5	1,693
undo feature non-functioinal in Excel Bonnie P	by Bonnie P	0	359
IF _Different Values- Rick.	by Bernie Deitrick	1	380
Percentage of a count data in Pivot table Krish	by Krish	0	1,423
If specific # of certain characters in a range, "OK", if not "Aler Steve	by T. Valko	4	580
how to use data table steve	by steve	3	393
Test whether formula in cell is an expression or a number/text Fred Holmes	by T. Valko	3	676
YTD budget formula based on current actual input Sanj	by Ashish Mathur[_2_]	4	3,819
Please help Nina	by Ashish Mathur[_2_]	2	358
Ranking Question PJFry	by T. Valko	3	495
Entering time C	by T. Valko	1	477