Excel Worksheet Functions - Page 274

Thread / Thread Starter	Last Post	Replies	Views
Pulling information from multiple worksheets into one......... John	by Ron de Bruin	1	630
Variable Or Command str83dgeboi	by str83dgeboi	7	620
Reformat a date imported from another program Heather	by Dave Peterson	3	806
Text box character limit issue ~L	by ~L	0	1,246
lookup values vertically in a list and return the repeats April_2004	by Sheeloo[_3_]	1	787
Reference Sheets in a Vlookup Thomas Roos	by T. Valko	4	633
Macro to Protect Mult Sheets / but allow Pivot Tables... Chris	by Chris	0	707
Lookup value,return column heading MFM	by vezerid	4	802
Master Niklas	by Niklas	2	547
Formula for multiple criteria in a column. Bruce Benaway	by Rick Rothstein	1	494
How can I link data in three different cells? ck# date amount Shiela	by Thomas Roos	2	716
which formula? Match? IF? shay34	by shay34	4	795
borders to equal a numbers in another cell ForeverH	by ForeverH	0	554
Help with locating values in cells and caluculating Yossy	by Don Guillett	1	530
Countif with multiple criteria (incl. calculation) DLF1	by T. Valko	3	667
Auto Update Linked data Ingebelle''s	by Ingebelle''s	3	1,559
How can I adress diferent Sheets in same Book according to a cellv Tom N	by Tom N[_2_]	2	745
Sumif Satin	by Max	1	544
Formula help Aaron[_3_]	by Pete_UK	3	592
Best grade using MAX ...BETTER WAY? hilarys	by John C[_2_]	2	636
what is the best worksheet function to... dkholmes50	by Pete_UK	3	490
Returning Multiple Matches Adam Hodge	by Max	4	1,125
How do I create a drop-down menu to sort data? Katalio	by Katalio	5	4,249
Complex conditional formatting Brian_M	by Brian_M[_2_]	2	576
Working out a value within a certain month. Matt	by Glenn	14	1,465
CREATE CUSTOM SORT IN EXCEL Grayhair	by Mike H	2	553
Import External data from a Website MichaelRobert	by Don Guillett	6	816
how do I sum currency values in a row containing currency and uni. Eusebius	by Don Guillett	2	1,600
Vlookup not sufficient - suggestions for combining multiple matche m	by Mike H	7	598
Parsing one part of an address LSSR	by Pete_UK	4	745
Formula in Excel kejak28	by Pete_UK	3	708
Autofill summary worksheet Cheryl	by Don Guillett	8	589
distribute the collaborators in 3 groups Alexandra Lopes	by Alexandra Lopes	5	683
Gauss Chart Alexandra Lopes	by Alexandra Lopes	2	1,212
VLOOKUP with date ranges The Cherub	by The Cherub	6	1,340
Count Records Simon	by Ashish Mathur[_2_]	5	603
Formula in excel Rhianne	by Pete_UK	3	498
VLOOKUP for this problem? Zakynthos	by Zakynthos	4	645
Change format of a date field Sageman	by Ashish Mathur[_2_]	7	605
SUMPRODUCT won't work on a row PFB	by Bob Phillips[_3_]	5	995
Find numbers lower / further than the previous (Track & Field) Mal/Betty	by Shane Devenshire[_2_]	2	611
create popup message Ann	by Razak	6	1,243
transfer data cell from another work sheet MDAM	by Ashish Mathur[_2_]	2	883
VLOOKUP formula Briggs	by Sheeloo[_3_]	3	536
Cheap Indian Chicks JellyFish	by JellyFish	0	580
Formula gone awry Connie Martin	by Sheeloo[_3_]	11	1,286
following the active cell address without recalc haystack	by haystack	3	1,112
Count how many times a phrase comes up? Deplywrker	by Shane Devenshire[_2_]	3	1,446
i need to get all matches in one column for one criteria PERANISH	by Ashish Mathur[_2_]	2	857
sumifs, sumif with dates Richard Manor	by Shane Devenshire[_2_]	6	1,452
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) Red Herald	by Ashish Mathur[_2_]	2	1,157
Countif with criteria NM	by Ashish Mathur[_2_]	11	1,219
Count Function Mickey	by Gary''s Student	5	722
Conditional formatting if a cell contains a formula tsbarr	by Ashish Mathur[_2_]	2	972
First Non-Blank Cell FrankM	by Gary''s Student	6	776
Query Wizard - Choose Columns MichaelRobert	by MichaelRobert	3	1,175
Solver Alonso[_2_]	by Dana DeLouis[_3_]	4	1,113
Run data analysis Papergal	by Dana DeLouis[_3_]	3	583
If 5th character="-" delete everything to the left otherwise do no Mike R.	by Rick Rothstein	6	1,209
Summarizing data assigned to a label Al Davis	by T. Valko	2	726
how do I round a column of numbers to the nearest Suzy	by T. Valko	3	1,781
Pivot table help Yossy	by Shane Devenshire[_2_]	1	627
If Than Statement Xfree	by Xfree	3	698
split print area in excel - One Page Print Cyhill	by Cyhill	3	3,398
Count with criteria NM	by NM	5	714
How do I re arrange numbers Raz	by Pete_UK	3	747
Help! Minimum Excluding zeros across multiple sheets [email protected]	by [email protected]	5	3,251
Second Saturday Of The Month FrankM	by Ron Rosenfeld	11	3,772
What's causing error message? Jim Tibbetts	by Peo Sjoblom[_2_]	4	892
Referencing an active cell's content from another sheet. emon	by emon	2	850
copy a cell value based on search of another cell Pendal	by Pete_UK	1	913
multiple ranges, transposing? Mea	by Herbert Seidenberg	19	1,572
Conditional format entire row from one cell Shanie	by Shane Devenshire[_2_]	2	677
cell lookup Excel Challenged	by John C[_2_]	2	523
IF AND statements bob	by John C[_2_]	6	711