Excel Worksheet Functions - Page 183

Thread / Thread Starter	Last Post	Replies	Views
Lookup value then return result from other column, varying row num Justin	by Max	5	1,189
Formula does not calculate - Have tried F9 Anisette	by Gord Dibben	9	1,189
indirect.ext - "can't find project or library" error DDawson	by DDawson	0	1,189
get Pivot table to generate separate worksheets for each row? Matt D Francis	by Matt D Francis	2	1,189
Need a Function to Remove Text pemmert	by Peo Sjoblom	6	1,189
Copy Transpose and Link Data Neil	by Jacob Skaria	1	1,188
lock tab in sheet 2 until cell in sheet one is completed john tempest	by john tempest	7	1,188
Adding 6 Months to a Date Excel User	by Ron Rosenfeld	8	1,188
Lookup nearest value (Index & Match) [email protected]	by Domenic	1	1,188
extract first name only from full name KB916521 Junk Update Office 2003 -A	by PCLIVE	2	1,188
Test if CELL is in RANGE Vaughan	by Vaughan	12	1,188
Can I save custom headers and footers to use in other files? Gcwensel	by Holle	1	1,188
Problem with array and msgbox aking1987	by Bernie Deitrick	2	1,188
calculate backwards from agreed upon purchase price to SP inc tax rookie	by Toppers	2	1,188
Why is there no Freeze Panes option in the Windows drop-down box? PortNatal	by Gord Dibben	2	1,188
formula to count charcter in a range Dylan @ UAFC[_2_]	by Rick Rothstein	11	1,188
return value based on number of characters in cell / field Perplexed	by Shane Devenshire[_2_]	4	1,188
how can i sort on a perticular column for odd and even numbers [email protected]	by Shane Devenshire[_2_]	4	1,188
Formula to multiply only a portion of a cell number? zsboppie	by zsboppie	4	1,188
Average if and networkdays K	by T. Valko	1	1,188
YTD SUMIF based on current date garygoodguy	by garygoodguy	1	1,188
Searching a cell for a certain character. Matt	by Dave R.	3	1,188
Calculating interest on number of days in the period Ron	by Ron	0	1,188
Select part of a cell Joe	by Ken Wright	6	1,188
Change font size of Combo Box from Form tools tahir4awan	by Ron Rosenfeld[_2_]	6	1,188
COPYING CONDITIONAL FORMATTING TO A COLUMN Markitos	by Gord Dibben	1	1,188
MAKING A CONTRACT FROM DATA FROM A WORKSHEET MCNAB	by Bernie Deitrick	5	1,188
Insert a number of rows based on a value in a cell on active row iRocco	by iRocco	0	1,188
Sum Visible Cells Julie	by Pete_UK	5	1,187
Show the top three items in a list petenice81	by Tyro[_2_]	4	1,187
Create auto updating data validation list from all worksheet names fryguy	by Gord Dibben	7	1,187
intersection of two lines defined by points Leslie	by Leslie	7	1,187
Conditional Formatting with absolute references atljar	by RagDyer	3	1,187
Distribution of capital contribution wabbleknee	by wabbleknee	4	1,187
percentage of growth MayBee	by Gord Dibben	5	1,187
How can I get a total across multiple spreadsheets? Margaret McCullough	by Frank Kabel	1	1,187
Excel 2003, will not let me color fill cells rick	by CommerceMary	2	1,187
problem with formatting cell to date format Del	by Frank Kabel	7	1,187
VLookup with 2 criteria Meredith	by Ben Webman	6	1,187
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. ramana	by Rowan Drummond	5	1,187
When opening an excel file in Windows Explore, it opens to a grey. pwink44	by pwink44	2	1,187
Subtotals in Pivot Tables Fred Smith	by Debra Dalgleish	3	1,187
How to disable printing a specific worksheet? Efzed	by JE McGimpsey	1	1,187
Formula format for Count or Countif funtion with two criterias Debi	by Myrna Larson	2	1,187
Data (group And Outline) Junnies	by manderee	2	1,187
adding cells that contain formulas that have returned error messag Daniel R	by Roger Govier	3	1,187
Check column of dates against todays date Andrew82	by Bob Phillips	1	1,187
Can I add blank space instead of 'FALSE' in VLookup? smithers2002	by smithers2002	7	1,187
calculating % of a monthly budget on a daily basis DZ	by rzink	3	1,187
Remove text leading zero in text string Peo Sjoblom	by Peo Sjoblom	0	1,187
What is the formula for cube root on Excel? tbh_29	by Dana DeLouis	3	1,187
Macro to Delete blank cells GarToms	by Dave Peterson	1	1,187
How do I create a list (Word) of the names on Excel worksheet tabs PT[_2_]	by Gord Dibben	3	1,186
Two "IF" functions in one cell Sunny	by RagDyer	2	1,186
formula to look up ref in one sheet and offset in another vickya	by Dave Peterson	1	1,186
Nested IF & MAX Function Graham	by Graham	4	1,186
LOOKUP Function gives wrong results AndreasW	by Ashish Mathur[_2_]	4	1,186
I can't get Excel to caluate dates in the 1800's. #VALUE! KenB	by Niek Otten	1	1,186
how do I make a function to count days? khamsta	by tjtjjtjt	2	1,186
Extract date from cell Eric	by Ron Rosenfeld	3	1,186
Change Path names in copied work book jheaney	by Scott1523	2	1,186
How Excel & ACCPAC 6.1 calculate formulas???? Bass Mama1	by Bass Mama1	1	1,186
COUNTIF according to presence of string within text Ingeniero1	by Ingeniero1	5	1,186
If then formulas K	by K	12	1,186
formula in pivot tables involving counting text cells Gai	by Debra Dalgleish	1	1,186
If cellA is blank or 0 then cellB is blank ~Natasha~	by Frank Kabel	2	1,186
How do I add values only in odd numbered rows in Excel? baylor basketball	by excelent	2	1,186
Update Date Cell when any of target cells change DAKent	by DAKent	2	1,186
Automatic update of footer macro Greg	by Gord Dibben	2	1,186
FunÃ§Ã£o Logaritimica Moura	by Rodrigo Ferreira	2	1,185
show all characters in a cell tinks	by Gord Dibben	1	1,185
hyperlink - PDF file - relative reference eugene	by itsupport75.1	4	1,185
Finding subsequent matches Ker_01	by Alan Beban[_2_]	5	1,185
Round up by 0.5 if =.25, down to integer if <.25 [email protected]	by Luannguyen992	4	1,185
Show value of first non contiguous data Xxer Xxes	by Xxer Xxes	11	1,185