Excel Worksheet Functions - Page 1159

Thread / Thread Starter	Last Post	Replies	Views
Compare a column of substring with another column of strings and get count Shanmu	by Shanmu	0	695
need help with Formula AshKhan	by AshKhan	2	1,037
Formulas won't function mapnet	by [email protected]	3	863
Multiple Criteria Lookup JIMCREWE	by JIMCREWE	3	850
Preserving trailing zeros for a fixed width file Danielle[_2_]	by Danielle[_2_]	0	680
Logical formatting for multiple values Danielle[_2_]	by Claus Busch	1	647
Muti-result for lookup function rcc03461	by rcc03461	0	782
Lookup Value From Sheet2 dlawrie	by CellShocked	2	908
Countif with dates mleeangel	by Spencer101	1	1,016
Extract Alphabets and Numbers from a Cell tahir4awan	by Spencer101	3	883
preserving zeros in spreadsheet Danielle[_2_]	by Danielle[_2_]	0	626
range definition by cells numbers tuli	by tuli	3	828
Trying to count based on multiple criteria & cell comparisons theokester	by theokester	4	1,097
Possible Sumproduct with Or Function OllyR	by Don Guillett[_2_]	2	919
Count everything in a Column "except" Richard Horn[_2_]	by aynosgold	3	2,879
Change font size of Combo Box from Form tools tahir4awan	by Ron Rosenfeld[_2_]	6	1,188
Formula to group into Age Ranges Donna	by ExpectedlyUnexpected	6	5,643
coding descriptors cphgeo	by cphgeo	5	1,123
Counting number of days in several periods ignoring repeating dates sergeten	by plinius-et	5	1,209
Club Accounts Bampah	by Cimjet[_4_]	2	852
Price Elasticity STORMIE	by STORMIE	0	760
Computer Properties tuli	by GS[_2_]	1	705
Extract the 2 Lowest % [email protected]	by [email protected]	3	749
Calculating time for 3rd shift [email protected]	by [email protected]	4	1,026
how to count rows if 2 columns partially match Qikstart	by Ron Rosenfeld[_2_]	5	1,032
Convert number to word in indian currency Sudipta Sen[_2_]	by Arpit Dewan	3	6,417
Postal code to Area translation idxearo	by Spencer101	5	1,029
Splitting a number in one cell into other cells Kim.P	by Spencer101	1	1,007
Please Help! Delete all cells in range except "1934 - 1934" cdubuque	by Living the Dream	1	771
Combining Nested IF statement with Between operator Daisy	by gid951	3	2,675
help w indirect and index,match excelhelp_84	by excelhelp_84	4	1,371
Name break into half and reverse to upper case shrinivasmj	by Claus Busch	1	832
Adding a letter to the start of each cell Colin Hayes	by [email protected]	6	1,152
Table "What If" Set Up If I Change One Or Two Variables [email protected]	by Spencer101	1	846
INDEX MATCH SMALL [email protected]	by [email protected]	13	1,762
Sort column beginning with blank? Pete[_25_]	by Pete[_25_]	1	817
Help needed: Minimum value based upon either/or criteria Mfreit	by Mfreit	3	817
Help Needed! Using complex IF function John Ball	by joeu2004[_2_]	3	988
Generate 1 or 0 in xls with input probability Morinne	by plinius	2	760
Simple COUNTIF function help zctpec3	by zctpec3	4	900
Convert Number to Text for Index/Match [email protected]	by jack_n_bub	2	2,358
Auto generate invoices JOJO193	by Bushra Singh	1	1,089
Vlookup CH Coffieid	by Claus Busch	2	861
Need a function to match unidentical strings LoneTraveler	by LoneTraveler	0	744
Date reformatting question DateNightmare	by joeu2004[_2_]	6	1,062
How to do a lookup with 2 parameters? brianlee89	by brianlee89	1	755
Countif with two criteria [email protected]	by [email protected]	2	819
Copy values for every nth cell dpgreen	by dpgreen	18	2,313
Conditional Formatting - Assistance Please :( khenry	by Spencer101	1	870
Median Formula not working properly RK_Excel	by joeu2004[_2_]	2	1,229
Summing up cells based on names in adjoining cells - I'm new to using functions Stupidparrpt	by Stupidparrpt	2	783
LOOKUP function?? [email protected]	by [email protected]	5	937
Remove punctuation mark, Split cells & average accross column Gautam Bhut	by Gautam Bhut	4	932
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,218
Sunday Dale[_4_]	by Michael (Micky) Avidan	8	1,724
Count value in range, but exclude based on adjacent value. amacrab	by Spencer101	4	941
Stumped on how to complete. Pinnum	by Pinnum	0	716
Help on the Sumif Function matt_writer	by joeu2004[_2_]	1	679
Time Zone Conversion Table naven_sg	by Ron Rosenfeld[_2_]	2	740
Help. Trying to do the opposite of VLOOKUP Randy Sauve	by plinius	3	1,074
Setting a range in a named range Askjerry	by Ron Rosenfeld[_2_]	3	739
VLOOKUP or SUMIF for Multiple Criteria Rob Kein	by Kevin@Radstock	2	977
Pls Help - blank cell/formula issue Shokra	by Claus Busch	8	1,578
Search Text and Add a Blank Line kojack	by kojack	2	715
Using IF, AND and OR functions together ahs004	by Claus Busch	2	747
Month Calculation Moideen	by Moideen	5	850
Formula I can't figure out dpgreen	by dpgreen	2	699
Display yesterday's date but only for weekdays? totalnatal	by Ron Rosenfeld[_2_]	8	1,269
Scaling multiple columns Arto Vesterbacka	by Arto Vesterbacka	0	594
Return Column Header from an Index/array, finding Large with a userinput date alovell	by alovell	0	769
Validation of cell based on Drop down list murtaza7210	by Claus Busch	1	649
Need help finding a substring in a array of strings. hvcrios	by Claus Busch	1	713
Evaluate Multiple Cells for any Value Billy Daniel	by GS[_2_]	1	735
Multiple VLOOKUP in an IF statement Richard Doyle	by Claus Busch	2	722
Standar deviation across sheets help ibressler	by ibressler	0	668