Excel Worksheet Functions - Page 26

Thread / Thread Starter	Last Post	Replies	Views
Vlookup a subtotal pfaxange18	by Claus Busch	2	2,455
Display next available number corewin	by Claus Busch	1	770
Extract Date formula Only [email protected]	by [email protected]	8	1,183
Return a value if a range of cells contain text the-chauffeur	by the-chauffeur	2	1,503
Vlookup Returning Zero For Every Cell Clorber	by Spencer101	1	957
Search for string based on two columns Harroon	by Claus Busch	2	917
Search a range for instances of a text string, return neighboring cell values each ti excelroofing	by excelroofing	2	938
Help with complex IF statement D4WNO	by Claus Busch	1	715
Complex Lookups MartinSvan	by MartinSvan	6	1,132
I can't see the cell reference (i.e A, B, C, 1, 2, 3). How do I . Aimee T	by Zulma	3	1,214
reverse a series of numbers from 1 cell into another [email protected]	by sugantha priya	5	1,771
calculate last 4 data points in a column (with sometimes blank rows) puck1263	by puck1263	9	1,564
Problem with formula for finding last greater than/less than or equal to value DubyaG	by plinius	2	1,021
Unable to nest my IF statements properly D4WNO	by Don Guillett[_2_]	2	752
IF and IF and IF Ramona88	by Stan Brown	7	1,216
Deriving several lists from a master list John Tonitto	by John Tonitto	3	931
display Column Header based on cell value in a range juanvaldez	by juanvaldez	2	1,329
Using IF and VLOOKUP for range of cells JamesTris	by JamesTris	5	1,025
Calculating days spent to complete a task Noia	by Noia	2	956
Wage Calculator Q [email protected]	by Spencer101	1	648
Making data in appear in one worksheet from another MarkFarrers	by MarkFarrers	2	889
Possible to determine whether any one instance within many satisfy a criteria? spamdavy	by spamdavy	3	964
Referencing an External Cell Troy1973	by Spencer101	1	815
Sum of values in column A based on 0/1 of column B Wael2029	by Wael2029	2	838
How to calculate difference between two date & time along with working hours and days tarpan9444	by plinius	2	1,402
Allot Seats to Students based on Choice & Percentage v999	by v999	0	821
How do I set a maximum amount in a cell? Griffindor107	by JOP19	4	1,951
Help! Is this possible KENSONE	by Don Guillett[_2_]	2	759
Compare 2 lists and return value KENSONE	by Don Guillett[_2_]	1	676
Excel time leading 1st ZERO Jaime[_4_]	by [email protected]	3	828
Solve for a number (x) RG[_4_]	by [email protected]	2	786
How to work out working hours? D4WNO	by Spencer101	1	870
If Statement in Database Query pmcook1979	by pmcook1979	1	784
Sorting by frequency [email protected]	by [email protected]	2	852
Findiing highest and lowest in rows and columns NetNathan1	by NetNathan1	3	832
Urgent help with Excel formula. Please please help Rashid.adam	by Claus Busch	1	821
Horizontal FILTER!! Maniv	by dusk	4	3,830
Conditional concatenating!!! managingcrap	by plinius	4	1,093
Compressing multiple functions across an array into one cell Nick Sabo	by Nick Sabo	8	1,694
Excel: Probility J.Mac	by J.Mac	0	757
Filtering Spreadsheets Using Multivariable "Or" Statements Manu887	by Manu887	0	710
conditional formatting update issue Colin Hayes	by [email protected]	5	1,020
Joining VLookups with line breaks but ignoring blanks Andy Roberts[_3_]	by Ron Rosenfeld[_2_]	3	1,039
Command Button to create a folder Andy Roberts[_3_]	by Andy Roberts[_3_]	0	814
Multiple Nested If Function Sher10	by Claus Busch	6	1,156
SumIf and Vlookup together? cmillls45	by cmillls45	0	1,230
One lookup option mpom	by Don Guillett[_2_]	3	892
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Claus Busch	5	1,544
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Excelerated	0	895
Countif year = help needed saffron	by Spencer101	5	1,299
Solver Compiler issue David Wong	by Claus Busch	2	854
Sum of Variable Cells in a fixed Row VinB	by VinB	3	1,080
countif, isna, or vlookup Jenniferpod	by Claus Busch	2	1,394
Calculating the difference, in hours, between two date/time in two different time zon gmccray	by gmccray	5	1,774
sum product if r2rcode	by vinayp	3	3,884
Conditional Formatting discarding zeros Jwest616	by joeu2004[_2_]	1	954
conditional formatting for cell date to equal today's date Sistereinstein	by bprime	2	5,365
Help in Median of a quartile LFCDRM	by joeu2004[_2_]	7	1,403
Index Match function for lookup HELP Skye1973	by joeu2004[_2_]	7	980
How do I convert cubic feet to cubic meters? [email protected]	by [email protected]	0	3,586
Formatting a spreadsheet to calculate difference in dates etc. Craig Padded Smith	by Ron Rosenfeld[_2_]	2	1,107
Totaling Categories - Monthly and YTD Jackson[_4_]	by Jackson[_4_]	2	709
VLOOKUP Help chines706	by CellShocked	4	723
Lookup function to return highest value BDAvs	by Paga Mike	1	732
Lookup function to return highest value BDAvs	by Claus Busch	4	1,087
Calculating nr of books a certain author has published wolverine2710	by wolverine2710	2	889
consolidation data in one row jnayak	by zvkmpw	2	775
Array formula lock-up [email protected]	by [email protected]	1	1,106
table to single row nate hubert	by Pete_UK[_8_]	2	894
Thank you Bruno!! One last question - "Test2.xlsx" 7948 Bytes yEnc Bruno Campanini[_2_]	by Bruno Campanini[_2_]	0	721
create an expense requisition form desesperada123	by [email protected]	3	2,479
Complex IF formula Evan	by James Kay	5	2,558
AverageIf function with multiple columns wolf8girl	by Ron Rosenfeld[_2_]	1	834
Use an "OR" around nested IF statements KeriM	by joeu2004[_2_]	3	902
calulation Surazal	by joeu2004[_2_]	1	753