Excel Worksheet Functions - Page 296

Thread / Thread Starter	Last Post	Replies	Views
How do I copy cells from one worksheet to another based on values Vickynh	by Ashish Mathur[_2_]	2	417
Countif or Sumproduct problem becknarr	by Ashish Mathur[_2_]	7	550
Multiple Spreadsheet,Not sure what to use? Vlookup works for first Getz	by Ashish Mathur[_2_]	5	482
vlookup returns wrong answer (off by one row) BAA	by Getz	2	4,779
Setting Parameters for SUMPRODUCT Results J and N	by J and N	2	947
Conditional Formula Based On A Check Box Brad Wolosz	by T. Valko	1	974
Stock quotes in Excel JD	by Cathy	6	949
Corrupt files windows xp sunnydazy	by Gord Dibben	2	748
How do I write inclined text in a picture in excel sheet? kailas	by Gord Dibben	2	1,139
credit card payoff worksheet toombstone	by Sean Timmons	2	1,402
Formula question iarnold	by Rick Rothstein	6	450
Difficult formula question JRD-CFW	by JRD-CFW[_2_]	7	607
Need to know formula to make expire in a year. tlbailey79	by David Biddulph[_2_]	5	1,325
Pull all correponding data when summarizing cindyk	by Pete_UK	3	493
Getting a dash wjen updating a formula Mac	by Dave Peterson	8	955
If and or [email protected]	by Sean Timmons	3	448
difficult formula question Joann	by T. Valko	4	525
Sum of a range of absolute numbers SteveG[_3_]	by SteveG[_3_]	4	441
Help me solve this problem I've been struggling with for so long! BjÃ¸rn	by Per Jessen[_2_]	5	449
Timesheets Angie	by Sean Timmons	3	511
Date pasted web site causing inconsistent date format lilhoot	by lilhoot	3	884
: In Access( Excel), how can I convert currency to words? fadil	by Wigi	1	452
Conditional formatting on Date Rick1	by Rick1	5	495
Calculating pay-off time for Credit Card? Robert Blass	by Robert Blass	8	4,307
how do i know date after no. of working days sudheer	by Sean Timmons	6	601
Removing data entries but not formulas or formats JD	by Sean Timmons	3	461
Delete a string Joe Gieder	by Mike H	5	437
IF checkbox is checked/unchecked, Cell.value = yes/no James	by John C[_2_]	3	3,338
Pivotting - T. Valko Bigfoot17	by T. Valko	1	441
Pivotting - Formula w/ Varying Column Bigfoot17	by T. Valko	7	576
counting unique items within categories Btaylor64	by Domenic[_2_]	7	518
Excel function help Corey	by David Biddulph[_2_]	6	477
auto entry from one worksheet to another Laura	by Sean Timmons	1	469
XL2000 Averaging Problems Continue... LPS	by LPS	4	348
counting ranges with multiple variables GAIDEN	by GAIDEN	2	558
Calculating over Multiple Columns Ken	by Ken	3	478
Convert currency within column Stephanie	by ~L	1	421
Adding multiple cells meeting criteria Mike	by Max	4	825
Grouping Rows Seftyby	by Teethless mama	1	461
Excel counts 2 digit numbers as 1... Brile	by Brile	5	1,004
Two vlookup questions D.Jessup	by Bernie Deitrick	5	629
Summarise Multiple Worksheets Louise	by Pete_UK	8	570
Excel Worksheet mehrshad	by mehrshad	0	391
Copying from one sheet to another Seftyby	by Seftyby	7	386
How do in perform trial and error method in excel? Raajesh	by David Biddulph[_2_]	1	3,033
Using a Max Subtotal a Formula LindaD	by Pete_UK	5	550
Find the row number of name occurence [email protected]	by [email protected]	9	799
makig report in exxcel bmurlidhar	by Ashish Mathur[_2_]	3	332
Problem with using Vlookup formula Montu	by Montu	4	447
Is it possible to treat and display a #div/0 error as a zero? Andrew	by Max	4	2,079
Erratic display of concatenation Colin Hayes	by Harlan Grove[_2_]	3	562
Creating a dynamic range always using the last 10 rows of data yak141	by Roger Govier[_3_]	3	610
A What-if scenario changing one figure to work out another ExcelNovice1	by ExcelNovice1	4	626
How do I use the value in a text box to change a cell value? McGuff	by Dave Peterson	3	451
GETPIVOTDATA function returning 0 not #REF Steven Cheng	by Steven Cheng	0	654
Headers & Footers Liz F	by Ashish Mathur[_2_]	3	454
Drop Down lists Debbie	by Ashish Mathur[_2_]	2	469
COUNTIF AND COUNTIF Dave	by Ashish Mathur[_2_]	2	516
Date LookUp Jordan	by Ashish Mathur[_2_]	3	413
Can I use a formula to identify WHICH row contains specific data? ExcelTrouble	by Ashish Mathur[_2_]	2	468
Find a word in a table, then use a function Alonso[_2_]	by Pete_UK	3	416
what's the function to return a sheetname in a cell in Excel? judi	by Gord Dibben	3	591
Recording a macro to change item selected in drop down list Jen	by Jen	2	1,725
vlookup retunrning a match, when not a match... Dave Peterson	by mark	1	655
Get next THU date based on date entered in another cell Munchkin	by Peo Sjoblom[_2_]	1	522
Calculating weekly averages from a new sheet JD	by RagDyer	5	422
vlookup retunrning a match, when not a match... mark	by Sheeloo[_2_]	4	733
HYPERLINK() Help PCLIVE	by Dave Peterson	1	397
Check Box Formulae Gaffnr	by Dave Peterson	5	611
duplicate drop down lists KJ	by KJ	2	418
copy a range Dave	by Gord Dibben	3	392
Vlookup-table array runs? chili	by Gord Dibben	2	793
vlookup retunrning a match, when not a match... Niek Otten	by Niek Otten	0	560
Condition Formatting based on If Then Kyle	by Kyle	0	482
summing only positive or negative values Daniel Collison	by Rick Rothstein	1	653