Excel Worksheet Functions - Page 26

Thread / Thread Starter	Last Post	Replies	Views
Vlookup a subtotal pfaxange18	by Claus Busch	2	2,444
Display next available number corewin	by Claus Busch	1	763
Extract Date formula Only [email protected]	by [email protected]	8	1,167
Return a value if a range of cells contain text the-chauffeur	by the-chauffeur	2	1,495
Vlookup Returning Zero For Every Cell Clorber	by Spencer101	1	946
Search for string based on two columns Harroon	by Claus Busch	2	896
Search a range for instances of a text string, return neighboring cell values each ti excelroofing	by excelroofing	2	923
Help with complex IF statement D4WNO	by Claus Busch	1	692
Complex Lookups MartinSvan	by MartinSvan	6	1,119
I can't see the cell reference (i.e A, B, C, 1, 2, 3). How do I . Aimee T	by Zulma	3	1,201
reverse a series of numbers from 1 cell into another [email protected]	by sugantha priya	5	1,751
calculate last 4 data points in a column (with sometimes blank rows) puck1263	by puck1263	9	1,534
Problem with formula for finding last greater than/less than or equal to value DubyaG	by plinius	2	1,003
Unable to nest my IF statements properly D4WNO	by Don Guillett[_2_]	2	741
IF and IF and IF Ramona88	by Stan Brown	7	1,203
Deriving several lists from a master list John Tonitto	by John Tonitto	3	922
display Column Header based on cell value in a range juanvaldez	by juanvaldez	2	1,311
Using IF and VLOOKUP for range of cells JamesTris	by JamesTris	5	1,010
Calculating days spent to complete a task Noia	by Noia	2	946
Wage Calculator Q [email protected]	by Spencer101	1	631
Making data in appear in one worksheet from another MarkFarrers	by MarkFarrers	2	872
Possible to determine whether any one instance within many satisfy a criteria? spamdavy	by spamdavy	3	947
Referencing an External Cell Troy1973	by Spencer101	1	799
Sum of values in column A based on 0/1 of column B Wael2029	by Wael2029	2	825
How to calculate difference between two date & time along with working hours and days tarpan9444	by plinius	2	1,387
Allot Seats to Students based on Choice & Percentage v999	by v999	0	812
How do I set a maximum amount in a cell? Griffindor107	by JOP19	4	1,909
Help! Is this possible KENSONE	by Don Guillett[_2_]	2	751
Compare 2 lists and return value KENSONE	by Don Guillett[_2_]	1	668
Excel time leading 1st ZERO Jaime[_4_]	by [email protected]	3	818
Solve for a number (x) RG[_4_]	by [email protected]	2	765
How to work out working hours? D4WNO	by Spencer101	1	859
If Statement in Database Query pmcook1979	by pmcook1979	1	771
Sorting by frequency [email protected]	by [email protected]	2	845
Findiing highest and lowest in rows and columns NetNathan1	by NetNathan1	3	815
Urgent help with Excel formula. Please please help Rashid.adam	by Claus Busch	1	804
Horizontal FILTER!! Maniv	by dusk	4	3,824
Conditional concatenating!!! managingcrap	by plinius	4	1,083
Compressing multiple functions across an array into one cell Nick Sabo	by Nick Sabo	8	1,677
Excel: Probility J.Mac	by J.Mac	0	740
Filtering Spreadsheets Using Multivariable "Or" Statements Manu887	by Manu887	0	703
conditional formatting update issue Colin Hayes	by [email protected]	5	1,006
Joining VLookups with line breaks but ignoring blanks Andy Roberts[_3_]	by Ron Rosenfeld[_2_]	3	1,021
Command Button to create a folder Andy Roberts[_3_]	by Andy Roberts[_3_]	0	807
Multiple Nested If Function Sher10	by Claus Busch	6	1,147
SumIf and Vlookup together? cmillls45	by cmillls45	0	1,134
One lookup option mpom	by Don Guillett[_2_]	3	884
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Claus Busch	5	1,520
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Excelerated	0	885
Countif year = help needed saffron	by Spencer101	5	1,286
Solver Compiler issue David Wong	by Claus Busch	2	824
Sum of Variable Cells in a fixed Row VinB	by VinB	3	1,071
countif, isna, or vlookup Jenniferpod	by Claus Busch	2	1,375
Calculating the difference, in hours, between two date/time in two different time zon gmccray	by gmccray	5	1,747
sum product if r2rcode	by vinayp	3	3,878
Conditional Formatting discarding zeros Jwest616	by joeu2004[_2_]	1	925
conditional formatting for cell date to equal today's date Sistereinstein	by bprime	2	5,284
Help in Median of a quartile LFCDRM	by joeu2004[_2_]	7	1,390
Index Match function for lookup HELP Skye1973	by joeu2004[_2_]	7	969
How do I convert cubic feet to cubic meters? [email protected]	by [email protected]	0	3,558
Formatting a spreadsheet to calculate difference in dates etc. Craig Padded Smith	by Ron Rosenfeld[_2_]	2	1,099
Totaling Categories - Monthly and YTD Jackson[_4_]	by Jackson[_4_]	2	694
VLOOKUP Help chines706	by CellShocked	4	711
Lookup function to return highest value BDAvs	by Paga Mike	1	724
Lookup function to return highest value BDAvs	by Claus Busch	4	1,076
Calculating nr of books a certain author has published wolverine2710	by wolverine2710	2	869
consolidation data in one row jnayak	by zvkmpw	2	766
Array formula lock-up [email protected]	by [email protected]	1	1,089
table to single row nate hubert	by Pete_UK[_8_]	2	884
Thank you Bruno!! One last question - "Test2.xlsx" 7948 Bytes yEnc Bruno Campanini[_2_]	by Bruno Campanini[_2_]	0	708
create an expense requisition form desesperada123	by [email protected]	3	2,441
Complex IF formula Evan	by James Kay	5	2,518
AverageIf function with multiple columns wolf8girl	by Ron Rosenfeld[_2_]	1	812
Use an "OR" around nested IF statements KeriM	by joeu2004[_2_]	3	894
calulation Surazal	by joeu2004[_2_]	1	745