Excel Worksheet Functions - Page 1158

Thread / Thread Starter	Last Post	Replies	Views
Countif year = help needed saffron	by Spencer101	5	1,286
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Excelerated	0	885
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Claus Busch	5	1,523
One lookup option mpom	by Don Guillett[_2_]	3	884
SumIf and Vlookup together? cmillls45	by cmillls45	0	1,137
Multiple Nested If Function Sher10	by Claus Busch	6	1,147
Command Button to create a folder Andy Roberts[_3_]	by Andy Roberts[_3_]	0	807
Joining VLookups with line breaks but ignoring blanks Andy Roberts[_3_]	by Ron Rosenfeld[_2_]	3	1,023
conditional formatting update issue Colin Hayes	by [email protected]	5	1,007
Filtering Spreadsheets Using Multivariable "Or" Statements Manu887	by Manu887	0	703
Excel: Probility J.Mac	by J.Mac	0	744
Compressing multiple functions across an array into one cell Nick Sabo	by Nick Sabo	8	1,680
Conditional concatenating!!! managingcrap	by plinius	4	1,083
Horizontal FILTER!! Maniv	by dusk	4	3,825
Urgent help with Excel formula. Please please help Rashid.adam	by Claus Busch	1	805
Findiing highest and lowest in rows and columns NetNathan1	by NetNathan1	3	817
Sorting by frequency [email protected]	by [email protected]	2	845
If Statement in Database Query pmcook1979	by pmcook1979	1	771
How to work out working hours? D4WNO	by Spencer101	1	860
Solve for a number (x) RG[_4_]	by [email protected]	2	766
Excel time leading 1st ZERO Jaime[_4_]	by [email protected]	3	818
Compare 2 lists and return value KENSONE	by Don Guillett[_2_]	1	668
Help! Is this possible KENSONE	by Don Guillett[_2_]	2	751
How do I set a maximum amount in a cell? Griffindor107	by JOP19	4	1,918
Allot Seats to Students based on Choice & Percentage v999	by v999	0	816
How to calculate difference between two date & time along with working hours and days tarpan9444	by plinius	2	1,393
Sum of values in column A based on 0/1 of column B Wael2029	by Wael2029	2	829
Referencing an External Cell Troy1973	by Spencer101	1	804
Possible to determine whether any one instance within many satisfy a criteria? spamdavy	by spamdavy	3	953
Making data in appear in one worksheet from another MarkFarrers	by MarkFarrers	2	877
Wage Calculator Q [email protected]	by Spencer101	1	633
Calculating days spent to complete a task Noia	by Noia	2	948
Using IF and VLOOKUP for range of cells JamesTris	by JamesTris	5	1,014
display Column Header based on cell value in a range juanvaldez	by juanvaldez	2	1,317
Deriving several lists from a master list John Tonitto	by John Tonitto	3	925
IF and IF and IF Ramona88	by Stan Brown	7	1,205
Unable to nest my IF statements properly D4WNO	by Don Guillett[_2_]	2	742
Problem with formula for finding last greater than/less than or equal to value DubyaG	by plinius	2	1,005
calculate last 4 data points in a column (with sometimes blank rows) puck1263	by puck1263	9	1,535
reverse a series of numbers from 1 cell into another [email protected]	by sugantha priya	5	1,757
I can't see the cell reference (i.e A, B, C, 1, 2, 3). How do I . Aimee T	by Zulma	3	1,203
Complex Lookups MartinSvan	by MartinSvan	6	1,124
Help with complex IF statement D4WNO	by Claus Busch	1	694
Search a range for instances of a text string, return neighboring cell values each ti excelroofing	by excelroofing	2	925
Search for string based on two columns Harroon	by Claus Busch	2	898
Vlookup Returning Zero For Every Cell Clorber	by Spencer101	1	947
Return a value if a range of cells contain text the-chauffeur	by the-chauffeur	2	1,497
Extract Date formula Only [email protected]	by [email protected]	8	1,168
Display next available number corewin	by Claus Busch	1	764
Vlookup a subtotal pfaxange18	by Claus Busch	2	2,445
Benford law option available in Microsoft Excel Auditor	by [email protected]	3	2,034
How can I stop format change when copying data into unlocked cells Linty	by GraemeW	3	4,637
Parsing full name into salutation, First, middle, last, Suffix Ez Mozo	by Ron Rosenfeld[_2_]	1	1,340
How to sum more than 30 cells jmcclain	by [email protected]	9	1,443
Conditional Formatting - Dates RWilson	by RWilson	0	839
VLookup sum multiple matches NA1980	by Don Guillett[_2_]	1	1,265
Show latest date McClellan	by Don Guillett[_2_]	7	1,115
Distribution of capital contribution wabbleknee	by wabbleknee	4	1,187
Counting cells with SUMPRODUCT and conditionals...? numerologist	by joeu2004[_2_]	1	802
Excel 2010,Voice Win7 Skip[_2_]	by Skip[_2_]	0	829
Nested If Statement help DominicJ	by Don Guillett[_2_]	1	804
help! TYLER BOSSE	by joeu2004[_2_]	4	874
Add time when working 3rd shift [email protected]	by [email protected]	0	893
Series command grayed out Bob Bronstein	by isabelle	2	1,105
Detailed Countdown MartyD	by MartyD	2	903
Simple (maybe) percentage forumla Luthier	by Luthier	6	1,032
Convert number to text as displayed [email protected]	by Ron Rosenfeld[_2_]	3	923
Excel VBA macro, search - accumulate - delete original VictorP	by VictorP	0	954
Automatically sort alphabetically ignoring header EmzOLV	by EmzOLV	2	971
percentage calculation sumesh56	by sumesh56	5	1,128
Counting number of cells until a criteria is met m.barnes	by m.barnes	0	1,908
pivot table to show date ranges and if over date applesandpears	by applesandpears	1	952
Extract first and last login time for each day only [email protected]	by [email protected]	6	1,068
DATE Calculations in pivot table applesandpears	by applesandpears	0	695
Conditional Formatting Formula deutz	by Living the Dream	3	929