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	623
Variable Or Command str83dgeboi	by str83dgeboi	7	608
Reformat a date imported from another program Heather	by Dave Peterson	3	794
Text box character limit issue ~L	by ~L	0	1,235
lookup values vertically in a list and return the repeats April_2004	by Sheeloo[_3_]	1	772
Reference Sheets in a Vlookup Thomas Roos	by T. Valko	4	625
Macro to Protect Mult Sheets / but allow Pivot Tables... Chris	by Chris	0	688
Lookup value,return column heading MFM	by vezerid	4	780
Master Niklas	by Niklas	2	498
Formula for multiple criteria in a column. Bruce Benaway	by Rick Rothstein	1	485
How can I link data in three different cells? ck# date amount Shiela	by Thomas Roos	2	706
which formula? Match? IF? shay34	by shay34	4	775
borders to equal a numbers in another cell ForeverH	by ForeverH	0	549
Help with locating values in cells and caluculating Yossy	by Don Guillett	1	523
Countif with multiple criteria (incl. calculation) DLF1	by T. Valko	3	657
Auto Update Linked data Ingebelle''s	by Ingebelle''s	3	1,524
How can I adress diferent Sheets in same Book according to a cellv Tom N	by Tom N[_2_]	2	724
Sumif Satin	by Max	1	523
Formula help Aaron[_3_]	by Pete_UK	3	581
Best grade using MAX ...BETTER WAY? hilarys	by John C[_2_]	2	624
what is the best worksheet function to... dkholmes50	by Pete_UK	3	483
Returning Multiple Matches Adam Hodge	by Max	4	1,108
How do I create a drop-down menu to sort data? Katalio	by Katalio	5	4,231
Complex conditional formatting Brian_M	by Brian_M[_2_]	2	565
Working out a value within a certain month. Matt	by Glenn	14	1,443
CREATE CUSTOM SORT IN EXCEL Grayhair	by Mike H	2	535
Import External data from a Website MichaelRobert	by Don Guillett	6	805
how do I sum currency values in a row containing currency and uni. Eusebius	by Don Guillett	2	1,533
Vlookup not sufficient - suggestions for combining multiple matche m	by Mike H	7	590
Parsing one part of an address LSSR	by Pete_UK	4	728
Formula in Excel kejak28	by Pete_UK	3	689
Autofill summary worksheet Cheryl	by Don Guillett	8	578
distribute the collaborators in 3 groups Alexandra Lopes	by Alexandra Lopes	5	667
Gauss Chart Alexandra Lopes	by Alexandra Lopes	2	1,196
VLOOKUP with date ranges The Cherub	by The Cherub	6	1,314
Count Records Simon	by Ashish Mathur[_2_]	5	572
Formula in excel Rhianne	by Pete_UK	3	480
VLOOKUP for this problem? Zakynthos	by Zakynthos	4	624
Change format of a date field Sageman	by Ashish Mathur[_2_]	7	592
SUMPRODUCT won't work on a row PFB	by Bob Phillips[_3_]	5	971
Find numbers lower / further than the previous (Track & Field) Mal/Betty	by Shane Devenshire[_2_]	2	602
create popup message Ann	by Razak	6	1,234
transfer data cell from another work sheet MDAM	by Ashish Mathur[_2_]	2	878
VLOOKUP formula Briggs	by Sheeloo[_3_]	3	516
Cheap Indian Chicks JellyFish	by JellyFish	0	570
Formula gone awry Connie Martin	by Sheeloo[_3_]	11	1,276
following the active cell address without recalc haystack	by haystack	3	1,092
Count how many times a phrase comes up? Deplywrker	by Shane Devenshire[_2_]	3	1,433
i need to get all matches in one column for one criteria PERANISH	by Ashish Mathur[_2_]	2	845
sumifs, sumif with dates Richard Manor	by Shane Devenshire[_2_]	6	1,442
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) Red Herald	by Ashish Mathur[_2_]	2	1,148
Countif with criteria NM	by Ashish Mathur[_2_]	11	1,196
Count Function Mickey	by Gary''s Student	5	704
Conditional formatting if a cell contains a formula tsbarr	by Ashish Mathur[_2_]	2	941
First Non-Blank Cell FrankM	by Gary''s Student	6	770
Query Wizard - Choose Columns MichaelRobert	by MichaelRobert	3	1,167
Solver Alonso[_2_]	by Dana DeLouis[_3_]	4	1,097
Run data analysis Papergal	by Dana DeLouis[_3_]	3	568
If 5th character="-" delete everything to the left otherwise do no Mike R.	by Rick Rothstein	6	1,198
Summarizing data assigned to a label Al Davis	by T. Valko	2	709
how do I round a column of numbers to the nearest Suzy	by T. Valko	3	1,756
Pivot table help Yossy	by Shane Devenshire[_2_]	1	619
If Than Statement Xfree	by Xfree	3	691
split print area in excel - One Page Print Cyhill	by Cyhill	3	3,398
Count with criteria NM	by NM	5	705
How do I re arrange numbers Raz	by Pete_UK	3	733
Help! Minimum Excluding zeros across multiple sheets [email protected]	by [email protected]	5	3,187
Second Saturday Of The Month FrankM	by Ron Rosenfeld	11	3,648
What's causing error message? Jim Tibbetts	by Peo Sjoblom[_2_]	4	879
Referencing an active cell's content from another sheet. emon	by emon	2	809
copy a cell value based on search of another cell Pendal	by Pete_UK	1	898
multiple ranges, transposing? Mea	by Herbert Seidenberg	19	1,555
Conditional format entire row from one cell Shanie	by Shane Devenshire[_2_]	2	667
cell lookup Excel Challenged	by John C[_2_]	2	511
IF AND statements bob	by John C[_2_]	6	693