Excel Worksheet Functions - Page 16

Thread / Thread Starter	Last Post	Replies	Views
Complex search and replace macro based on input variables. Colin Hayes	by GS[_2_]	12	1,834
Convert Decimal fractions to binary and vice versa [email protected]	by Ron Rosenfeld[_2_]	2	4,332
Really need some help with a multi conditional SumProduct Keelin George	by [email protected]	1	814
Weighted average till sum of exposure reaches a threshold [email protected]	by [email protected]	0	908
difference between two cells jeromeUAE	by jeromeUAE	2	786
Rounding value from millions to decimal places Bagia	by Whydidjuly	7	3,496
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS [email protected]	by Ron Rosenfeld[_2_]	2	1,375
Google Adsense Account Approval Tricks [email protected]	by [email protected]	0	859
return a value of specific text within a sentence top00001	by Claus Busch	1	824
Is it possible to make Excel assume a time happens after another time? [email protected]	by Howard Silcock	1	1,014
Check for two sheets. Add or subtract as necessary. Colin Hayes	by Colin Hayes	2	656
want to track time while paste value in multiple column of same roe [email protected]	by GS[_2_]	1	884
Is multiple IF statements what I'm looking for? Synapses	by joeu2004[_2_]	2	696
Augmenting an integer in a column to reflect duplicates in another Colin Hayes	by Colin Hayes	23	2,303
Count multiple specific terms masking	by Claus Busch	1	670
Insert/ delete row in protected worksheet [email protected]	by [email protected]	0	783
Two spreadsheets, filling data from one to the other. [email protected]	by [email protected]	0	653
How to add straight line from cell value in pivot table chart. mehmood	by mehmood	0	730
EAN/UCC-14 Barcode: set Excel column widths based on a cell value? d	by derek054	1	1,142
Cell Auto Lock Moideen	by Gord Dibben[_2_]	2	796
worksheet is not open and copy ataur rahman rony	by ataur rahman rony	0	621
hidden rows problem ataur rahman rony	by ataur rahman rony	7	728
Converting formula from Lotus123 to Excel Lisa V	by joeu2004[_2_]	2	637
conversion of book bar code to ISBN GrahamBookman	by straw00berry	5	1,486
Protect worksheet - prevent changes to unlock cells formatting CS Chia	by CS Chia	0	551
Reference the same cell based on tab name [email protected]	by Claus Busch	1	583
Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL John C[_7_]	by John C[_7_]	0	614
How to enter start and end date/time in excel based on some specific value. abhi garg	by Ron Rosenfeld[_2_]	2	719
year cant change [email protected]	by Auric__	3	790
Index match formula with multiple conditions GijsKijlstra	by GS[_2_]	6	1,153
VBA to Filter on variable column Colin Hayes	by Colin Hayes	5	757
IF and VLOOKUP by date overwrite problem JBMcD	by JBMcD	0	620
Change positive to negative number Sandra	by Lisa Wilke-Thissen	5	1,493
Finding missorted cell in range Walter Briscoe	by Walter Briscoe	0	730
Vlookup an array and report min, max and average as a result Curios101	by Claus Busch	6	1,342
Drop Down with dynamic named range offsheet source list L. Howard	by GS[_2_]	14	1,696
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) OutdoorRuss	by Claus Busch	1	632
Help with sumproduct Jay07	by joeu2004[_2_]	2	641
how do i replace #n/a in a vlookup? infinite1013	by [email protected]	17	4,229
Sum every Nth Row (almost working) [email protected]	by Kevin@Radstock	2	758
Help Amanda Parks	by MyVeryOwnSelf[_3_]	1	601
how to count number of pages in worksheet msnews	by Sabeel Ather M G	9	1,532
Percentage of month passed formula Mary128	by Ron Rosenfeld[_2_]	1	1,000
Copy corresponding cell in Column B if cell in A contains certain text? Austin George	by Don Guillett[_2_]	1	636
Regression Coefficient Standard Error [email protected]	by [email protected]	0	635
Values from one sheet appearing in another sheet SueSuth	by SueSuth	0	501
Need to get minimum difference sleek	by sleek	1	564
Making a Sheet copy [email protected]	by GS[_2_]	3	569
Formula than understands midnight? Auric__	by Auric__	26	2,535
Finding the weighted average of text that have been given values [email protected]	by [email protected]	2	773
Limit drop down items based on another cell BDAvs	by Cimjet[_4_]	3	745
Countif or other formula needed for multiple data/critera results cdmartin	by MyVeryOwnSelf[_3_]	3	641
Generating new rows in a table when protected BDAvs	by BDAvs	0	507
Autofill alphanumeric prefix in Excel [email protected]	by [email protected]	2	805
conditional formatting only applies to part of cell text klkropf	by [email protected]	12	2,513
Using multiple Lookup Functions Gaura215	by L. Howard	1	599
Conditional Formatting on #VALUE! JE	by [email protected]	6	888
Transpose Cell Contents RB[_2_]	by Ron Rosenfeld[_2_]	1	783
add pass and fails [email protected]	by [email protected]	0	602
Date / month / year [email protected]	by Ron Rosenfeld[_2_]	1	692
Searching the formula (not the value) for a text string [email protected]	by joeu2004[_2_]	1	738
Testing the case of text in a cell Howard Silcock	by Howard Silcock	2	626
Calculate After hours [email protected]	by Claus Busch	3	607
Conditional Formatting Amendment Rob Nance	by Rob Nance	2	662
Pivot Table with Data Model Connection - getpivotdata reference issue Nirmalya Choudhury	by Nirmalya Choudhury	0	923
Formula to answer YES or No [email protected]	by [email protected]	4	777
Rounding Martina	by [email protected]	5	983
How can i put text in a cell depending on colour Esradekan	by Esradekan	0	677
How to copy formula with one cell constant Mark	by wabbleknee	6	1,614
Help With VLOOKUP tb	by tb	2	712
List items based on the count given CS Chia	by MyVeryOwnSelf[_3_]	4	917
Using =SUM...just can't figure this simple thing out... Naxzor	by Naxzor	2	705
how to copy and paste value from one sheet to another sumesh56	by sumesh56	4	735
COUNTIFS ? Malcolm Austin	by Malcolm Austin	1	702
copying_data_using_FillHandle via135	by via135	1	512