Excel Worksheet Functions - Page 26

Thread / Thread Starter	Last Post	Replies	Views
Vlookup a subtotal pfaxange18	by Claus Busch	2	2,453
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	955
Search for string based on two columns Harroon	by Claus Busch	2	913
Search a range for instances of a text string, return neighboring cell values each ti excelroofing	by excelroofing	2	936
Help with complex IF statement D4WNO	by Claus Busch	1	713
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,212
reverse a series of numbers from 1 cell into another [email protected]	by sugantha priya	5	1,769
calculate last 4 data points in a column (with sometimes blank rows) puck1263	by puck1263	9	1,563
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,215
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,328
Using IF and VLOOKUP for range of cells JamesTris	by JamesTris	5	1,024
Calculating days spent to complete a task Noia	by Noia	2	955
Wage Calculator Q [email protected]	by Spencer101	1	646
Making data in appear in one worksheet from another MarkFarrers	by MarkFarrers	2	887
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	814
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,401
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,948
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	826
Solve for a number (x) RG[_4_]	by [email protected]	2	784
How to work out working hours? D4WNO	by Spencer101	1	869
If Statement in Database Query pmcook1979	by pmcook1979	1	784
Sorting by frequency [email protected]	by [email protected]	2	851
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	820
Horizontal FILTER!! Maniv	by dusk	4	3,830
Conditional concatenating!!! managingcrap	by plinius	4	1,092
Compressing multiple functions across an array into one cell Nick Sabo	by Nick Sabo	8	1,693
Excel: Probility J.Mac	by J.Mac	0	757
Filtering Spreadsheets Using Multivariable "Or" Statements Manu887	by Manu887	0	709
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	812
Multiple Nested If Function Sher10	by Claus Busch	6	1,155
SumIf and Vlookup together? cmillls45	by cmillls45	0	1,146
One lookup option mpom	by Don Guillett[_2_]	3	891
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Claus Busch	5	1,543
Function to Combine Names and Middle Initital In Various Formats Excelerated	by Excelerated	0	893
Countif year = help needed saffron	by Spencer101	5	1,299
Solver Compiler issue David Wong	by Claus Busch	2	853
Sum of Variable Cells in a fixed Row VinB	by VinB	3	1,080
countif, isna, or vlookup Jenniferpod	by Claus Busch	2	1,392
Calculating the difference, in hours, between two date/time in two different time zon gmccray	by gmccray	5	1,771
sum product if r2rcode	by vinayp	3	3,883
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,327
Help in Median of a quartile LFCDRM	by joeu2004[_2_]	7	1,400
Index Match function for lookup HELP Skye1973	by joeu2004[_2_]	7	978
How do I convert cubic feet to cubic meters? [email protected]	by [email protected]	0	3,584
Formatting a spreadsheet to calculate difference in dates etc. Craig Padded Smith	by Ron Rosenfeld[_2_]	2	1,105
Totaling Categories - Monthly and YTD Jackson[_4_]	by Jackson[_4_]	2	708
VLOOKUP Help chines706	by CellShocked	4	721
Lookup function to return highest value BDAvs	by Paga Mike	1	731
Lookup function to return highest value BDAvs	by Claus Busch	4	1,085
Calculating nr of books a certain author has published wolverine2710	by wolverine2710	2	887
consolidation data in one row jnayak	by zvkmpw	2	773
Array formula lock-up [email protected]	by [email protected]	1	1,104
table to single row nate hubert	by Pete_UK[_8_]	2	892
Thank you Bruno!! One last question - "Test2.xlsx" 7948 Bytes yEnc Bruno Campanini[_2_]	by Bruno Campanini[_2_]	0	720
create an expense requisition form desesperada123	by [email protected]	3	2,477
Complex IF formula Evan	by James Kay	5	2,550
AverageIf function with multiple columns wolf8girl	by Ron Rosenfeld[_2_]	1	832
Use an "OR" around nested IF statements KeriM	by joeu2004[_2_]	3	902
calulation Surazal	by joeu2004[_2_]	1	753