Excel Worksheet Functions - Page 1168

Thread / Thread Starter	Last Post	Replies	Views
Finding the weighted average of text that have been given values [email protected]	by [email protected]	2	751
Formula than understands midnight? Auric__	by Auric__	26	2,488
Making a Sheet copy [email protected]	by GS[_2_]	3	555
Need to get minimum difference sleek	by sleek	1	546
Values from one sheet appearing in another sheet SueSuth	by SueSuth	0	492
Regression Coefficient Standard Error [email protected]	by [email protected]	0	599
Copy corresponding cell in Column B if cell in A contains certain text? Austin George	by Don Guillett[_2_]	1	612
Percentage of month passed formula Mary128	by Ron Rosenfeld[_2_]	1	973
how to count number of pages in worksheet msnews	by Sabeel Ather M G	9	1,507
Help Amanda Parks	by MyVeryOwnSelf[_3_]	1	586
Sum every Nth Row (almost working) [email protected]	by Kevin@Radstock	2	727
how do i replace #n/a in a vlookup? infinite1013	by [email protected]	17	4,185
Help with sumproduct Jay07	by joeu2004[_2_]	2	638
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) OutdoorRuss	by Claus Busch	1	611
Drop Down with dynamic named range offsheet source list L. Howard	by GS[_2_]	14	1,660
Vlookup an array and report min, max and average as a result Curios101	by Claus Busch	6	1,320
Finding missorted cell in range Walter Briscoe	by Walter Briscoe	0	718
Change positive to negative number Sandra	by Lisa Wilke-Thissen	5	1,463
IF and VLOOKUP by date overwrite problem JBMcD	by JBMcD	0	611
VBA to Filter on variable column Colin Hayes	by Colin Hayes	5	722
Index match formula with multiple conditions GijsKijlstra	by GS[_2_]	6	1,132
year cant change [email protected]	by Auric__	3	773
How to enter start and end date/time in excel based on some specific value. abhi garg	by Ron Rosenfeld[_2_]	2	682
Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL John C[_7_]	by John C[_7_]	0	596
Reference the same cell based on tab name [email protected]	by Claus Busch	1	550
Protect worksheet - prevent changes to unlock cells formatting CS Chia	by CS Chia	0	538
conversion of book bar code to ISBN GrahamBookman	by straw00berry	5	1,461
Converting formula from Lotus123 to Excel Lisa V	by joeu2004[_2_]	2	612
hidden rows problem ataur rahman rony	by ataur rahman rony	7	710
worksheet is not open and copy ataur rahman rony	by ataur rahman rony	0	611
Cell Auto Lock Moideen	by Gord Dibben[_2_]	2	777
EAN/UCC-14 Barcode: set Excel column widths based on a cell value? d	by derek054	1	1,115
How to add straight line from cell value in pivot table chart. mehmood	by mehmood	0	698
Two spreadsheets, filling data from one to the other. [email protected]	by [email protected]	0	639
Insert/ delete row in protected worksheet [email protected]	by [email protected]	0	758
Count multiple specific terms masking	by Claus Busch	1	645
Augmenting an integer in a column to reflect duplicates in another Colin Hayes	by Colin Hayes	23	2,277
Is multiple IF statements what I'm looking for? Synapses	by joeu2004[_2_]	2	670
want to track time while paste value in multiple column of same roe [email protected]	by GS[_2_]	1	857
Check for two sheets. Add or subtract as necessary. Colin Hayes	by Colin Hayes	2	636
Is it possible to make Excel assume a time happens after another time? [email protected]	by Howard Silcock	1	977
return a value of specific text within a sentence top00001	by Claus Busch	1	804
Google Adsense Account Approval Tricks [email protected]	by [email protected]	0	845
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS [email protected]	by Ron Rosenfeld[_2_]	2	1,337
Rounding value from millions to decimal places Bagia	by Whydidjuly	7	3,467
difference between two cells jeromeUAE	by jeromeUAE	2	774
Weighted average till sum of exposure reaches a threshold [email protected]	by [email protected]	0	897
Really need some help with a multi conditional SumProduct Keelin George	by [email protected]	1	787
Convert Decimal fractions to binary and vice versa [email protected]	by Ron Rosenfeld[_2_]	2	4,281
Complex search and replace macro based on input variables. Colin Hayes	by GS[_2_]	12	1,787
What formula would i need for this?? samshepcap	by joeu2004[_2_]	1	1,171
How do I update my worksheet? Need Help [email protected]	by [email protected]	0	1,085
Excel Macros help [email protected]	by [email protected]	0	1,035
Time Zone Conversions Jeff Kohl	by Claus Busch	4	1,629
non repeating Random number generation [email protected]	by [email protected]	0	765
Return Min & Cell address L. Howard	by L. Howard	7	1,175
ADVANCED: Need to sum values in different worksheets based on a rowand column criteria. [email protected]	by [email protected]	0	878
Sum of Result formula six777	by six777	0	772
SUMIF, 3D FORMULA, EXCEL FORMULA HELP [email protected]	by Claus Busch	1	1,975
Those who cheat SuckSeed Negrovich Hunt	by Negrovich Hunt	0	1,623
Can I use solver for this?? ulna	by ulna	0	1,490
#N/A In Cells tb	by tb	7	1,860
Autofill Formulas edwinhwhw87	by Walter Briscoe	5	2,312
If/Then functions Grimsgrin	by Ron Rosenfeld[_2_]	1	1,845
Need a formula which shows the table.. akinkaraman	by akinkaraman	3	1,898
Upgrade question Colin Hayes	by joeu2004[_2_]	3	1,750
How do I get Rid of the Circumflex Accent (Caret) tb	by Gord Dibben[_2_]	2	2,796
Dynamic col_index_num in VLOOKUP? tb	by San[_4_]	5	2,813
An Eye for an Eye Are Are \| Excel IRR_NEW function Discounted Dollar	by Discounted Dollar	0	1,904
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that San[_4_]	by San[_4_]	12	2,355
is it posible to have a formula for factorial via vba code? thread	by [email protected]	4	1,687
Match a UK postcode from a table of postcodes Chris Smith[_5_]	by Chris Smith[_5_]	0	1,235
RETURN VALUE OF ROW 1 Chris Smith[_5_]	by Chris Smith[_5_]	0	767
Subtracting based on 2 conditions [email protected]	by [email protected]	3	1,152
Proper Formula is stuck and does not work Diggsy	by [email protected]	6	2,291