Excel Worksheet Functions - Page 503

Thread / Thread Starter	Last Post	Replies	Views
Autofilling Alpha-Numeric numbers with column headers JackofAllTrades	by Claus Busch	3	845
Aggregate multiple unique values and return top 5 dkinz	by Bruno Campanini[_2_]	3	1,116
Need help referencing b/w sheets for school project patW	by Spencer101	3	941
Using sumproduct function to count cell values on a remote workbook dylanb02	by dylanb02	3	1,005
Formula bryan gaudette	by darbary	3	921
Extract Date from text sabineb	by sabineb	3	773
Look Up Multiple Values And Returning One Value Annieeee	by isabelle	3	1,191
Sumproduct in matrix means Walter Briscoe	by joeu2004[_2_]	3	711
deleting numbers prefix Paula[_6_]	by isabelle	3	816
Complex Placings phil2026	by phil2026	3	961
averageif cell doesn't contain "text" dkte737	by Claus Busch	3	1,633
Formula to return a value in column B conditional upon the value in Column A JackofAllTrades	by JackofAllTrades	3	1,078
Using a CONCATENATE function with an IF function. JPP	by JPP	3	890
Conditional Formatting based on cell text Saucer Man	by Saucer Man	3	2,199
"Repeat Rows" - selected printed pages only CGat	by Gord Dibben[_2_]	3	4,418
Retreive data for same agent 818jaime	by 818jaime	3	680
Finding dates without attention to data formats Walter Briscoe	by Ron Rosenfeld[_2_]	3	700
Forecast of Inventory - Explaination of Calcuations tippytoe	by tippytoe	3	2,834
identify which years are contained within a range of dates robindra	by robindra	3	570
Remove numbers from text cells Jay07	by [email protected]	3	831
One lookup option mpom	by Don Guillett[_2_]	3	884
Sum of Variable Cells in a fixed Row VinB	by VinB	3	1,071
Use an "OR" around nested IF statements KeriM	by joeu2004[_2_]	3	894
Help with "IF" function chines706	by Spencer101	3	599
Don't know if it's possible, but... [email protected]	by Ron Rosenfeld[_2_]	3	805
Problem with averages.. Russell Pearce	by Spencer101	3	699
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION naga rajan	by joeu2004[_2_]	3	723
Multiple logic functions with multiple sums BARRETTMARKB	by Spencer101	3	953
combine three if functions robmin1983	by robmin1983	3	1,125
VLOOKUP Not working caverchik	by Mazzaropi	3	1,395
Need help with SUMIFs aagrawal	by aagrawal	3	835
Get sum of values in a cell based on unique values in another cell Shorabh	by Bruno Campanini[_2_]	3	741
If formula producing #VALUE Error KeriM	by joeu2004[_2_]	3	1,287
sumproduct old coach	by Claus Busch	3	801
countif and sumif [email protected]	by Claus Busch	3	772
Formula not being Friendly Mujer	by Living the Dream	3	863
Enabling Macros message when NO macros in workbook Jack Deuce	by Stan Brown	3	765
Separating data in a row into new rows MortenPetterson	by MortenPetterson	3	853
create an expense requisition form desesperada123	by [email protected]	3	2,444
If then Statement for Excel Columns zoio	by zoio	3	1,354
Help with SUMIFS Katie Wine	by mickrio	3	1,180
Hide/Unhide with cell double click bones288	by GS[_2_]	3	1,478
Average If carl	by joeu2004[_2_]	3	671
formula to disperse data to several worksheets BabsCreates	by Gord Dibben[_2_]	3	960
Highlighting duplicates across many sheets jpeevy	by GS[_2_]	3	1,545
Show time as a bar graph Gadgetman[_2_]	by Gadgetman[_2_]	3	1,775
Calculating what staff worked on which product DumDum	by GS[_2_]	3	872
Average of cells in a column if the top cell is a color Ana[_2_]	by Ana[_2_]	3	631
Subtraction from the lowest number postion wise in Column Gandaf	by Ron Rosenfeld[_2_]	3	868
Pivot table to calculate variance showing budget and actual. YY san.[_2_]	by tacoboy27	3	3,659
LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THATCOLUMN [email protected]	by [email protected]	3	752
sum product if r2rcode	by vinayp	3	3,878
Printing "Freeze Panes" sh2195	by j B	3	2,521
vlookup and Sum unique values Diggsy	by Robinhoodz	3	1,781
One-click hide or unhide rows & columns Togowa	by [email protected]	3	5,646
change sign of a column of figures from + to - Judith	by [email protected]	3	1,408
Date/Time Difference Excluding Weekends & Holidays Paula D	by steven_me	3	6,004
Create an array of separate cells Rickemil	by Ron Rosenfeld[_2_]	3	2,284
Using the IF and IFBLANK functions Superjase14	by Superjase14	3	766
How may I lookup and return a value between two numbers HGJ	by Mazzaropi	3	908
If, And Or Nick_GB	by Nick_GB	3	583
can I make an equation to count how many cells are filled below acertain cell? V L	by Cimjet[_3_]	3	821
Conditional Formatting Conundrum Suedonym	by GS[_2_]	3	594
Select minimum with duplicate values to return column headings Bobblebee	by isabelle	3	1,575
incrementing batches of numbers joe74	by joe74	3	847
Combine text under different condition chasiubao	by Ron Rosenfeld[_2_]	3	633
word count in Excel Help Needed 2	by listings	3	1,081
Unique Records in Column Yunus	by Gord Dibben[_2_]	3	604
Counting unique values based on 2 columns Tee51	by Vacuum Sealed	3	1,479
Formula Garry Oder	by joeu2004[_2_]	3	671
how to copy the contents into another cell? sumesh56	by Gord Dibben[_2_]	3	921
Count Blank Cells with Conditions CNWatsonJr	by CNWatsonJr	3	3,209
Match function fzl2007	by Don Guillett[_2_]	3	627
Returning a value that hasn't already been found azlan270690	by Ron Rosenfeld[_2_]	3	898
Function Error? Jackson[_3_]	by Don Guillett[_2_]	3	873